/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function end(Request $request, $id)
{
$output = new \Symfony\Component\Console\Output\ConsoleOutput(2);
$output->writeln("end");
$rules = array('id_barang' => 'required', 'waktu_selesai' => 'required');
$validator = Validator::make(Input::all(), $rules);
$output->writeln(Input::get('waktu_mulai'));
// process the store
if ($validator->fails()) {
return $validator->messages()->toJson();
} else {
$perbaikan = Perbaikan::find($id);
if (!$perbaikan) {
return "Not Found";
}
if (strtotime($perbaikan->waktu_selesai) != null) {
return "Perbaikan sudah diakhiri";
}
$waktu_mulai = strtotime($perbaikan->waktu_mulai);
if (!checkDateTime(Input::get('waktu_selesai'))) {
return "Waktu selesai tidak valid";
}
if ($waktu_mulai >= strtotime(Input::get('waktu_selesai'))) {
return "Waktu mulai > waktu selesai";
}
// store
$peralatan = Peralatan::find($id);
if (!$peralatan) {
return "ID peralatan tidak ditemukan";
}
$id_barang = $perbaikan->id_barang;
$perbaikan->waktu_selesai = Input::get('waktu_selesai');
//ubah status peralatan
$peralatan = Peralatan::find($id_barang);
if (!$peralatan) {
return "ID peralatan tidak ditemukan";
}
if (strcmp($peralatan->status, "Perbaikan") == 0) {
$peralatan->status = "Baik";
}
$peralatan->save();
$perbaikan->save();
return 1;
}
}
$additional_dates = $row["additional_dates"];
switch ($typeFlag) {
case "city":
if ($row["city_static"] != "") {
$cs = $row["city_static"];
}
if ($row["city_dynamic"] != "" && checkDateTime($additional_dates)) {
$cd = "," . $row["city_dynamic"];
}
$sender .= $cs . $cd;
break;
case "suburban":
if ($row["suburban_static"] != "") {
$ss = $row["suburban_static"];
}
if ($row["suburban_dynamic"] != "" && checkDateTime($additional_dates)) {
$sd = "," . $row["suburban_dynamic"];
}
$sender .= $ss . $sd;
break;
}
mysqli_close($dbc);
// Проверка и обработка ini-файла
$config_ini = parse_ini_file("mail.ini", true);
if (!$config_ini || !$_POST) {
echo "0";
exit;
}
$sender = explode(",", $sender);
// Настройка параметров отправляемого письма
$mail = new PHPMailer();
function addNotifyMsg($aParam)
{
$syntax = 'Syntax for Notify, at least 2 lines of message, first line should like:
NOTIFY:YYYYMMDD[HH[MM[SS]]]:to_list
and the other lines is the message we need to notify at the time.
YYYYMMDD[HH[MM[SS]]] is the date and time
to_list is the list who need to be notified, seperate with comma, just the the list in msn.class.php,
and the from will be added to this list automaticly.';
$from = $aParam['from'];
$network = $aParam['network'];
$msg = $aParam['msg'];
$aLines = @explode("\n", $msg);
if ($aLines === false || count($aLines) == 0) {
return $syntax;
}
$aCmd = explode(':', trim($aLines[0]));
// $aCmd[0] = 'NOTIFY'
// $aCmd[1] = datetime
// $aCmd[2] = to_list or empty
if (!isset($aCmd[1])) {
return $syntax;
}
$datetime = str_pad(trim($aCmd[1]), 14, '0');
if (!checkDateTime($datetime)) {
return "DATETIME '{$datetime}' is invalid\n\n{$syntax}";
}
if ($from == '') {
$from_email = '<unknown>';
$to_list = '';
} else {
$from_email = $from . '@' . $network;
$to_list = $from_email;
}
if (isset($aCmd[2]) && strlen(trim($aCmd[2])) > 0) {
if ($to_list !== '') {
$to_list = ',';
}
$to_list .= trim($aCmd[2]);
}
$sMsg = '';
$i = 0;
foreach ($aLines as $line) {
if ($i++ == 0) {
continue;
}
if ($sMsg !== '') {
$sMsg .= "\n";
}
$sMsg .= rtrim($line);
}
include 'notify_config.php';
if (!isset($adodb_include)) {
return "DB Setting Error!";
}
include_once $adodb_include;
$adodb_function = 'ADONewConnection';
if (!function_exists($adodb_function) || !is_callable($adodb_function)) {
return "DB Error!\n\n{$adodb_function}() not exist!";
}
$conn =& ADONewConnection($notify_db_type);
$conn->PConnect($notify_db_host, $notify_db_user, $notify_db_pass, $notify_db_name);
$sql = "insert into {$notify_table_name} (\r\nmsn_datetime, msn_to, msn_msg, msn_from, msn_tm\r\n) values (\r\n" . $conn->Param('datetime') . ', ' . $conn->Param('to') . ', ' . $conn->Param('msg') . ', ' . $conn->Param('from') . ', NOW())';
$stmt = $conn->Prepare($sql);
$rs = $conn->Execute($stmt, array($datetime, $to_list, $sMsg, $from_email));
if (!$rs) {
$errmsg = $conn->ErrorMsg();
} else {
$rs->Close();
$errmsg = '';
}
$conn->Close();
if ($errmsg === '') {
return "Notify added";
} else {
return "DB Error!\n{$errmsg}";
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$rules = array('jenis_barang' => 'required', 'id_peminjam' => 'required|integer', 'waktu_pinjam' => 'required', 'waktu_rencana_kembali' => 'required');
$validator = Validator::make(Input::all(), $rules);
// process the update
if ($validator->fails()) {
return $validator->messages()->toJson();
} else {
//cek id pengguna
$pengguna = Pengguna::find(Input::get('id_peminjam'));
if (!$pengguna) {
return "ID pengguna tidak ditemukan";
}
// update
$transaksi = Transaksi::find($id);
if (!$transaksi) {
return "Not Found";
}
if (!checkDateTime(Input::get('waktu_pinjam'))) {
return "Waktu pinjam tidak valid";
}
if (!checkDateTime(Input::get('waktu_rencana_kembali'))) {
return "Waktu rencana kembali tidak valid";
}
if (strtotime(Input::get('waktu_rencana_kembali')) <= strtotime(Input::get('waktu_pinjam'))) {
return "Waktu tidak valid";
}
if (Input::get('waktu_kembali') != null) {
if (!checkDateTime(Input::get('waktu_kembali'))) {
return "Waktu kembali tidak valid";
}
if (strtotime(Input::get('waktu_kembali')) <= strtotime(Input::get('waktu_pinjam'))) {
return "Waktu tidak valid";
}
}
$id_barang_old = $transaksi->id_barang;
$barang_old = Peralatan::find($id_barang_old);
$jenis_barang_old = $barang_old->jenis;
$selected_id = -1;
if (strcmp(Input::get('jenis_barang'), $jenis_barang_old) == 0) {
$selected_id = $id_barang_old;
} else {
// cari peralatan baru
$waktu_pinjam_time = strtotime(Input::get('waktu_pinjam'));
$waktu_rencana_kembali_time = strtotime(Input::get('waktu_rencana_kembali'));
foreach ($alat_sesuai_jenis as $alat) {
$available = true;
if (strcmp($alat->status, "Baik") != 0 || strcmp($alat->ketersediaan, "Tersedia") != 0) {
$available = false;
break;
}
//cek di data booking
$booking_of_alat = Booking::where('id_barang', '=', $alat->id)->get();
foreach ($booking_of_alat as $booking) {
$booking_mulai_time = strtotime($booking->waktu_booking_mulai);
$booking_selseai_time = strtotime($booking->waktu_booking_selesai);
if ($waktu_pinjam_time > $booking_mulai_time && $waktu_pinjam_time < $booking_selesai_time || $waktu_rencana_kembali_time > $booking_mulai_time && $waktu_rencana_kembali_time < $booking_selesai_time || $booking_mulai_time > $waktu_pinjam_time && $booking_mulai_time < $waktu_rencana_kembali_time || $booking_selesai_time > $waktu_pinjam_time && $booking_selesai_time < $waktu_rencana_kembali_time) {
$available = false;
}
}
if ($available) {
$selected_id = $alat->id;
}
}
}
$_waktu_kembali = "";
if (strcmp($transaksi->waktu_kembali, "0000-00-00 00:00:00") != 0) {
$_waktu_kembali = Input::get('waktu_kembali');
}
if ($selected_id < 1) {
return "Tidak ada alat tersedia";
} else {
$transaksi->id_barang = $selected_id;
$transaksi->id_peminjam = Input::get('id_peminjam');
$transaksi->waktu_pinjam = Input::get('waktu_pinjam');
$transaksi->waktu_rencana_kembali = Input::get('waktu_rencana_kembali');
$transaksi->waktu_kembali = $_waktu_kembali;
$transaksi->save();
return $transaksi->id;
}
}
}
}
if ($income_amount) {
$splitted_income = explode(".", str_replace(',', '.', $income_amount));
}
if (sizeof($splitted_income) > 2 || sizeof($splitted_outcome) > 2) {
header('Location: ../portal.php?e=C&page=counter&wallet_id=' . $wallet_id);
}
foreach ($splitted_outcome as $so) {
if (!is_numeric($so)) {
header('Location: ../portal.php?e=I&page=counter&wallet_id=' . $wallet_id);
}
}
foreach ($splitted_income as $si) {
if (!is_numeric($si)) {
header('Location: ../portal.php?e=I&page=counter&wallet_id=' . $wallet_id);
}
}
if ($outcome_amount) {
if (!checkDateTime($outcome_date)) {
header('Location: ../portal.php?e=D&page=counter&wallet_id=' . $wallet_id);
}
}
if ($income_amount) {
if (!checkDateTime($income_date)) {
header('Location: ../portal.php?e=D&page=counter&wallet_id=' . $wallet_id);
}
}
$proper_amount_income = implode('.', $splitted_income);
$proper_amount_outcome = implode('.', $splitted_outcome);
save_operation($wallet_id, $proper_amount_income, $income_date, $proper_amount_outcome, $outcome_category, $outcome_date);
header('Location: ../portal.php?o=O&page=counter&wallet_id=' . $wallet_id);
// Logic to handle submission of form
if (isset($_POST['submit'])) {
// Get username of person creating event
$user = $_SESSION['login_user'];
// Set date variables and put into ISO 8601
$maxVol = $_POST['MaxVol'];
$minVol = $_POST['MinVol'];
$minStud = $_POST['MinStud'];
$maxStud = $_POST['MaxStud'];
$today = date("Y-m-d H:i:s");
$startDateTime = $_POST['SYear'] . "-" . $_POST['SMonth'] . "-" . $_POST['SDay'] . " " . $_POST['SHour'] . ":" . $_POST['SMin'] . ":00";
$endDateTime = $_POST['EYear'] . "-" . $_POST['EMonth'] . "-" . $_POST['EDay'] . " " . $_POST['EHour'] . ":" . $_POST['EMin'] . ":00";
if (!checkDateTime($startDateTime)) {
echo "<div>Start Date is not a valid date.</div>";
} else {
if (!checkDateTime($endDateTime)) {
echo "<div>End Date is not a valid date.</div>";
} else {
if (!ctype_digit($maxVol)) {
echo "<div>Max Volunteer number is not a integer.</div>";
} else {
if (!ctype_digit($minVol)) {
echo "<div>Min Volunteer number is not a integer.</div>";
} else {
if (!ctype_digit($minStud)) {
echo "<div>Min Student number is not a integer.</div>";
} else {
if (!ctype_digit($maxStud)) {
echo "<div>Max Student number is not a integer.</div>";
} else {
if ($today > $startDateTime) {
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$rules = array('jenis_barang' => 'required', 'id_pembooking' => 'required|integer', 'waktu_booking_mulai' => 'required', 'waktu_booking_selesai' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return $validator->messages()->toJson();
} else {
if (!checkDateTime(Input::get('waktu_booking_mulai'))) {
return "Waktu booking mulai tidak valid";
}
if (!checkDateTime(Input::get('waktu_booking_selesai'))) {
return "Waktu booking selesai tidak valid";
}
if (strtotime(Input::get('waktu_booking_mulai')) >= strtotime(Input::get('waktu_booking_selesai'))) {
return "Waktu booking mulai > waktu booking selesai";
}
/* cek id pembooking */
$pengguna = Pengguna::find(Input::get('id_pembooking'));
if (!$pengguna) {
return "ID pengguna tidak ditemukan";
}
$booking = Booking::find($id);
if (!$booking) {
return "Not Found";
}
/* cek apakah jenis peralatan berubah
* jika berubah, cari alat baru
*/
$id_barang_old = $booking->id_barang;
$barang_old = Peralatan::find($id_barang_old);
$jenis_barang_old = $barang_old->jenis;
$selected_id = -1;
if (strcmp(Input::get('jenis_barang'), $jenis_barang_old) == 0) {
$selected_id = $id_barang_old;
} else {
//cari peralatan baru jika jenis berubah
$alat_sesuai_jenis = Peralatan::where('jenis', '=', Input::get('jenis_barang'))->get();
$input_booking_mulai_time = strtotime(Input::get('waktu_booking_mulai'));
$input_booking_selesai_time = strtotime(Input::get('waktu_booking_selesai'));
foreach ($alat_sesuai_jenis as $alat) {
$available = true;
/* Cek di tabel booking */
$booking_of_alat = Booking::where('id_barang', '=', $alat->id)->get();
foreach ($booking_of_alat as $booking) {
$booking_mulai_time = strtotime($booking->waktu_booking_mulai);
$booking_selesai_time = strtotime($booking->waktu_booking_selesai);
if ($input_booking_mulai_time > $booking_mulai_time && $input_booking_mulai_time < $booking_selesai_time || $input_booking_selesai_time > $booking_mulai_time && $input_booking_selesai_time < $booking_selesai_time || $booking_mulai_time > $input_booking_mulai_time && $booking_mulai_time < $input_booking_selesai_time || $booking_selesai_time > $input_booking_mulai_time && $booking_selesai_time < $input_booking_selesai_time) {
$available = false;
}
}
/* Cek di tabel transaksi */
if ($available) {
$transaksi_of_alat = Transaksi::where('id_barang', '=', $alat->id)->get();
foreach ($transaksi_of_alat as $transaksi) {
$transaksi_pinjam_time = $transaksi->waktu_pinjam;
$transaksi_rencana_kembali_time = $transaksi->waktu_rencana_kembali;
if ($input_booking_mulai_time > $transaksi_pinjam_time && $input_booking_mulai_time < $transaksi_rencana_kembali_time || $input_booking_selesai_time > $transaksi_pinjam_time && $input_booking_selesai_time < $transaksi_rencana_kembali_time || $transaksi_pinjam_time > $input_booking_mulai_time && $transaksi_pinjam_time < $input_booking_selesai_time || $transaksi_rencana_kembali_time > $input_booking_mulai_time && $transaksi_rencana_kembali_time < $input_booking_selesai_time) {
$available = false;
}
}
}
if ($available) {
$selected_id = $alat->id;
}
}
}
if ($selected_id < 1) {
return "Tidak ada alat tersedia";
} else {
/* cek tanggal */
if (strtotime(Input::get('waktu_booking_selesai')) <= strtotime(Input::get('waktu_booking_mulai'))) {
return "Tanggal tidak valid";
} else {
// store
$booking->id_barang = $selected_id;
$booking->id_pembooking = Input::get('id_pembooking');
$booking->waktu_booking_mulai = Input::get('waktu_booking_mulai');
$booking->waktu_booking_selesai = Input::get('waktu_booking_selesai');
$booking->save();
return $booking->id;
}
}
}
}
include '../utils/db.php';
$logged_user = get_logged_user();
if ($logged_user == 0) {
header('Location: index.php');
}
$outcome_amount = $_POST['outcome_amount'];
$outcome_category = $_POST['outcome_category'];
$outcome_date = $_POST['outcome_date'];
$splitted_outcome = array();
if ($outcome_amount) {
$splitted_outcome = explode(".", str_replace(',', '.', $outcome_amount));
}
if (sizeof($splitted_outcome) > 2) {
header('Location: ../portal.php?e=C&page=savings_counter');
}
foreach ($splitted_outcome as $so) {
if (!is_numeric($so)) {
header('Location: ../portal.php?e=I&page=savings_counter');
}
}
if ($outcome_amount) {
if (!checkDateTime($outcome_date)) {
header('Location: ../portal.php?e=D&page=savings_counter');
}
}
$proper_amount_outcome = implode('.', $splitted_outcome);
save_savings_operation($logged_user, $proper_amount_outcome, $outcome_date, $outcome_category);
header('Location: ../portal.php?o=O&page=savings_counter');
?>
