public function submitRegister(Request $request)
 {
     $this->validate($request, ['member_name' => 'required', 'member_username' => 'required', 'city_code' => 'required', 'member_gender' => 'required', 'member_email' => 'required|unique:member', 'member_password' => 'required|confirmed'], ['member_name.required' => 'Silahkan mengisikan nama.', 'member_username.required' => 'Silahkan mengisikan username.', 'city_code.required' => 'Silahkan mengisikan kota.', 'member_gender.required' => 'Silahkan mengisikan jenis kelamin.', 'member_email.required' => 'Silahkan mengisikan email.', 'member_email.unique' => 'Email telah digunakan.', 'member_password.required' => 'Silahkan mengisikan password', 'member_password.confirmed' => 'Password dan Confirm Password tidak sama']);
     $member = new model_member();
     $request['member_coin'] = 100;
     $request['member_password'] = bcrypt($request['member_password']);
     if ($member->create($request->except('member_password_confirmation'))) {
         return redirect('home');
     } else {
         return redirect('register')->withInput($request->only('member_email', 'remember'))->withErrors(['name' => 'Terdapat isian yang salah, silakan mengisi ulang form.']);
     }
 }
 public function submitBuy()
 {
     $err = [];
     $member_id = auth()->guard('member')->user()->member_id;
     $model_member = model_member::find($member_id);
     $total = 0;
     $model_ticketH = new model_ticketH();
     $data = array();
     $data['member_id'] = $member_id;
     $model_ticketH->fill($data);
     if ($model_ticketH->save()) {
         for ($i = 0; $i < count($_POST['ticket_id']); $i++) {
             $model_bticket = model_bticket::where(['ticket_id' => $_POST['ticket_id'][$i], 'business_id' => $_POST['business_id'][$i]])->first();
             $model_bticket->bticket_amount += $_POST['bticket_amount'][$i];
             $model_bticket->save();
             $model_ticket = model_ticket::find($_POST['ticket_id'][$i]);
             $subtotal = $_POST['bticket_amount'][$i] * $model_ticket->ticket_price;
             $total += $subtotal;
             $model_ticketD = new model_ticketD();
             $data = array();
             $data['ticketH_id'] = $model_ticketH->ticketH_id;
             $data['business_id'] = $_POST['business_id'][$i];
             $data['ticket_id'] = $_POST['ticket_id'][$i];
             $data['ticketD_amount'] = $_POST['bticket_amount'][$i];
             $data['ticketD_price'] = $model_ticket->ticket_price;
             $data['ticketD_subtotal'] = $subtotal;
             $model_ticketD->create($data);
         }
     }
     $model_ticketH['ticketH_total'] = $total;
     $model_ticketH->save();
     $model_member->member_coin -= $total;
     $model_member->save();
     return redirect('/ticket/successBuy')->withErrors($err);
 }
 public function index()
 {
     $member_id = auth()->guard('member')->user()->member_id;
     $model_member = model_member::find($member_id);
     $model_fcat = model_feedback_category::where('fcat_status', 1)->pluck('fcat_name', 'fcat_id')->toArray();
     return view('frontend.feedback.view_index')->with(['model_member' => $model_member, 'model_fcat' => $model_fcat, 'member_id' => $member_id]);
 }
 public function index()
 {
     $model_business_claim = model_business_claim::where('bclaim_status', '>', '0')->get();
     $model_business = model_business::where('business_status', '1')->orderBy('business_name')->pluck('business_name', 'business_id')->toArray();
     $model_member = model_member::where('member_status', '1')->orderBy('member_name')->pluck('member_name', 'member_id')->toArray();
     return view('backend.bclaim.index')->with(['model_bclaim' => $model_business_claim, 'model_business' => $model_business, 'model_member' => $model_member]);
 }
 public function editMember()
 {
     $err = array();
     if ($_POST['_type'] == 3) {
         $model_member = model_member::find($_POST['member_id']);
         $model_member['member_status'] = 0;
         $model_member->save();
     } else {
         if ($_POST['_type'] == 1) {
             $model_member = new model_member();
             $_POST['member_password'] = $model_member->genPass();
             $_POST['sendPass'] = $_POST['member_password'];
             $_POST['member_password'] = bcrypt($_POST['member_password']);
             if ($model_member->create($_POST)) {
                 $data = $_POST;
                 $model_member->emailGenPass($data);
             }
         } else {
             if ($_POST['_type'] == 2) {
                 $model_member = model_member::find($_POST['member_id']);
                 $model_member->fill($_POST);
                 $model_member->save();
             }
         }
     }
     return redirect('/backend/member')->withErrors($err);
 }
 public function index()
 {
     $model_member_affiliation = model_member_affiliation::where(array('maff_status' => '1'))->get();
     $model_business = model_business::where('business_status', '1')->orderBy('business_name')->pluck('business_name', 'business_id')->toArray();
     $model_member = model_member::where('member_status', '1')->orderBy('member_name')->pluck('member_name', 'member_id')->toArray();
     return view('backend.maff.index')->with(['model_maff' => $model_member_affiliation, 'model_business' => $model_business, 'model_member' => $model_member]);
 }
 public function submitAddReview()
 {
     $member_id = auth()->guard('member')->user()->member_id;
     $model_member = model_member::find($member_id);
     if ($_POST['_type'] == 1) {
         $model_review = new model_review();
         $_POST['member_id'] = $member_id;
         $model_review->fill($_POST);
         if ($model_review->save()) {
             $data = array();
             $reviewId = $model_review->review_id;
             foreach ($_POST['rating'] as $key => $value) {
                 $model_review_rating = new model_review_rating();
                 $dataRating = array();
                 $dataRating['review_id'] = $reviewId;
                 $dataRating['rating_id'] = $key;
                 $dataRating['rrating_score'] = $value;
                 $model_review_rating->fill($dataRating);
                 if ($model_review_rating->save()) {
                     $dataRating['rating_name'] = $model_review_rating->rating->rating_name;
                 }
                 $data['rating'][] = $dataRating;
             }
             $data['review_id'] = $reviewId;
             $data['member_name'] = $model_member->member_name;
             $data['created_at'] = date_format(new DateTime($model_review->created_at), 'd-M-Y H:i:s');
             echo json_encode($data);
         } else {
             echo 0;
         }
     } elseif ($_POST['_type'] == 2) {
         $model_review = model_review::find($_POST['review_id']);
         $model_review->fill($_POST);
         if ($model_review->save()) {
             $data = array();
             $reviewId = $model_review->review_id;
             foreach ($_POST['rating'] as $key => $value) {
                 $model_review_rating = model_review_rating::where(['review_id' => $reviewId, 'rating_id' => $key])->firstOrFail();
                 $dataRating = array();
                 $dataRating['rrating_score'] = $value;
                 $model_review_rating->fill($dataRating);
                 if ($model_review_rating->save()) {
                     $dataRating['rating_name'] = $model_review_rating->rating->rating_name;
                 }
                 $data['rating'][] = $dataRating;
             }
             $data['review_id'] = $reviewId;
             $data['member_name'] = $model_member->member_name;
             $data['created_at'] = date_format(new DateTime($model_review->created_at), 'd-M-Y H:i:s');
             echo json_encode($data);
         } else {
             echo 0;
         }
     } elseif ($_POST['_type'] == 3) {
         //delete
         $model_review = model_review::find($_POST['review_id']);
         $model_review['review_status'] = 0;
         if ($model_review->save()) {
             echo 1;
         }
     }
 }
 public function historyOrderTicket()
 {
     $member_id = auth()->guard('member')->user()->member_id;
     $model_member = model_member::find($member_id);
     return view('frontend.member.view_history_ticket')->with(['member' => $model_member]);
 }