public function action_delete($id = null) { is_null($id) and Response::redirect('payment'); if ($payment = Model_Payment::find($id)) { $payment->delete(); Session::set_flash('success', 'ลบรายการชำระเงิน #' . $id . " แล้ว"); } else { Session::set_flash('error', 'ไม่สามารถลบรายการชำระเงิน #' . $id . " ได้"); } Response::redirect('payment'); }
public function action_index() { $this->template->title = "Remittance Payment"; $this->template->sub = "Follow the steps below to pay"; if (isset($this->user)) { $data["student"] = Model_User::find("first", ["where" => [["deleted_at", 0], ["id", $this->user->id]]]); } if (Input::post('action') == 'submit') { if (Input::post("pay-method", null) != null && Input::post("refno", null) != null) { $checkExist = Model_Payment::find("first", ["where" => [["student_id", Input::post("studentId")], ["paid", Input::post("quarter")], ["status", 0]]]); if ($checkExist == NULL) { // save $payment = Model_Payment::forge(); $payment->student_id = Input::post("studentId"); $payment->pay_method = Input::post("paymethod"); $payment->paid_at = Input::post("date"); $payment->status = 0; $payment->method = Input::post("pay-method"); $payment->ref_no = Input::post("refno"); if (Input::post("pay-method") == 1) { $payment->paid = "1111"; } else { $payment->paid = Input::post("quarter"); } $payment->save(); $data["user"] = Model_User::find("first", ["where" => [["id", Input::post("studentId")]]]); $pay = Model_Payment::query()->where('status', 0); $lastID = $pay->max('id'); $data["pay"] = Model_Payment::find("first", ["where" => [["id", $lastID]]]); //sending mail $body = View::forge("email/payment", $data); $sendmail = Email::forge("JIS"); $sendmail->from(Config::get("statics.info_email"), Config::get("statics.info_name")); $sendmail->to("*****@*****.**"); //$sendmail->to("*****@*****.**"); $sendmail->subject("Payment / Game-bootcamp"); $sendmail->html_body("Dear Admin,<br><br>" . htmlspecialchars_decode($body)); $sendmail->send(); Response::redirect("/students/top/?success=2"); } else { Response::redirect("/coursefee/remit/?e=2&g=" . Input::post('paymethod', 0)); } } else { Response::redirect("/coursefee/?e=4"); } } if (isset($this->user)) { $view = View::forge("coursefee/remit", $data); } else { $view = View::forge("coursefee/remit"); } $this->template->content = $view; }
public function action_index() { $id = Input::get('id', 0); $data['payment'] = Model_Payment::find("all", ["where" => [["id", $id]]]); //save if (Input::post('action') == 'submit') { if (Input::post("payid", null) != null) { $payid = Input::post("payid", null); $payUp = Model_Payment::find("first", ["where" => [["id", $payid]]]); DB::update('payment')->value("status", "1")->where('id', '=', $payid)->execute(); DB::update('users')->value("charge_html", $payUp->paid)->where('id', '=', $payUp->student_id)->execute(); $data["user"] = Model_User::find("first", ["where" => [["id", $payUp->student_id]]]); $data["pay"] = Model_Payment::find("first", ["where" => [["student_id", $payUp->student_id], ["id", $payUp->id]]]); $user = $data["user"]; //sending mail $body = View::forge("email/confirm", $data); $sendmail = Email::forge("JIS"); $sendmail->from(Config::get("statics.info_email"), Config::get("statics.info_name")); $sendmail->to($user->email); $sendmail->subject("Payment Confirmation / Game-bootcamp"); $sendmail->html_body("Dear " . $user->firstname . ",<br><br>" . htmlspecialchars_decode($body)); $sendmail->send(); Response::redirect("/admin/top/?pay=1"); } else { } } if (Input::post("paymentID", 0) != 0) { $cancel = Model_Payment::find(Input::post("paymentID", 0)); if ($cancel != null) { //save $cancel->reason = Input::post("explain", 0); $cancel->status = 2; $cancel->save(); $data["cancel"] = Model_Payment::find("first", ["where" => [["id", Input::post("paymentID", 0)]]]); $student = $data["cancel"]; $data["student"] = Model_User::find("first", ["where" => [["id", $student->student_id]]]); $stud = $data["student"]; //sendingmail $body = View::forge("email/cancelpayment", $data); $sendmail = Email::forge("JIS"); $sendmail->from(Config::get("statics.info_email"), Config::get("statics.info_name")); $sendmail->to($stud->email); $sendmail->subject("Denied Payment / Game-bootcamp"); $sendmail->html_body("Dear " . $stud->firstname . ",<br><br>" . htmlspecialchars_decode($body)); $sendmail->send(); Response::redirect("/admin/top/?s=1"); } } $view = View::forge("admin/payment/index", $data); $this->template->content = $view; }
public function action_index() { $year = date("Y"); $month = date("m"); $price = Model_Grade::find("first", ["where" => [["year", $year], ["month", $month]]]); if ($price == null) { $price = Model_Grade::forge(); $price->year = $year; $price->month = $month; $price->grade_1 = Config::get("prices")[0]; $price->grade_2 = Config::get("prices")[1]; $price->grade_3 = Config::get("prices")[2]; $price->grade_4 = Config::get("prices")[3]; $price->grade_5 = Config::get("prices")[4]; $price->save(); } $data["ym"] = Input::get("ym", date("Y-m")); $data["contacts"] = Model_Contactforum::find("all", ["where" => [["deleted_at", 0]], "order_by" => [["id", "desc"]], "limit" => 5]); $data["payment"] = Model_Payment::find("all", ["where" => [["status", 0]], "order_by" => [["id", "desc"]], "limit" => 5]); $data["reservations"] = Model_Lessontime::find("all", ["where" => [["deleted_at", 0], ["freetime_at", ">=", strtotime($data["ym"] . "-01")], ["freetime_at", "<", strtotime($data["ym"] . "-01 +1 month")], ["status", ">", 0], ["status", "<>", 3]], "order_by" => [["freetime_at", "asc"]]]); $view = View::forge("admin/top", $data); $this->template->content = $view; }
public function action_index() { $this->template->title = "Cash Payment"; $this->template->sub = "Follow the steps below to pay"; if (isset($this->user)) { $data["student"] = Model_User::find("first", ["where" => [["deleted_at", 0], ["id", $this->user->id]]]); } if (Input::post('action') == 'submit') { // add if (Input::post("studentId", null) != null) { if (is_uploaded_file($_FILES["photo"]["tmp_name"])) { $filename = str_replace("/", "", $_FILES["photo"]["name"]); $filepath = DOCROOT . "/contents/receipt/" . $filename; $checkExist = Model_Payment::find("first", ["where" => [["student_id", Input::post("studentId")], ["paid", Input::post("quarter")], ["status", 0]]]); if ($checkExist == NULL) { if (move_uploaded_file($_FILES["photo"]["tmp_name"], $filepath)) { chmod($filepath, 0644); // save $payment = Model_Payment::forge(); $payment->student_id = Input::post("studentId"); $payment->pay_method = Input::post("paymethod"); $payment->paid_at = Input::post("date"); $payment->receipt = $filename; $payment->status = 0; $payment->method = Input::post("method"); if (Input::post("method") == 1) { $payment->paid = "1111"; } else { $payment->paid = Input::post("quarter"); } $payment->save(); $data["user"] = Model_User::find("first", ["where" => [["id", Input::post("studentId")]]]); $pay = Model_Payment::query()->where('status', 0); $lastID = $pay->max('id'); $data["pay"] = Model_Payment::find("first", ["where" => [["id", $lastID]]]); //sending mail $body = View::forge("email/payment", $data); $sendmail = Email::forge("JIS"); $sendmail->from(Config::get("statics.info_email"), Config::get("statics.info_name")); //$sendmail->to("*****@*****.**"); $sendmail->to("*****@*****.**"); $sendmail->subject("Payment / Game-bootcamp"); $sendmail->html_body("Dear Admin,<br><br>" . htmlspecialchars_decode($body)); $rec = $data["pay"]; $receipt = Model_Payment::query()->where('id', $rec->id)->limit(1)->get_one(); $query = Model_Payment::find($receipt->id); $sendmail->attach(DOCROOT . '/contents/receipt/' . $query->receipt); $sendmail->send(); Response::redirect("/students/top/?success=1"); } else { Response::redirect("/coursefee/?e=1"); } } else { Response::redirect("/coursefee/cash/?e=2&g=" . Input::post('g', 0)); } } else { Response::redirect("/coursefee/?e=3"); } } else { Response::redirect("/coursefee/?e=4"); } } if (isset($this->user)) { $view = View::forge("coursefee/cash", $data); } else { $view = View::forge("coursefee/cash"); } $this->template->content = $view; }