312 lines
12 KiB
PHP
312 lines
12 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use App\Models\MemberCard;
|
|
use App\Models\StikerTrans;
|
|
use App\Models\StikerTransDetail;
|
|
use Carbon\Carbon;
|
|
use Exception;
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Support\Facades\Auth;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Facades\Log;
|
|
use Illuminate\Support\Facades\Validator;
|
|
use Illuminate\Support\Js;
|
|
use Yajra\DataTables\Facades\DataTables;
|
|
|
|
class MemberStikerController extends Controller
|
|
{
|
|
/**
|
|
* Display a listing of the resource.
|
|
*
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function index(Request $request)
|
|
{
|
|
$vehicleSelect = DB::table('jenis_mobil')->get();
|
|
$departmentSelect = DB::table('stasiunkerja')->get();
|
|
$memberSelect = DB::table('jenis_langganan')->get();
|
|
$jenisStiker = DB::table('tarif_stiker')->get();
|
|
|
|
return view('member.member', compact([
|
|
'vehicleSelect',
|
|
'departmentSelect',
|
|
'memberSelect',
|
|
'jenisStiker',
|
|
]));
|
|
}
|
|
|
|
public function getMember (Request $request)
|
|
{
|
|
Log::info(json_encode('nopol : ' .$request->nopol));
|
|
Log::info(json_encode('veh : ' .$request->vehicle));
|
|
Log::info(json_encode('dept : ' .$request->depart));
|
|
Log::info(json_encode('mem : ' .$request->member));
|
|
Log::info(json_encode('trans : ' .$request->notrans));
|
|
Log::info(json_encode('isactive : ' .gettype($request->isactive)));
|
|
if ($request->ajax() ) {
|
|
|
|
|
|
$dataStiker = DB::table('transaksi_stiker as ts')
|
|
->leftjoin('detail_transaksi_stiker as dts','dts.notrans','=','ts.notrans')
|
|
->leftJoin('card_member as cm','cm.notrans','=','ts.no_id')
|
|
->leftJoin('jenis_langganan as jl','jl.id','=','ts.jenis_langganan')
|
|
->leftJoin('stasiunkerja as sk','sk.kode','=','ts.unit_kerja')
|
|
->leftJoin('jenis_mobil as jm','jm.id','=','dts.jenis_mobil')
|
|
->select(DB::raw('
|
|
ts.notrans as notrans , ts.nama , ts.alamat as alamat , ts.telepon as telepon,
|
|
ts.awal as awal , ts.akhir as akhir, jl.nama as jmember, sk.nama as dept, dts.nopol,
|
|
jm.nama vehicle, dts.jenis_member, cm.no_card as no_card'))
|
|
->distinct();
|
|
// ->select(DB::raw('ts.notrans as notrans , ts.nama , ts.alamat as alamat , ts.telepon as telepon , ts.awal as awal , ts.akhir as akhir, sk.nama as unit_kerja, jl.nama as jenis_member, ts.no_id'))
|
|
|
|
if ($request->nama) {
|
|
$dataStiker = $dataStiker->where('ts.nama', 'like', '%' . $request->nama . '%');
|
|
}
|
|
|
|
if ( $request->notrans) {
|
|
$dataStiker = $dataStiker->where('ts.notrans', 'like', '%' . $request->notrans . '%');
|
|
}
|
|
|
|
if ($request->nopol) {
|
|
$dataStiker = $dataStiker->where('ts.unit_kerja', 'like', '%' . $request->depart . '%');
|
|
}
|
|
|
|
if ($request->member) {
|
|
$dataStiker = $dataStiker->where('ts.jenis_langganan', 'like', '%' . $request->member . '%');
|
|
}
|
|
|
|
if ($request->nopol) {
|
|
$dataStiker = $dataStiker->where('dts.nopol', 'like', '%' . $request->nopol . '%');
|
|
}
|
|
|
|
if ($request->vehicle) {
|
|
$dataStiker = $dataStiker->where('dts.jenis_mobil', 'like', '%' . $request->vehicle . '%');
|
|
}
|
|
|
|
if ($request->nocard) {
|
|
$dataStiker = $dataStiker->where('cm.no_card', 'like', '%' . $request->nocard . '%');
|
|
}
|
|
|
|
if ($request->isactive === '1') {
|
|
$dataStiker = $dataStiker->whereRaw('now() between ts.awal and ts.akhir');
|
|
}
|
|
|
|
Log::info($dataStiker->toSql());
|
|
|
|
$dataStiker = $dataStiker->get();
|
|
|
|
return response()->json($dataStiker);
|
|
}
|
|
|
|
}
|
|
|
|
/**
|
|
* Show the form for creating a new resource.
|
|
*
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function create(Request $request)
|
|
{
|
|
Log::info('Data yang diperpanjang : ' . json_encode($request->all()));
|
|
}
|
|
|
|
/**
|
|
* Store a newly created resource in storage.
|
|
*
|
|
* @param \Illuminate\Http\Request $request
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
|
|
public function checkField (Request $request)
|
|
{
|
|
Log::info('Data yang diterima : ' . json_encode($request->all()));
|
|
$validate = Validator::make($request->all(),[
|
|
'nopol' => 'required|string|unique:detail_transaksi_stiker,nopol',
|
|
// 'nocard' => 'string|exists:card_member,no_card',
|
|
]);
|
|
|
|
$nocard = $request->input('nocard');
|
|
$nocardExists = DB::table('card_member')
|
|
->where('no_card', $nocard)
|
|
->exists();
|
|
|
|
if ($validate->fails()) {
|
|
return response()->json(['response' => false, 'message' => 'Data sudah ada, coba yang lain']);
|
|
}
|
|
|
|
return response()->json(['response' => true, 'message' => 'Data sudah ada']);
|
|
|
|
}
|
|
|
|
public function store(Request $request)
|
|
{
|
|
Log::info('Data yang diterima : ' . json_encode($request->all()));
|
|
$mountYearNow = Carbon::now()->format('m/Y');
|
|
|
|
$dataStiker = $request->input('formData');
|
|
$dataVehicle = $request->input('nopolData');
|
|
$dataCard = $request->input('cardNumber');
|
|
Log::info('Data Stiker : ' . json_encode($dataStiker));
|
|
Log::info('Data Kendaraan : ' . json_encode($dataVehicle));
|
|
Log::info('Data kartu : ' . json_encode($dataCard));
|
|
// $cleanedData = stripslashes(trim($data));
|
|
// Log::debug('Modified : ' . json_encode($cleanedData));
|
|
// $dataStiker = json_decode($cleanedData, false);
|
|
// Log::info('Debuggind data : ' . json_encode($dataStiker));
|
|
|
|
// $validate = Validator::make($request->all(),[
|
|
// 'nama' => 'required|string|unique',
|
|
// // 'nopol' => 'required|string|unique:detail_transaksi_stiker,nopol',
|
|
// // 'nocard' => 'string|exists:card_member,no_card',
|
|
// ]);
|
|
|
|
// if ($validate->fails()) {
|
|
// return response()->json(['response' => false, 'message' => 'pastikan nama, Nomor Polisi, dan data kartu sudah terisi']);
|
|
// }
|
|
|
|
$dateNow = Carbon::now()->format('Y-m-d H:m:s');
|
|
$seqTrans = DB::table('indexnum')->select('value')->where('nama', 'sticker')->first();
|
|
$seqId = DB::table('indexnum')->select('value')->where('nama', 'identitas')->first();
|
|
|
|
$notrans = $seqTrans->value . "/STK/" . $mountYearNow;
|
|
$noid = $seqId->value . "/IDT/" . $mountYearNow;
|
|
$user = Auth::user();
|
|
|
|
$periode = explode(" - ", $dataStiker['daterange']);
|
|
Log::info('Parcing Periode : ' . json_encode($periode));
|
|
$awal = Carbon::createFromFormat('d-m-Y H:i', $periode[0]);
|
|
$akhir = Carbon::createFromFormat('d-m-Y H:i', $periode[1]);
|
|
Log::info('Awal : ' . $awal . ' Akhir : ' . $akhir);
|
|
// Log::info($user);
|
|
|
|
try {
|
|
$dataStiker = [
|
|
'jenis_transaksi' => $dataStiker['jenis_transaksi'], // 0 = transaksi baru , 1 = perpanjangan
|
|
'notrans' => $notrans,
|
|
'no_id' => $noid,
|
|
'nama' => $dataStiker['nama'],
|
|
'alamat' => $dataStiker['address'] ?? '',
|
|
'telepon' => $dataStiker['phone'] ?? '',
|
|
'unit_kerja' => $dataStiker['depart'],
|
|
'jenis_stiker' => $dataStiker['member'],
|
|
'awal' => $awal,
|
|
'akhir' => $akhir,
|
|
'harga' => $dataStiker['harga'] ?? 0,
|
|
'keterangan' => $dataStiker['note'] ?? '',
|
|
'tanggal' => $dateNow,
|
|
'operator' => $user->nomer,
|
|
];
|
|
|
|
DB::table('transaksi_stiker')->insert($dataStiker);
|
|
|
|
if($dataVehicle) {
|
|
foreach ($dataVehicle as $nopol) {
|
|
$dataVehicle = [
|
|
'notrans' => $notrans,
|
|
'nopol' => $nopol['nopol'],
|
|
'jenis_mobil' => $nopol['vehicle'],
|
|
'jenis_member' => $nopol['member'],
|
|
'merk' => $nopol['merk'],
|
|
];
|
|
DB::table('detail_transaksi_stiker')->insert($dataVehicle);
|
|
}
|
|
} else {
|
|
return 0;;
|
|
}
|
|
|
|
if ($dataCard) {
|
|
foreach ($dataCard as $cardNumber) {
|
|
$dataCard = [
|
|
'notrans' => $noid,
|
|
'no_card' => $cardNumber['nocard'],
|
|
'no_urut' => $cardNumber['nourut'],
|
|
];
|
|
|
|
DB::table('card_member')->insert($dataCard);
|
|
}
|
|
} else {
|
|
return 0;
|
|
}
|
|
|
|
DB::table('indexnum')->where('nama', 'sticker' )->update(['value' => DB::raw("lpad(to_number(value,'9999')+1)::text, 4, '0')")]);
|
|
DB::table('indexnum')->where('nama', 'identitas' )->update(['value' => DB::raw("lpad(to_number(value,'9999')+1)::text, 4, '0')")]);
|
|
$response = true;
|
|
$msg = 'Data berhasil di simpan';
|
|
} catch (Exception $e) {
|
|
$response = false;
|
|
$msg = 'Gagal menyimpan data ' . $e->getMessage() . $e->getLine();
|
|
}
|
|
|
|
return response()->json(['response' => $response, 'pesan' => $msg]);
|
|
}
|
|
|
|
/**
|
|
* Display the specified resource.
|
|
*
|
|
* @param int $id
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function show($id)
|
|
{
|
|
Log::info('Data yang diterima : ' . json_encode($id));
|
|
$dataStiker = StikerTrans::with('stiker_details.vehicle', 'memberCard')
|
|
->select('transaksi_stiker.notrans', 'transaksi_stiker.nama', 'transaksi_stiker.alamat', 'transaksi_stiker.telepon', 'transaksi_stiker.awal', 'transaksi_stiker.akhir', 'transaksi_stiker.jenis_langganan',
|
|
'transaksi_stiker.unit_kerja', 'transaksi_stiker.no_id', 'jl.nama as jmember', 'sk.nama as dept')
|
|
->leftJoin('jenis_langganan as jl','jl.id','=','transaksi_stiker.jenis_langganan')
|
|
->leftJoin('stasiunkerja as sk','sk.kode','=','transaksi_stiker.unit_kerja')
|
|
->where('notrans', 'like', '%' . $id . '%')
|
|
->first();
|
|
// $dataStiker = DB::table('transaksi_stiker as ts')
|
|
// ->leftjoin('detail_transaksi_stiker as dts','dts.notrans','=','ts.notrans')
|
|
// ->leftJoin('jenis_langganan as jl','jl.id','=','ts.jenis_langganan')
|
|
// ->leftJoin('stasiunkerja as sk','sk.kode','=','ts.unit_kerja')
|
|
// ->leftJoin('jenis_mobil as jm','jm.id','=','dts.jenis_mobil')
|
|
// ->leftJoin('card_member as cm','cm.notrans','=','ts.no_id')
|
|
// ->select(DB::raw('
|
|
// ts.notrans as notrans , ts.nama , ts.alamat as alamat , ts.telepon as telepon,
|
|
// ts.awal as awal , ts.akhir as akhir, jl.nama as jmember, sk.nama as dept, dts.nopol,
|
|
// jm.nama vehicle, dts.jenis_member, cm.no_card as no_card')
|
|
// )->where('ts.notrans', 'like', '%' . $id . '%')
|
|
// ->get();
|
|
Log::info('Data Stiker : ' . json_encode($dataStiker));
|
|
|
|
return response()->json($dataStiker);
|
|
}
|
|
|
|
/**
|
|
* Show the form for editing the specified resource.
|
|
*
|
|
* @param int $id
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function edit($id)
|
|
{
|
|
//
|
|
}
|
|
|
|
/**
|
|
* Update the specified resource in storage.
|
|
*
|
|
* @param \Illuminate\Http\Request $request
|
|
* @param int $id
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function update(Request $request, $id)
|
|
{
|
|
//
|
|
}
|
|
|
|
/**
|
|
* Remove the specified resource from storage.
|
|
*
|
|
* @param int $id
|
|
* @return \Illuminate\Http\Response
|
|
*/
|
|
public function destroy($id)
|
|
{
|
|
//
|
|
}
|
|
}
|