all();
foreach ( $data as $key => $value ) {
option()->set( $key, $value );
}
return redirect()->back()->with( 'success', 'Thành công' );
}
public function reportSale() {
return view( 'admin.report_sale.index' );
}
public function getReportSaleByAttribute( Request $request ) {
$types = $request->input( 'types' );
$items = ReportSale::query()->with( [
'user',
'owner',
'types',
'hostel'
] )
->when( ! empty( $types ), function ( $q ) use ( $types ) {
$q->whereHas( 'types', function ( $q ) use ( $types ) {
$q->whereIn( 'type', $types );
} );
} );
return \DataTables::of( $items )
->filterColumn( 'user_name', function ( $q, $keyword ) {
$q->whereHas('user', function($q) use ($keyword) {
$q->where('name', 'LIKE', '%'.$keyword.'%');
});
} )
->filterColumn( 'user_phone', function ( $q, $keyword ) {
$q->whereHas('user', function($q) use ($keyword) {
$q->where('phone', 'LIKE', '%'.$keyword.'%');
});
} )
->filterColumn( 'owner_name', function ( $q, $keyword ) {
$q->whereHas('owner', function($q) use ($keyword) {
$q->where('name', 'LIKE', '%'.$keyword.'%');
});
} )
->filterColumn( 'hostel_id', function ( $q, $keyword ) {
$q->whereHas('hostel', function($q) use ($keyword) {
$q->where('name', 'LIKE', '%'.$keyword.'%');
});
} )
->addColumn( 'user_name', function ( $item ) {
return optional( $item->user )->name_text;
} )
->addColumn( 'user_phone', function ( $item ) {
return optional( $item->user )->phone;
} )
->addColumn( 'owner_name', function ( $item ) {
return optional( $item->owner )->name_text;
} )
->addColumn( 'types', function ( $item ) {
$typesArr = optional( $item->types )
->pluck( 'type' )
->toArray();
$types = ReportSale::TYPES;
$retVal = [];
foreach ( $typesArr as $type ) {
if ( isset( $types[ $type ] ) ) {
$retVal[] = $types[ $type ];
}
}
return implode( ', ', $retVal );
} )
->addColumn( 'owner_phone', function ( $item ) {
return optional( $item->owner )->phone;
} )
->addColumn( 'hostel_id', function ( $item ) {
if ( $item->hostel ) {
return '' . $item->hostel->name . '';
}
} )
->editColumn( 'created_at', function ( $item ) {
return $item->created_at->format( 'd/m/Y H:i' );
} )
->editColumn( 'status', function ( $item ) {
return '';
} )
->editColumn( 'note', function ( $item ) {
return '';
} )
->addColumn( 'action', function ( $item ) {
$retVal = ' Xóa';
return $retVal;
} )
->make( true );
}
public function deleteReportSale( Request $request ) {
$id = $request->input( 'id' );
$reportSale = ReportSale::find( $id );
if ( $reportSale ) {
$reportSale->delete();
}
return response( [
'status' => 1
] );
}
public function updateReportSaleAttribute( Request $request ) {
$id = $request->input( 'pk' );
$value = $request->input( 'value' );
$hostel = ReportSale::find( $id );
$name = $request->input( 'name' );
$hostel->$name = $value;
$hostel->save();
return 1;
}
public function reportSaleStatus( Request $request ) {
return response( [
[
'value' => ReportSale::NOT_PROCESS,
'text' => 'Chờ xử lý'
],
[
'value' => ReportSale::PROCESSING,
'text' => 'Đang xử lý'
],
[
'value' => ReportSale::RIGHT,
'text' => 'Thông tin đúng'
],
[
'value' => ReportSale::WRONG,
'text' => 'Thông tin sai'
],
] );
}
}