public function postContact(Request $request)
{
$this->validate($request, ['name' => 'required|min:3', 'email' => 'required|email', 'content' => 'required|min:10']);
\DB::transaction(function () use($request) {
Contact::create($request->all());
});
session()->flash('message', ['success', 'Thanks for contacting us, we\'ve received your request, be with you soon!']);
return redirect('/');
}
public function cancel(Request $request, $sn)
{
$refund = $this->resources->with('user', 'order')->where('user_id', '=', $request->user->id)->where('sn', '=', $sn)->firstOrFail();
\DB::transaction(function () use($id, $request, $refund) {
// 系统会自动退还可退还数量
$refund->cancel()->logs()->save(new RefundLog(['do' => 'cancel', 'name' => $request->user->name, 'comment' => $request->json()->get('comment', '')]));
$refund->order->total_refunded -= $refund->total_amount;
if ($refund->order->order_status == Order::STATUS_BRANCHED) {
$refund->order->branchRevert()->logs()->save(new OrderLog(['do' => 'branch_revert', 'name' => $request->user->name, 'comment' => 'branch revert']));
} else {
$refund->order->save();
}
});
return response()->updated($refund);
}
public function createOrder(CreateOrderRequest $request)
{
$order = \DB::transaction(function () use($request) {
$order = Order::create($request->all());
$order->reference = \Hashids::encode($order->id);
$order->save();
foreach (\Cart::content() as $item) {
$order->addItem($item);
}
return $order;
});
if ($order) {
return response()->json(['success' => true, 'reference' => $order->reference], 200);
}
return response()->json(['success' => false]);
}
public function oauthCallback(Request $request)
{
if ($request->get('state') == session('state')) {
$auth = new Auth(config('wechat.appid'), config('wechat.secret'));
$ouser = $auth->user();
if (!$ouser) {
abort('微信授权错误 #13101');
}
$sa = SocialAccount::where('openid', $ouser->get('openid'))->where('platform', 'wechat')->first();
if ($sa) {
\Auth::loginUsingId($ouser->user_id);
} else {
\DB::transaction(function () use($ouser, $auth) {
$user = User::create(['name' => $ouser->get('nickname', ''), 'username' => $ouser->get('platform') . '_' . $ouser->get('openid', ''), 'avatar' => $ouser->get('headimgurl')]);
SocialAccount::create(['user_id' => $user->id, 'access_token' => $auth->access_token, 'refresh_token' => $auth->refresh_token, 'platform' => 'wechat', 'openid' => $ouser->get('openid'), 'user_info' => json_encode($ouser), 'union_id' => $ouser->get('union_id', '')]);
\Auth::loginUsingId($user->id);
});
}
return redirect(route('home'));
} else {
abort('403', '服务器授权state不正确');
}
}
/**
* Create a new task.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$this->authorize('blog', Auth::user());
$this->validate($request, Post::storeRules());
$this->validate($request, Category::storeRules());
$this->validate($request, Tag::storeRules());
\DB::transaction(function () use($request) {
$post = Post::create(Post::storeAttributes($request));
$categories = explode(',', $request->categories);
// remove empty items from array
$categories = array_filter($categories);
// trim all the items in array
$categories = array_map('trim', $categories);
$post->saveCategories($categories);
$tags = explode(',', $request->tags);
// remove empty items from array
$tags = array_filter($tags);
// trim all the items in array
$tags = array_map('trim', $tags);
$post->saveTags($tags);
});
return redirect(route('blog'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
*
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$this->validate($request, ['title' => 'required|min:3', 'description' => 'min:3']);
$category = Category::find($id);
$old_title = $category->title;
if ($category) {
\DB::transaction(function () use($request, $category) {
$category->translate()->title = $request->get('title');
$category->translate()->description = $request->get('description');
$category->parent_id = $request->get('parent_id');
return $category->save();
});
}
session()->flash('message', ['success', "Your category has been updated from <strong><i>" . $old_title . "</i></strong> to <strong><i>" . $category->title . "</i></strong>, successfully!"]);
$categories = Category::with('translations')->paginate(10);
return view('dashboard.categories.index', compact('categories'));
}
/**
* Remove the specified resource from storage.
*
* @param int Categories $category
* @return Response
*/
public function destroy(Category $category)
{
\DB::transaction(function () use($category) {
$category->delete();
$this->categoryPAndCObj->where('child_id', '=', $category->id)->orWhere('parent_id', '=', $category->id)->delete();
\DB::table('member_categories')->where('category_id', '=', $category->id)->delete();
});
return Redirect::route('categories.index')->with('message', 'Category deleted.');
}
public function postFinishSignUp(SignUpFinish $req)
{
/** @var User $user */
$user = unserialize(session('signup.user'));
try {
\DB::transaction(function () use($req, $user) {
if ($req->email) {
$user->email = $req->email;
}
$user->username = $req->username;
$user->throwOnValidation = true;
//todo: https://github.com/laravel-ardent/ardent/issues/279
$user->save();
$this->saveLinks($user, true);
$this->saveLinks($user);
//those fields should not be "pulled" as an error might rise and their values can be reused in a 2nd try
session()->remove('signup.user');
session()->remove('signup.relations');
});
} catch (InvalidModelException $e) {
return redirect()->action('AuthController@getSignUp')->with('social_error', true)->with('provider', $req->provider)->withErrors($e->getErrors());
} catch (\Exception $e) {
\Log::error(class_basename($e) . ' during social auth (' . printr($_GET) . '): [' . $e->getCode() . '] ' . $e->getMessage());
return redirect()->action('AuthController@getSignUp')->with('social_error', true)->with('provider', $req->provider);
}
return $this->loginAfterSignUp($user, $req->provider);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
//make validations
$validator = Validator::make($request->all(), ['name' => 'required', 'email' => 'array']);
$validator->each('email', ['email']);
if ($validator->fails()) {
return redirect('room/create')->withErrors($validator)->withInput()->with('validation_err', true);
}
$room = new Room();
$room->name = $request->input('name');
$room->recording = empty($request->input('recording')) ? 0 : 1;
$room->public = empty($request->input('public')) ? 0 : 1;
$room->att_pass = Str::quickRandom(8);
$room->mod_pass = Str::quickRandom(8);
//add owner
$user = Auth::User();
$room->owner = $user->id;
//check if meeting id exists
\DB::transaction(function () use($room) {
//check for unique access_pin and meeting id
do {
$bbb_meeting_id = Str::quickRandom(8);
} while (Room::where('bbb_meeting_id', '=', $bbb_meeting_id)->count() != 0);
do {
$access_pin = mt_rand(0, 999999);
} while (Room::where('access_pin', '=', $access_pin)->count() != 0);
$room->bbb_meeting_id = $bbb_meeting_id;
$room->access_pin = $access_pin;
$room->save();
});
//extract emails
/*$mails = preg_split('/\r\n|\n|\r/', $request->input('participants'));
$part_mails = array();
foreach($mails as $mail){
$part_mail = filter_var($mail, FILTER_VALIDATE_EMAIL);
if($part_mail){
$participant = new Participant();
$participant->mail = $part_mail;
$participant->room_id = $room->id;
$participant->save();
}
}*/
$emails = $request->input('email');
$moderators = $request->input('moderator');
if (!$moderators) {
$moderators = array();
}
if (is_array($emails)) {
foreach ($emails as $email) {
$participant = new Participant();
$participant->mail = $email;
$participant->room_id = $room->id;
if (in_array($email, $moderators)) {
$participant->moderator = 1;
}
$participant->save();
}
}
return Redirect::action('roomController@own');
}
public function save(Request $request)
{
// sleep(2);
// return response()->json('[]');
// throw new Exception("not Save");
$postData = $request->all();
if (!array_key_exists('editedData', $postData) && !array_key_exists('deleteData', $postData)) {
return response()->json('no data 2 update!');
}
if (!array_key_exists('editedData', $postData)) {
$editedData = false;
} else {
$editedData = $postData['editedData'];
}
$facility_id = null;
if (array_key_exists('Facility', $postData)) {
$facility_id = $postData['Facility'];
}
$occur_date = null;
if (array_key_exists('date_begin', $postData)) {
$occur_date = $postData['date_begin'];
$occur_date = \Helper::parseDate($occur_date);
}
$affectedIds = [];
$this->preSave($editedData, $affectedIds, $postData);
try {
$resultTransaction = \DB::transaction(function () use($postData, $editedData, $affectedIds, $occur_date, $facility_id) {
$this->deleteData($postData);
if (!$editedData) {
return [];
}
$lockeds = [];
$ids = [];
$resultRecords = [];
// \DB::enableQueryLog();
foreach ($editedData as $mdlName => $mdlData) {
$modelName = $this->getModelName($mdlName, $postData);
$mdl = "App\\Models\\" . $modelName;
if ($mdl::$ignorePostData) {
unset($editedData[$mdlName]);
continue;
}
$ids[$mdlName] = [];
$resultRecords[$mdlName] = [];
$tableName = $mdl::getTableName();
$locked = \Helper::checkLockedTable($tableName, $occur_date, $facility_id);
if ($locked) {
$lockeds[$mdlName] = "Data of {$modelName} with facility {$facility_id} was locked on {$occur_date} ";
unset($editedData[$mdlName]);
continue;
}
foreach ($mdlData as $key => $newData) {
$columns = $mdl::getKeyColumns($newData, $occur_date, $postData);
$originNewData = $mdlData[$key];
$mdlData[$key] = $newData;
$returnRecord = $mdl::updateOrCreateWithCalculating($columns, $newData);
if ($returnRecord) {
$affectRecord = $returnRecord->updateDependRecords($occur_date, $originNewData, $postData);
$returnRecord->updateAudit($columns, $newData, $postData);
$ids[$mdlName][] = $returnRecord['ID'];
$resultRecords[$mdlName][] = $returnRecord;
if ($affectRecord) {
$ids[$mdlName][] = $affectRecord['ID'];
$resultRecords[$mdlName][] = $affectRecord;
}
}
}
$editedData[$mdlName] = $mdlData;
}
// \Log::info(\DB::getQueryLog());
// $objectIds = array_unique($objectIds);
//doFormula in config table
$affectColumns = [];
foreach ($editedData as $mdlName => $mdlData) {
$modelName = $this->getModelName($mdlName, $postData);
$cls = \FormulaHelpers::doFormula($modelName, 'ID', $ids[$mdlName]);
if (is_array($cls) && count($cls) > 0) {
$affectColumns[$mdlName] = $cls;
}
}
foreach ($resultRecords as $mdlName => $records) {
foreach ($records as $key => $returnRecord) {
$returnRecord->afterSaving($postData);
}
}
if ($this->isApplyFormulaAfterSaving) {
//get affected object with id
$objectWithformulas = [];
foreach ($editedData as $mdlName => $mdlData) {
$mdl = "App\\Models\\" . $mdlName;
foreach ($mdlData as $key => $newData) {
$columns = array_keys($newData);
if (array_key_exists($mdlName, $affectColumns)) {
$columns = array_merge($columns, $affectColumns[$mdlName]);
}
$uColumns = $mdl::getKeyColumns($newData, $occur_date, $postData);
$columns = array_diff($columns, $uColumns);
$aFormulas = $this->getAffectedObjects($mdlName, $columns, $newData);
$objectWithformulas = array_merge($objectWithformulas, $aFormulas);
}
}
$objectWithformulas = array_unique($objectWithformulas);
//apply Formula in formula table
$applieds = \FormulaHelpers::applyAffectedFormula($objectWithformulas, $occur_date);
if ($applieds && count($applieds)) {
foreach ($applieds as $apply) {
$mdlName = $apply->modelName;
if (!array_key_exists($mdlName, $ids)) {
$ids[$mdlName] = [];
}
$ids[$mdlName][] = $apply->ID;
$ids[$mdlName] = array_unique($ids[$mdlName]);
$resultRecords[$mdlName][] = $apply;
$resultRecords[$mdlName] = array_unique($resultRecords[$mdlName]);
}
}
}
$this->afterSave($resultRecords, $occur_date);
$resultTransaction = [];
if (count($lockeds) > 0) {
$resultTransaction['lockeds'] = $lockeds;
}
$resultTransaction['ids'] = $ids;
return $resultTransaction;
});
} catch (\Exception $e) {
\Log::info("\n----------------------hehe--------------------------------------------------------------------------\nException wher run transation\n ");
// \Log::info($e->getTraceAsString());
// return response($e->getMessage(), 400);
throw $e;
}
//get updated data after apply formulas
$updatedData = [];
if (array_key_exists('ids', $resultTransaction)) {
foreach ($resultTransaction['ids'] as $mdlName => $updatedIds) {
// $updatedData[$mdlName] = $mdl::findMany($objectIds);
$modelName = $this->getModelName($mdlName, $postData);
$mdl = "App\\Models\\" . $modelName;
$updatedData[$mdlName] = $mdl::findManyWithConfig($updatedIds);
}
}
// \Log::info(\DB::getQueryLog());
$results = ['updatedData' => $updatedData, 'postData' => $postData];
if (array_key_exists('lockeds', $resultTransaction)) {
$results['lockeds'] = $resultTransaction['lockeds'];
}
return response()->json($results);
}
/**
* Create a new annotation.
*
* @param document ID $doc
*
* @throws Exception
*
* @return 303 redirect to annotation link
*/
public function postIndex($doc)
{
$body = Input::all();
$body['doc_id'] = $doc;
$is_edit = false;
//Check for edit tag
if (in_array('edit', $body['tags'])) {
$is_edit = true;
//If no explanation present, throw error
if (!isset($body['explanation'])) {
throw new Exception('Explanation required for edits');
}
}
$id = \DB::transaction(function () use($body, $doc, $is_edit) {
$annotation = new Annotation();
$annotation->doc_id = $doc;
$annotation->user_id = Auth::user()->id;
$annotation->quote = $body['quote'];
$annotation->text = $body['text'];
$annotation->uri = $body['uri'];
$annotation->save();
foreach ($body['ranges'] as $range) {
$rangeObj = new AnnotationRange();
$rangeObj->annotation_id = $annotation->id;
$rangeObj->start_offset = $range['startOffset'];
$rangeObj->end_offset = $range['endOffset'];
$rangeObj->start = $range['start'];
$rangeObj->end = $range['end'];
$rangeObj->save();
}
$permissions = new AnnotationPermission();
$permissions->annotation_id = $annotation->id;
$permissions->user_id = Auth::user()->id;
$permissions->read = 1;
$permissions->update = 0;
$permissions->delete = 0;
$permissions->admin = 0;
$permissions->save();
foreach ($body['tags'] as $tag) {
$tagObj = new AnnotationTag();
$tagObj->annotation_id = $annotation->id;
$tagObj->tag = $tag;
$tagObj->save();
}
if ($is_edit) {
$comment = new AnnotationComment();
$comment->text = $body['explanation'];
$comment->user_id = $annotation->user_id;
$comment->annotation_id = $annotation->id;
$comment->save();
}
//$annotation->updateSearchIndex();
return $annotation->id;
});
$annotation = Annotation::find($id);
Event::fire(MadisonEvent::DOC_ANNOTATED, $annotation);
return Redirect::to('/api/docs/' . $doc . '/annotations/' . $id, 303);
}
/**
* @param Request $request
* @param Course $course
* @return \Illuminate\Http\RedirectResponse
*/
public function courseJudge(Request $request, Course $course)
{
$currentUser = Auth::getUser();
if ($this->commentRepository->checkCourseCommented($currentUser->stu_id, $course->id) === true) {
/* return to course page and show error */
return redirect()->to("/course/" . $course->id)->with(['error' => '您已經對該課程評鑑過囉！']);
} else {
/* comment confirm , call service calculate rank and call repository save course and comment */
if ($this->courseService->validateJudgeRequest($request->all())) {
\DB::transaction(function () use($course, $currentUser, $request) {
$comment = $this->commentRepository->createComment($course->id, $currentUser->stu_id, $request->all());
$this->courseService->UpdateCurrentRank($course, $comment);
});
return redirect()->to("/course/" . $course->id)->with(['success' => '恭喜完成評鑑！']);
} else {
return redirect()->back()->with(['error' => '尚有欄位沒填寫喔！']);
}
}
}
public function game_start($id)
{
$game = \App\Models\Game::find($id);
$players = \App\Models\Game_User::where('game_id', '=', $id)->get();
$can_start = false;
if ($game->min_players > $players->count()) {
return redirect('games')->withWarning('Error, this game need more players to start.');
}
if ($game->started) {
return redirect('games')->withWarning('Error, this game is already started.');
}
foreach ($players as $player) {
if ($player->user_id == Auth::user()->id) {
$can_start = true;
}
}
$letters = \App\Models\Letter::all();
\DB::transaction(function () use($letters, $id) {
foreach ($letters as $letter) {
$inventory = new \App\Models\Inventory_Letter_Game();
$inventory->letter_id = $letter->id;
$inventory->quantity = $letter->quantity;
$inventory->game_id = $id;
$inventory->save();
}
});
$game->started = true;
$game->save();
\Event::fire(new \App\Events\GameStart($id));
return redirect('gamejoin/' . $id);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(MemberEntity $memberEnt)
{
\DB::transaction(function () use($memberEnt) {
\DB::table('member_categories')->where('member_id', '=', $memberEnt->id)->delete();
\DB::table('member_social_ids')->where('member_id', '=', $memberEnt->id)->delete();
\DB::table('social_media')->where('member_id', '=', $memberEnt->id)->delete();
\DB::table('instagram_location_ids')->where('member_id', '=', $memberEnt->id)->delete();
\DB::table('members')->where('id', '=', $memberEnt->id)->delete();
});
return Redirect::route('members.index')->with('message', 'Member deleted.');
}
public function saveDocumentEdits($documentId)
{
if (!Auth::check()) {
return Redirect::to('documents')->with('error', 'You must be logged in');
}
$content = Input::get('content');
$contentId = Input::get('content_id');
if (empty($content)) {
return Redirect::to('documents')->with('error', "You must provide content to save");
}
if (!empty($contentId)) {
$docContent = DocContent::find($contentId);
} else {
$docContent = new DocContent();
}
if (!$docContent instanceof DocContent) {
return Redirect::to('documents')->with('error', 'Could not locate document to save');
}
$document = Doc::find($documentId);
if (!$document instanceof Doc) {
return Redirect::to('documents')->with('error', "Could not locate the document");
}
if (!$document->canUserEdit(Auth::user())) {
return Redirect::to('documents')->with('error', 'You are not authorized to save that document.');
}
$docContent->doc_id = $documentId;
$docContent->content = $content;
try {
\DB::transaction(function () use($docContent, $content, $documentId, $document) {
$docContent->save();
});
} catch (\Exception $e) {
return Redirect::to('documents')->with('error', "There was an error saving the document: {$e->getMessage()}");
}
//Fire document edited event for admin notifications
$doc = Doc::find($docContent->doc_id);
Event::fire(MadisonEvent::DOC_EDITED, $doc);
try {
$document->indexContent($docContent);
} catch (\Exception $e) {
return Redirect::to('documents')->with('error', "Document saved, but there was an error with Elasticsearch: {$e->getMessage()}");
}
return Redirect::to('documents')->with('success_message', 'Document Saved Successfully');
}
/**
* Refer action
*
* @return View
*/
public function referAction()
{
//Validate
$rules = array('referral-status' => 'required', 'facility_id' => 'required|non_zero_key', 'person', 'contacts');
$validator = Validator::make(Input::all(), $rules);
$specimenId = Input::get('specimen_id');
if ($validator->fails()) {
return view('test.refer', array($specimenId))->withInput()->withErrors($validator);
}
//Insert into referral table
$referral = new Referral();
$referral->status = Input::get('referral-status');
$referral->facility_id = Input::get('facility_id');
$referral->person = Input::get('person');
$referral->contacts = Input::get('contacts');
$referral->user_id = Auth::user()->id;
//Update specimen referral status
$specimen = Specimen::find($specimenId);
DB::transaction(function () use($referral, $specimen) {
$referral->save();
$specimen->referral_id = $referral->id;
$specimen->save();
});
//Start test
Input::merge(array('id' => $specimen->test->id));
//Add the testID to the Input
$this->start();
//Return view
$url = session('SOURCE_URL');
return redirect()->to($url)->with('message', trans('messages.specimen-successful-refer'))->with('activeTest', array($specimen->test->id));
}
public function submitJoin(Request $requests, $club)
{
$user = Auth::user();
$club = Club::findOrFail($club);
$relation = JoinAudit::where('user_id', $user->id)->where('club_id', $club)->first();
if (!($relation === null) and $relation->status != 2) {
return "你已经提交过申请啦";
}
$input = $requests->all();
$input['nickname'] = $user->nickname;
$join_requests = new JoinAudit($input);
try {
\DB::transaction(function () use($user, $club, $join_requests) {
$user->unauditedJoin()->save($join_requests);
$club->unauditedJoin()->save($join_requests);
});
} catch (\Exception $e) {
throw $e;
}
return "Join requests submitted";
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
try {
$user = User::findOrFail($id);
if (\Gate::denies('user.edit', $user)) {
return abort(403);
}
} catch (ModelNotFoundException $e) {
return abort(404);
}
// обновляем профиль пользователя
$user->fill($request->all())->save();
// Удаляем все присвоенные роли у пользователя
$user->roles()->detach();
// если иммеются назнаеченные роли
if (count($request->input('roles'))) {
// для оптимизации запросов выполняем добавление ролей в одну транзакцию
\DB::transaction(function () use($request, $user) {
foreach ($request->input('roles') as $role_id) {
$user->roles()->attach($role_id);
}
});
}
return redirect()->route('user.index');
}
/**
* Пополнение баланса
* @param Request $request
*/
public function up(Request $request)
{
$input = $request->only('id', 'money');
$names = ['id' => '"карта"', 'money' => '"сумма"'];
$validator = \Validator::make($input, ['id' => 'required|exists:cards,id', 'money' => 'required|numeric|min:1'])->setAttributeNames($names);
if ($validator->fails()) {
return ['success' => false, 'content' => implode("\n", $validator->messages()->all())];
}
$id = $this->user->id;
try {
\DB::transaction(function () use($id, $input) {
$card = \DB::table('cards')->where('user_id', $id)->where('id', $input['id'])->first();
$balance = $card->balance + $input['money'];
\DB::table('cards')->where('user_id', $id)->where('id', $input['id'])->update(['balance' => $balance]);
\DB::table('transactions')->insert(['user_id' => $id, 'from_id' => $id, 'card_id' => $input['id'], 'money' => $balance, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s"), 'comment' => 'Баланс пополнен на ' . $input['money'] . 'р.']);
});
return ['success' => true, 'content' => 'Баланс пополнен'];
} catch (Exception $e) {
return ['success' => false, 'content' => 'Не удалось пополнить баланс'];
}
}
public function updateTag(Request $request, $tag_id)
{
$new_tag = $request->only('name');
\DB::transaction(function () use($tag_id, $new_tag) {
$tag = Tag::findOrFail($tag_id);
// update the tag
$tag->update($new_tag);
});
return redirect(route('admin'));
}
