', $voucherTemplate);
}
} else {
$voucherTemplate = str_replace('{Logo}', '', $voucherTemplate);
}
return view('admin2.money.print_voucher_setting', compact('item', 'voucherTemplate'));
}
public function printAllUnpaidContract($id)
{
$item = Contract::find($id);
$items = MoneyInfo::query()
->where('room_id', $item->room_id)
->where('contract_id', $item->id)
->where('remain', '<>', 0)
->orderBy('date_action');
$idItems = clone $items;
$ids = $idItems->pluck('id')->toArray();
$details = MoneyDetail::query()->whereIn('money_info_id', $ids)->with('moneyInfo')->get();
//$room = $item->room;
$payItems = clone $items;
$pay = $payItems->sum('pay');
$discountItems = clone $items;
$discount = $discountItems->sum('discount');
locale_set_default('vi_VN');
$f = new \NumberFormatter('vi_VN', \NumberFormatter::SPELLOUT);
$text = null;
$config = Config::query()->where('owner_id', auth('backend')->user()->id)->first();
$ownerId = auth('backend')->user()->id;
if (auth('backend')->user()->type == User::STAFF) {
$config = Config::query()->where('owner_id', auth('backend')->user()->staff_owner_id)->first();
$ownerId = auth('backend')->user()->staff_owner_id;
}
if ($config) {
$text = $config->voucher;
}
$configHostel = ConfigHostel::query()
->where('owner_id', $ownerId)
->where('hostel_id', $item->hostel_id)
->first();
if ($configHostel) {
$text = $configHostel->voucher;
}
if (auth('backend')->user()->id == 6875 || auth('backend')->user()->staff_owner_id == 6875) {
return view('admin2.money.bill_dung_eng', compact('item', 'details', 'pay', 'f', 'text', 'discount'));
}
$notes = $items->pluck('note')->toArray();
if (auth('backend')->user()->id == 16088 || auth('backend')->user()->staff_owner_id == 16088) {
return view('admin.money.bill_v2_16088', compact('item', 'details', 'pay', 'f', 'text', 'discount', 'notes'));
}
return view('admin.money.bill_v2', compact('item', 'details', 'pay', 'f', 'text', 'discount', 'notes'));
}
public function printAllUnpaidContractByHostel($id)
{
$contracts = Contract::query()->select('contracts.*', 'rooms.name as room_name')
->where('contracts.hostel_id', $id)
->where('contracts.status', '<>', Contract::LIQUIDATED)
->join('rooms', 'contracts.room_id', '=', 'rooms.id')
->orderBy('room_name', 'asc')
->get();
$itemArr = [];
$detailArr = [];
$payArr = [];
$fArr = [];
$textArr = [];
$discountArr = [];
$ownerId = auth('backend')->user()->id;
if (auth('backend')->user()->type == User::STAFF) {
$ownerId = auth('backend')->user()->staff_owner_id;
}
foreach ($contracts as $contract) {
if ($contract->hostel->type_rent == Hostel::TYPE_RENT_ALL) {
$moneyInfos = MoneyInfo::query()->where('room_id', $contract->room_id)->pluck('id')->toArray();
$paid = Transaction::query()->whereIn('money_info_id', $moneyInfos)->where('type', CollectSpend::COLLECT)->sum('amount');
$amount = MoneyInfo::query()->where('room_id', $contract->room_id)->sum('amount');
$discount = MoneyInfo::query()->where('room_id', $contract->room_id)->sum('discount');
$remain = $amount - $paid - $discount;
if ($remain > 0) {
$items = MoneyInfo::query()
->where('room_id', $contract->room_id)
->where('contract_id', $contract->id)
->where('remain', '<>', 0)
->orderBy('date_action');
$idItems = clone $items;
$ids = $idItems->pluck('id')->toArray();
$details = MoneyDetail::query()->whereIn('money_info_id', $ids)->with('moneyInfo')->get();
//$room = $item->room;
$payItems = clone $items;
$pay = $payItems->sum('pay');
$discountItems = clone $items;
$discountValue = $discountItems->sum('discount');
locale_set_default('vi_VN');
$f = new \NumberFormatter('vi_VN', \NumberFormatter::SPELLOUT);
$text = null;
$config = Config::query()->where('owner_id', auth('backend')->user()->id)->first();
if (auth('backend')->user()->type == User::STAFF) {
$config = Config::query()->where('owner_id', auth('backend')->user()->staff_owner_id)->first();
}
if ($config) {
$text = $config->voucher;
}
$configHostel = ConfigHostel::query()
->where('owner_id', $ownerId)
->where('hostel_id', $contract->hostel_id)
->first();
if ($configHostel) {
$text = $configHostel->voucher;
}
$itemArr[] = $contract;
$detailArr[] = $details;
$payArr[] = $pay;
$textArr[] = $text;
$fArr[] = $f;
$discountArr[] = $discount;
}
} elseif ($contract->hostel->type_rent == Hostel::TYPE_RENT_EVERY) {
$moneyInfos = MoneyInfo::query()->where('contract_id', $contract->id)->get();
$paid = $moneyInfos->sum('pay');
$amount = $moneyInfos->sum('amount');
$discount = $moneyInfos->sum('discount');
$remain = $amount - $paid - $discount;
if ($remain > 0) {
$items = MoneyInfo::query()
->where('room_id', $contract->room_id)
->where('contract_id', $contract->id)
->where('remain', '<>', 0)
->orderBy('date_action');
$idItems = clone $items;
$ids = $idItems->pluck('id')->toArray();
$details = MoneyDetail::query()->whereIn('money_info_id', $ids)->with('moneyInfo')->get();
//$room = $item->room;
$payItems = clone $items;
$pay = $payItems->sum('pay');
$discountItems = clone $items;
$discountValue = $discountItems->sum('discount');
locale_set_default('vi_VN');
$f = new \NumberFormatter('vi_VN', \NumberFormatter::SPELLOUT);
$text = null;
$config = Config::query()->where('owner_id', auth('backend')->user()->id)->first();
if (auth('backend')->user()->type == User::STAFF) {
$config = Config::query()->where('owner_id', auth('backend')->user()->staff_owner_id)->first();
}
if ($config) {
$text = $config->voucher;
}
$configHostel = ConfigHostel::query()
->where('owner_id', $ownerId)
->where('hostel_id', $contract->hostel_id)
->first();
if ($configHostel) {
$text = $configHostel->voucher;
}
$itemArr[] = $contract;
$detailArr[] = $details;
$payArr[] = $pay;
$textArr[] = $text;
$fArr[] = $f;
$discountArr[] = $discount;
}
}
}
if (auth('backend')->user()->id == 16088 || auth('backend')->user()->staff_owner_id == 16088) {
return view('admin.money.bill_all_unpaid_v2_16088', compact('itemArr', 'detailArr', 'payArr', 'fArr', 'textArr', 'discountArr'));
}
return view('admin.money.bill_all_unpaid_v2', compact('itemArr', 'detailArr', 'payArr', 'fArr', 'textArr', 'discountArr'));
}
public function getMoneyByAttribute(Request $request)
{
$type = $request->input('type');
$ownerId = auth('backend')->user()->id;
if (auth('backend')->user()->type == User::STAFF) {
$ownerId = auth('backend')->user()->staff_owner_id;
}
$items = CollectSpend::query()
->with('contract')
->with('room')
->with('typeCollect')
->when(!$request->has('order'), function ($q) {
$q->orderBy('date_action', 'desc');
});
$hostelArrs = Hostel::query()->where('owner_id', $ownerId)->pluck('id')->toArray();
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
}
$hostel = $request->input('hostel_id');
if (!empty($hostel)) {
$hostelArrs = [$hostel];
}
if (empty($hostel)) {
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
if (auth('backend')->user()->type == User::OWNER) {
$q->orwhere('collect_spends.owner_id', $ownerId);
}
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
} else {
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
}
$items = $items->where('collect_spends.type', $type);
$startDate = $request->input('start_date');
$endDate = $request->input('end_date');
if (!empty($startDate)) {
try {
$startDate = Carbon::createFromFormat('d/m/Y', $startDate)->startOfDay()->toDateTimeString();
$items = $items->where('collect_spends.date_action', '>=', $startDate);
} catch (\Exception $exception) {
}
}
if (!empty($endDate)) {
try {
$endDate = Carbon::createFromFormat('d/m/Y', $endDate)->endOfDay()->toDateTimeString();
$items = $items->where('collect_spends.date_action', '<=', $endDate);
} catch (\Exception $exception) {
}
}
$typeVoucher = $request->input('type_voucher');
$roomId = $request->input('room_id');
if (!empty($roomId)) {
$items = $items->where(function ($q) use ($roomId) {
$q->orWhere('collect_spends.room_id', $roomId);
$q->orWhereHas('moneyInfo', function ($q) use ($roomId) {
$q->where('money_infos.room_id', $roomId);
});
});
}
if (!empty($typeVoucher)) {
if ($type == CollectSpend::COLLECT) {
$items = $items->whereIn('type_collect_id', $typeVoucher);
} else {
$items = $items->whereIn('type_purpose', $typeVoucher);
}
}
// dump($items->toSql());
//
// dd($items->getBindings());
$isStat = $request->input('is_stat');
if ($isStat == 1) {
$deposit = 0;
$service = 0;
$sumEWs = 0;
$ewsElectric = 0;
$ewsWater = 0;
$roomPrice = 0;
$itemsSum = clone $items;
$sum = $itemsSum->sum('amount');
$itemsDeposit = clone $items;
$itemsService = clone $items;
$itemsRoom = clone $items;
if ($type == CollectSpend::SPEND) {
$typeDeposit = TypeSpend::query()
->where('is_default', TypeSpend::TIEN_COC)
->where('owner_id', $ownerId)
->first();
$deposit = 0;
if ($typeDeposit) {
$deposit = $itemsDeposit->where('type_purpose', $typeDeposit->id)->sum('amount');
}
} else {
$typeRoomPrice = TypeCollect::query()
->where('type', TypeCollect::ROOM_PRICE)
->where('owner_id', $ownerId)
->first();
$typeDeposit = TypeCollect::query()
->where('type', TypeCollect::DEPOSIT)
->where('owner_id', $ownerId)
->first();
$typeService = TypeCollect::query()
->where('type', TypeCollect::SERVICE)
->where('owner_id', $ownerId)
->first();
$deposit = 0;
$roomPrice = 0;
$service = 0;
if ($typeDeposit) {
$deposit = $itemsDeposit->where('type_collect_id', $typeDeposit->id)->sum('amount');
}
if ($typeRoomPrice) {
$roomPrice = $itemsRoom->where('type_collect_id', $typeRoomPrice->id)->sum('amount');
}
if ($typeService) {
$service = $itemsService->where('type_collect_id', $typeService->id)->sum('amount');
}
}
return response([
'status' => 1,
'data' => view('admin2.money.stat', compact('sum', 'sumEWs', 'deposit', 'type', 'service', 'roomPrice', 'ewsElectric', 'ewsWater'))->render()
]);
}
return Datatables::of($items)
->addIndexColumn()
->editColumn('amount', function ($item) {
return number_format($item->amount, 0, '.', '.');
})
->editColumn('money_info_type', function ($item) {
if (($item->type == CollectSpend::SPEND) && ($item->type_purpose != null)) {
return optional($item->typespend)->name;
} else {
return optional($item->typeCollect)->name;
}
})
->filterColumn('contract_code', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('code', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('reference', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('reference', 'LIKE', '%' . $keyword . '%');
});
})
->addColumn('contract_code', function ($item) {
if ($item->contract) {
return $item->contract->code;
}
})
->addColumn('reference', function ($item) {
if ($item->contract) {
return $item->contract->reference;
}
})
->editColumn('room_name', function ($item) {
if ($item->room) {
return $item->room->name;
}
if ($item->moneyInfo) {
return $item->moneyInfo->room->name;
}
})
->editColumn('date_action', function ($item) {
if (!empty($item->date_action)) {
return Carbon::createFromFormat('Y-m-d H:i:s', $item->date_action)->format('d/m/Y');
}
})
->editColumn('money_info_name', function ($item) {
return '' . $item->money_info_name . '';
})
->editColumn('code', function ($item) {
if ($item->type == CollectSpend::COLLECT) {
return 'PT' . $item->code;
}
return 'PC' . $item->code;
})
->editColumn('payment_method', function ($item) {
$paymentMethod = $item->payment_method;
if ($paymentMethod == CollectSpend::MONEY) {
return '';
} else {
return '';
}
})
->editColumn('note', function ($item) {
return $item->note_text;
})
->addColumn('action', function ($item) {
$retVal = '';
if ($item->type == CollectSpend::COLLECT) {
if (empty($item->money_info_id)) {
if (auth('backend')->user()->cannot('edit-collect')) {
$retVal = '';
} else {
$retVal =
'
Sửa';
}
} else {
$transactionId = $item->transaction_id;
$lastTransactionId = Transaction::where('money_info_id', $item->money_info_id)->orderBy('id', 'desc')->first();
if ($lastTransactionId) {
if ($transactionId == $lastTransactionId->id) {
if (auth('backend')->user()->cannot('edit-collect')) {
$retVal = '';
} else {
$retVal =
'
Sửa';
}
}
}
}
} else {
if (auth('backend')->user()->cannot('edit-spend')) {
$retVal = '';
} else {
$retVal =
'
Sửa';
}
}
if ($item->type == CollectSpend::COLLECT) {
if (auth('backend')->user()->can('delete-collect')) {
$retVal .=
'
Xóa';
}
} else {
if (auth('backend')->user()->can('delete-spend')) {
$retVal .=
'
Xóa';
}
}
$retVal .= '
In';
return $retVal;
})
->make(true);
}
public function getMoneyByAttribute2(Request $request)
{
$ownerId = auth('backend')->user()->id;
if (auth('backend')->user()->type == User::STAFF) {
$ownerId = auth('backend')->user()->staff_owner_id;
}
$type = $request->input('type');
$status = $request->input('status');
$user = $request->input('user');
$items = CollectSpend::query()
->with('contract')
->with('moneyInfo')
->with('room');
if (!empty($type)) {
$items = $items->where('type', $type);
}
if (!empty($user)) {
$items = $items->where('user_id', $user);
}
if (!$request->has('order')) {
$items = $items->orderBy('id', 'desc');
}
if ($status == 2) {
$items = $items->onlyTrashed();
}
$hostelArrs = Hostel::query()->where('owner_id', $ownerId)->pluck('id')->toArray();
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
}
$hostel = $request->input('hostel_id');
if (!empty($hostel)) {
$hostelArrs = [$hostel];
}
if (empty($hostel)) {
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
if (\auth('backend')->user()->type == User::OWNER) {
$q->orwhere('collect_spends.owner_id', $ownerId);
}
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
} else {
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
}
$startDate = $request->input('start_date');
$endDate = $request->input('end_date');
try {
if (!empty($startDate)) {
$startDate = Carbon::createFromFormat('d/m/Y', $startDate)->startOfDay()->toDateTimeString();
$items = $items->where('collect_spends.date_action', '>=', $startDate);
}
if (!empty($endDate)) {
$endDate = Carbon::createFromFormat('d/m/Y', $endDate)->endOfDay()->toDateTimeString();
$items = $items->where('collect_spends.date_action', '<=', $endDate);
}
} catch (\Exception $exception) {
}
$typeVoucher = $request->input('type_voucher');
$roomId = $request->input('room_id');
if (!empty($roomId)) {
$items = $items->where(function ($q) use ($roomId) {
$q->orWhere('collect_spends.room_id', $roomId);
$q->orWhereHas('moneyInfo', function ($q) use ($roomId) {
$q->where('money_infos.room_id', $roomId);
});
});
}
$isStat = $request->input('is_stat');
if ($isStat == 1) {
$itemsCollect = clone $items;
$itemsSpend = clone $items;
$collect = $itemsCollect->where('type', CollectSpend::COLLECT)->sum('amount');
$spend = $itemsSpend->where('type', CollectSpend::SPEND)->sum('amount');
$remain = $collect - $spend;
return response([
'status' => 1,
'data' => view('admin2.money.stat_3', compact('collect', 'spend', 'remain'))->render()
]);
}
return Datatables::of($items)
->addIndexColumn()
->setRowClass(function ($item) {
return 'details-control';
})
->editColumn('amount', function ($item) {
return number_format($item->amount, 0, '.', '.');
})
->editColumn('money_info_type', function ($item) {
if (($item->type == CollectSpend::SPEND) && ($item->type_purpose != null)) {
return optional($item->typespend)->name;
} else {
return optional($item->typeCollect)->name;
}
})
->filterColumn('contract_code', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('code', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('contract_name', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('name', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('user', function ($query, $keyword) {
$query->where(function ($q) use ($keyword) {
$q->orWhere('payer', 'LIKE', '%' . $keyword . '%');
$q->orWhere('receiver', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('reference', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('reference', 'LIKE', '%' . $keyword . '%');
});
})
->addColumn('contract_code', function ($item) {
if ($item->contract) {
return $item->contract->code;
}
return '';
})
->addColumn('contract_name', function ($item) {
if ($item->contract) {
return $item->contract->name;
}
})
->addColumn('hostel_name', function ($item) {
if ($item->hostel) {
return $item->hostel->name;
}
return '';
})
->addColumn('room_name', function ($item) {
if ($item->room) {
return $item->room->name;
}
return '';
})
->addColumn('user', function ($item) {
if (!empty($item->payer)) {
$user = $item->payer;
} else {
$user = $item->receiver;
}
if (!empty($user)) {
return $user;
}
return '';
})
->addColumn('creator', function ($item) {
if ($item->user) {
return $item->user->name_text;
}
})
->addColumn('reference', function ($item) {
if ($item->contract) {
return $item->contract->reference;
}
})
->editColumn('room_name', function ($item) {
if ($item->room) {
return $item->room->name;
}
return '';
})
->editColumn('created_at', function ($item) {
return $item->created_at->format('d/m/Y');
})
->editColumn('date_action', function ($item) {
if (!empty($item->date_action)) {
return Carbon::createFromFormat('Y-m-d H:i:s', $item->date_action)->format('d/m/Y');
}
})
->editColumn('money_info_name', function ($item) {
return '' . $item->money_info_name . '';
})
->addColumn('money_info_name_2', function ($item) {
if ($item->moneyInfo) {
return $item->moneyInfo->name;
}
return '';
})
->editColumn('code', function ($item) {
if ($item->type == CollectSpend::COLLECT) {
return 'PT' . $item->code;
}
return 'PC' . $item->code;
})
->editColumn('name', function ($item) {
if (!empty($item->name)) {
return $item->name;
}
if (!empty($item->note)) {
return $item->note;
}
return '';
})
->editColumn('payment_method', function ($item) {
$paymentMethod = $item->payment_method;
if ($paymentMethod == CollectSpend::MONEY) {
return '';
} else {
return '';
}
})
->addColumn('action', function ($item) {
$retVal = '';
if ($item->type == CollectSpend::COLLECT) {
$transactionId = $item->transaction_id;
$lastTransactionId = Transaction::where('money_info_id', $item->money_info_id)->orderBy('id', 'desc')->first();
if ($lastTransactionId) {
if ($transactionId == $lastTransactionId->id) {
if (auth('backend')->user()->cannot('edit-collect')) {
$retVal = '';
} else {
$retVal =
'
Sửa';
}
}
}
} else {
if (auth('backend')->user()->cannot('edit-spend')) {
$retVal = '';
} else {
$retVal =
'
Sửa';
}
}
if ($item->type == CollectSpend::COLLECT) {
if (auth('backend')->user()->can('delete-collect')) {
$retVal .=
'
Xóa';
}
} else {
if (auth('backend')->user()->can('delete-spend')) {
$retVal .=
'
Xóa';
}
}
$retVal .= '
In';
return $retVal;
})
->addColumn('edit_btn', function ($item) {
return '
Sửa';
})
->addColumn('delete_btn', function ($item) {
return '
Xóa';
})
->addColumn('print_btn', function ($item) {
return '
In';
})
->addColumn('action', function ($item) {
return '
Xem chi tiết';
})
->make(true);
}
public function exportExcel(Request $request)
{
$roomId = $request->input('room_id');
$startDate = $request->input('start_date');
$endDate = $request->input('end_date');
$type = $request->input('type');
$userType = $request->input('user_type');
$status = $request->input('status');
$items = CollectSpend::query();
$ownerId = auth('backend')->user()->id;
if (\auth('backend')->user()->type == User::STAFF) {
$ownerId = \auth('backend')->user()->staff_owner_id;
}
$hostelArrs = Hostel::query()->where('owner_id', $ownerId)->pluck('id')->toArray();
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
}
if (!empty($userType)) {
$items = $items->whereHas('user', function ($q) use ($userType) {
if ($userType == 1) {
$q->where('type', User::OWNER);
} else {
$q->where('type', User::STAFF);
}
});
}
if ($status == 2) {
$items = $items->onlyTrashed();
}
$hostel = $request->input('hostel_id');
if (empty($hostel)) {
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
$q->orwhere('collect_spends.owner_id', $ownerId);
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
} else {
$hostelArrs = [$hostel];
$items = $items->where(function ($q) use ($hostelArrs, $ownerId) {
$q->orwhereIn('collect_spends.hostel_id', $hostelArrs);
$q->orWhereHas('moneyInfo', function ($q) use ($hostelArrs) {
$q->whereIn('money_infos.hostel_id', $hostelArrs);
});
});
}
if (!empty($startDate)) {
$startDate = Carbon::createFromFormat('d/m/Y', $startDate)->startOfDay()->toDateTimeString();
$items = $items->where('date_action', '>=', $startDate);
}
if (!empty($endDate)) {
$endDate = Carbon::createFromFormat('d/m/Y', $endDate)->endOfDay()->toDateTimeString();
$items = $items->where('date_action', '<=', $endDate);
}
if (!empty($roomId)) {
$items = $items->where(function ($q) use ($roomId) {
$q->orWhere('collect_spends.room_id', $roomId);
$q->orWhereHas('moneyInfo', function ($q) use ($roomId) {
$q->where('money_infos.room_id', $roomId);
});
});
}
if (!empty($type)) {
if ($type == 'outcome') {
$type = CollectSpend::SPEND;
} else {
$type = CollectSpend::COLLECT;
}
$items = $items->where('type', $type);
}
$items = $items
->with([
'hostel',
'room'
])
->get();
$responseArr = [];
foreach ($items as $item) {
$itemArr = [];
if ($type == CollectSpend::COLLECT) {
$itemArr['Mã phiếu thu'] = $item->code;
} else {
$itemArr['Mã phiếu chi'] = $item->code;
}
$itemArr['Mã hóa đơn'] = $item->money_info_name;
$itemArr['Loại thu chi'] = $item->type_cp_text;
$itemArr['Loại phiếu'] = strip_tags($item->type_text);
$itemArr['Nhà trọ'] = $item->hostel_name;
$itemArr['Phòng trọ'] = $item->room ? $item->room->name : $item->room_name;
$itemArr['Số tiền'] = $item->amount;
$itemArr['Nội dung'] = $item->name;
$itemArr['Hình thức'] = $item->payment_method_text;
$itemArr['Hợp đồng'] = optional($item->contract)->name;
if ($type == CollectSpend::COLLECT) {
$itemArr['Người nộp tiền'] = $item->payer;
} else {
$itemArr['Người nhận'] = $item->receiver;
}
$itemArr['Thời gian'] = $item->date_action->format('d/m/Y');
$itemArr['Ghi chú'] = $item->note;
$responseArr[] = $itemArr;
}
if ($type == CollectSpend::COLLECT) {
$name = 'phieu-thu';
} else {
$name = 'phieu-chi';
}
\Excel::create($name . '-' . time(), function ($excel) use ($responseArr, $name) {
$excel->sheet($name, function ($sheet) use ($responseArr) {
$sheet->fromArray($responseArr);
});
})->download('xls');
}
public function exportExcelVoucher(Request $request)
{
$items = MoneyInfo::select(\DB::raw('money_infos.*, hostels.name as hostel, rooms.name as room'))
->join('hostels', 'money_infos.hostel_id', '=', 'hostels.id')
->join('rooms', 'money_infos.room_id', '=', 'rooms.id');
$ownerId = auth('backend')->user()->id;
$hostelArrs = Hostel::where('owner_id', $ownerId)->pluck('id')->toArray();
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
}
$hostel = $request->input('hostel_id');
if (!empty($hostel)) {
$items = $items->where('money_infos.hostel_id', $hostel);
} else {
$items = $items->whereIn('money_infos.hostel_id', $hostelArrs);
}
$startDate = $request->input('start_date');
if (!empty($startDate)) {
$startDate = Carbon::createFromFormat('d/m/Y', $startDate);
$items = $items->where('date_action', '>=', $startDate->copy()->startOfDay()->toDateString());
}
$endDate = $request->input('end_date');
if (!empty($endDate)) {
$endDate = Carbon::createFromFormat('d/m/Y', $endDate);
$items = $items->where('date_action', '<=', $endDate->copy()->startOfDay()->toDateString());
}
$items = $items->get();
$responseArr = [];
foreach ($items as $item) {
$itemArr = [];
$itemArr['Mã hóa đơn'] = $item->name;
$itemArr['Nội dung'] = $item->money_info_name;
$itemArr['Nhà trọ'] = $item->hostel;
$itemArr['Phòng trọ'] = $item->room;
$itemArr['Số tiền'] = $item->amount;
$itemArr['Đã thanh toán'] = $item->pay;
$itemArr['Còn lại'] = $item->remain;
$itemArr['Thời gian'] = $item->date_action->format('m/Y');
$responseArr[] = $itemArr;
}
\Excel::create('hoa-don-' . time(), function ($excel) use ($responseArr) {
$excel->sheet('hoa-don', function ($sheet) use ($responseArr) {
$sheet->fromArray($responseArr);
});
})->download('xls');
}
public function getVoucherByAttributeView2(Request $request)
{
$urlPrintContract = '';
$owner = \auth('backend')->user();
if (\auth('backend')->user()->type == User::STAFF) {
$owner = auth('backend')->user()->owner;
}
$typeDisplay = $owner->type_display_money_info;
// $typeDisplay = User::TYPE_DISPLAY_MONEY_INFO_CURRENT_MONTH;
if ($typeDisplay == User::TYPE_DISPLAY_MONEY_INFO_CURRENT_MONTH) {
$urlPrintContract = '/bill/print-money-info-contract';
} else {
$urlPrintContract = '/bill/print-money-info-room-service';
}
return view('admin2.money.voucher_2', compact('urlPrintContract', 'owner'));
}
public function getVoucherAjax(Request $request)
{
$month = $request->input('month');
$hostelId = $request->input('hostel_id');
$roomId = $request->input('room_id');
$type = $request->input('type');
$contractIds = $request->input('contract_ids');
if (empty($month)) {
$month = Carbon::now();
} else {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
}
$owner = auth('backend')->user();
if (auth('backend')->user()->type == User::STAFF) {
$owner = auth('backend')->user()->owner;
}
$typeDisplay = $owner->type_display_money_info;
// $typeDisplay = User::TYPE_DISPLAY_MONEY_INFO_CURRENT_MONTH;
$contracts = Contract::query()
->when($request->input('status') != -1, function ($q) {
$q->where('status', \request()->input('status'));
})
->when(\auth('backend')->user()->type == User::STAFF, function ($q) {
$hostelIds = Functions::getHostelArrStaff();
$q->whereIn('hostel_id', $hostelIds);
})
->when(!empty($contractIds), function ($q) {
$q->whereIn('id', \request()->input('contract_ids'));
})
// ->join('hostels', 'contracts.hostel_id', '=', 'hostels.id')
// ->join('rooms', 'contracts.room_id', '=', 'rooms.id')
->when(!empty($hostelId), function ($q) use ($hostelId) {
$q->where('hostel_id', $hostelId);
})
->when(!empty($roomId), function ($q) use ($roomId) {
$q->where('room_id', $roomId);
})
->whereHas('hostel', function ($q) use ($owner) {
$q->where('owner_id', $owner->id);
});
if ($typeDisplay == User::TYPE_DISPLAY_MONEY_INFO_CURRENT_MONTH) {
$contracts = $contracts
->with([
'hostel',
'room',
'moneyInfos' => function ($q) use ($month, $type) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
}
]);
} else {
$contracts = $contracts->with([
'room',
'hostel',
'moneyInfos' => function ($q) use ($month, $type) {
$q->where(function ($q) use ($month, $type) {
$q->orWhere(function ($q) use ($month, $type) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month, $type) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
},
]);
}
$contracts = $contracts
->get()
->sortBy('hostel.name')
->sortBy('room.name');
if ($type == 1) {
$contracts = $contracts->filter(function ($item) {
return $item->moneyInfos->sum('remain') == 0;
});
} else if ($type == 2) {
$contracts = $contracts->filter(function ($item) {
return $item->moneyInfos->sum('remain') > 0;
});
}
if ($request->input('is_excel')) {
$ownerId = $owner->id;
return dispatch_now(new ExportMoneyInfo($ownerId, $month->copy(), $contracts));
}
$moneyInfos = MoneyInfo::query()
->whereIn('contract_id', $contracts->pluck('id')->toArray())
->when($owner->type_display_money_info == User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) {
$q->where(function ($q) use ($month) {
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
}, function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
})->get();
return response([
'status' => 1,
'data' => view('admin2.money.voucher_2_ajax', compact('contracts', 'owner', 'month', 'moneyInfos'))->render()
]);
}
public function getVoucherByAttribute(Request $request)
{
$items = MoneyInfo::query()
->selectRaw('*, amount-discount as amount, amount-pay-discount as remain')
->with([
'hostel',
'room',
'contract'
]);
$ownerId = auth('backend')->user()->id;
$hostel = $request->input('hostel_id');
$month = $request->input('month');
$type = $request->input('type');
$hostelArrs = Hostel::query()->where('owner_id', $ownerId)->pluck('id')->toArray();
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
}
if (!empty($hostel)) {
$items = $items->where('money_infos.hostel_id', $hostel);
} else {
$items = $items->whereIn('money_infos.hostel_id', $hostelArrs);
}
$startDate = null;
$endDate = null;
if (!empty($month)) {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
$startDate = $month->copy()->startOfMonth();
$endDate = $month->copy()->endOfMonth();
}
if (!empty($startDate)) {
$items = $items->where('date_action', '>=', $startDate->copy()->startOfDay());
}
if (!empty($endDate)) {
$items = $items->where('date_action', '<=', $endDate->copy()->endOfDay());
}
if (!empty($type)) {
if ($type == 1) {
$items = $items->whereIn('type', [MoneyInfo::VOUCHER_ROOM_PRICE, MoneyInfo::VOUCHER_CONTRACT]);
} else {
$items = $items->whereNotIn('type', [MoneyInfo::VOUCHER_ROOM_PRICE, MoneyInfo::VOUCHER_CONTRACT]);
}
}
return Datatables::of($items)
->addIndexColumn()
->setRowClass(function ($item) {
return $item->remain > 0 ? 'warning' : '';
})
->filterColumn('hostel', function ($query, $keyword) {
$query->where('hostels.name', 'LIKE', '%' . $keyword . '%');
})
->filterColumn('name', function ($query, $keyword) {
$query->where(function ($q) use ($keyword) {
$q->orWhere('money_infos.name', 'LIKE', '%' . $keyword . '%');
$q->orWhere(DB::raw('CONCAT("HD",money_infos.id,DATE_FORMAT(money_infos.created_at, "%d%m%y"))'), 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('room_id', function ($query, $keyword) {
$query->whereHas('room', function ($q) use ($keyword) {
$q->where('rooms.name', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('hostel_id', function ($query, $keyword) {
$query->whereHas('hostel', function ($q) use ($keyword) {
$q->where('hostels.name', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('contract_name', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('contracts.name', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('contract_code', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('contracts.code', 'LIKE', '%' . $keyword . '%');
});
})
->filterColumn('reference', function ($query, $keyword) {
$query->whereHas('contract', function ($q) use ($keyword) {
$q->where('contracts.reference', 'LIKE', '%' . $keyword . '%');
});
})
->editColumn('amount', function ($item) {
return number_format($item->amount, 0, '.', '.');
})
->editColumn('hostel_id', function ($item) {
if ($item->hostel) {
return $item->hostel->name;
}
})
->editColumn('room_id', function ($item) {
if ($item->room) {
return $item->room->name;
}
})
->addColumn('contract_name', function ($item) {
if ($item->contract) {
return $item->contract->name;
}
})
->addColumn('contract_code', function ($item) {
if ($item->contract) {
return $item->contract->code;
}
})
->addColumn('reference', function ($item) {
if ($item->contract) {
return $item->contract->reference;
}
})
->editColumn('pay', function ($item) {
return number_format($item->pay, 0, '.', '.');
})
->editColumn('remain', function ($item) {
return number_format($item->remain, 0, '.', '.');
})
->editColumn('date_action', function ($item) {
return $item->date_action->format('m/Y');
})
->addColumn('action', function ($item) {
$edit = '';
if (auth('backend')->user()->can('edit-money-info')) {
$edit = '
Sửa';
if (!in_array($item->type, [
MoneyInfo::VOUCHER_ROOM_PRICE,
MoneyInfo::VOUCHER_CONTRACT
])) {
$edit = '';
}
}
return '';
})
->make(true);
}
public function checkNumberMoneyInfo(Request $request)
{
$id = $request->input('id');
$item = MoneyInfo::find($id);
$items = MoneyInfo::whereBetween('date_action', [
$item->date_action->startOfMonth()->startOfDay(),
$item->date_action->endOfMonth()->endOfDay()
])
->where('room_id', $item->room_id)
->where('remain', '<>', 0)->count();
return response([
'status' => 1,
'data' => $items
]);
}
public function getPaidFullView(Request $request)
{
$ids = $request->input('id');
$contractIds = $request->input('contract_ids');
$month = $request->input('month');
if (empty($month)) {
$month = Carbon::now();
} else {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
}
$isDelete = $request->input('is_delete');
if (!empty($contractIds)) {
$owner = \auth('backend')->user();
if (\auth('backend')->user()->type == User::STAFF) {
$owner = \auth('backend')->user()->owner;
}
$ids = MoneyInfo::query()
->whereIn('contract_id', $contractIds)
->when($owner->type_display_money_info == User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) {
$q->where(function ($q) use ($month) {
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
}, function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
})->pluck('id')->toArray();
}
if (empty($ids)) {
return response([
'status' => 0,
'message' => 'Bạn cần chọn hóa đơn để thanh toán'
]);
}
$moneyInfos = MoneyInfo::query()
->whereIn('id', $ids)
->get();
$amount = $moneyInfos->sum('remain');
$amount = number_format($amount, 0, '.', '.');
return response([
'status' => 1,
'data' => view('admin2.money.mark_paid_full', compact('ids', 'moneyInfos', 'isDelete', 'amount'))->render()
]);
}
public function markPaidFullMoneyInfos(Request $request)
{
$ids = $request->input('id');
$dateAction = $request->input('date_action');
$paymentMethod = $request->input('payment_method');
$amount = $request->input('amount');
$amount = Functions::filterInputNumber($amount);
if (empty($ids) || !is_array($ids)) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
$moneyInfos = MoneyInfo::query()
->with([
'hostel',
'room',
'contract'
])
->whereIn('id', $ids)
->get();
if (empty($dateAction)) {
$dateAction = Carbon::now()->toDateString();
} else {
$dateAction = Carbon::createFromFormat('d/m/Y', $dateAction)->toDateString();
}
if (empty($amount)) {
$amount = $moneyInfos->sum('remain');
}
$sumAmount = $moneyInfos->sum('remain');
if ($amount > $sumAmount) {
return response([
'status' => 0,
'message' => 'Bạn chỉ được thanh toán tối đa ' . number_format($sumAmount, 0, '.', '.')
]);
}
foreach ($moneyInfos as $moneyInfo) {
// if(empty($amount)) {
// $amount = $moneyInfo->amount - $moneyInfo->discount - $moneyInfo->pay;
// }
if ($amount <= 0) {
break;
}
if ($moneyInfo->remain == 0) {
continue;
}
$remain = $moneyInfo->remain;
if ($amount >= $remain) {
$payAmount = $remain;
} else {
$payAmount = $amount;
}
$moneyInfo->remain = $moneyInfo->remain - $payAmount;
$moneyInfo->pay = $moneyInfo->pay + $payAmount;
$moneyInfo->save();
$moneyInfoId = $moneyInfo->id;
$hostelId = $moneyInfo->hostel_id;
$userId = auth('backend')->user()->id;
$roomId = $moneyInfo->room_id;
$payer = optional($moneyInfo->contract)->name;
$transaction = Transaction::create([
'amount' => $payAmount,
'hostel_id' => $hostelId,
'date_action' => $dateAction,
'user_id' => $userId,
'money_info_id' => $moneyInfoId,
'type' => CollectSpend::COLLECT,
'payer' => $payer
]);
$collectSpend = CollectSpend::create([
'amount' => $payAmount,
'hostel_id' => $hostelId,
'room_id' => $roomId,
'payment_method' => $paymentMethod,
'date_action' => $dateAction,
'user_id' => $userId,
'money_info_id' => $moneyInfoId,
'type' => CollectSpend::COLLECT,
'transaction_id' => $transaction->id,
'payer' => $payer
]);
$amount = $amount - $remain;
$user = Functions::getCurrentUser();
$contract = $moneyInfo->contract;
if ($contract) {
$desc = '{' . $user->name . '} vừa thu {' . number_format($payAmount, 0, '.', '.') . '}, hóa đơn {' . $moneyInfo->name . '} của khách {' . $contract->name . '} phòng {' . $contract->room->name . '} nhà {' . $contract->hostel->name . '}';
if ($contract->hostel->type_rent == Hostel::TYPE_RENT_EVERY) {
$desc = '{' . $user->name . '} vừa thu {' . number_format($payAmount, 0, '.', '.') . '}, hóa đơn {' . $moneyInfo->name . '} của khách {' . $contract->name . '} giường {' . optional($contract->bed)->name . '} phòng {' . $contract->room->name . '} nhà {' . $contract->hostel->name . '}';
}
event(new LogAction([
'type' => 'add-payment-collect',
'user_id' => optional($user)->id,
'object_id' => $collectSpend->id,
'hostel_id' => $contract->hostel_id,
'room_id' => $contract->room_id,
'properties' => $collectSpend->toArray(),
'desc' => $desc
]));
}
}
return response([
'status' => 1
]);
}
public function checkNumberMoneyUnpaid(Request $request)
{
$id = $request->input('hostel_id');
$item = MoneyInfo::where('hostel_id', $id)->first();
$items = MoneyInfo::whereBetween('date_action', [
$item->date_action->startOfMonth()->startOfDay(),
$item->date_action->endOfMonth()->endOfDay()
])
->where('room_id', $item->room_id)
->where('remain', '=', 0)->count();
return response([
'status' => 1,
'data' => $items
]);
}
public function deleteVoucherMultiple(Request $request)
{
$ids = $request->input('ids');
$contractIds = $request->input('contract_ids');
$month = $request->input('month');
if (empty($month)) {
$month = Carbon::now();
} else {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
}
if (!empty($contractIds)) {
$owner = \auth('backend')->user();
if (\auth('backend')->user()->type == User::STAFF) {
$owner = \auth('backend')->user()->owner;
}
$moneyInfos = MoneyInfo::query()
->whereIn('contract_id', $contractIds)
->when($owner->type_display_money_info == User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) {
$q->where(function ($q) use ($month) {
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
}, function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
})->get();
$ids = $moneyInfos->pluck('id')->toArray();
} else {
$moneyInfos = MoneyInfo::query()
->whereIn('id', $ids)
->get();
}
if (empty($ids)) {
return response([
'status' => 0,
'message' => 'Bạn cần chọn hóa đơn để thanh toán'
]);
}
MoneyInfo::query()
->whereIn('id', $ids)
->delete();
CollectSpend::whereIn('money_info_id', $ids)->delete();
Transaction::whereIn('money_info_id', $ids)->delete();
MoneyDetail::whereIn('money_info_id', $ids)->delete();
$user = Functions::getCurrentUser();
foreach ($moneyInfos as $moneyInfo) {
$desc = '{' . optional($user)->name . '} xóa hóa đơn mã ' . $moneyInfo->name . ' phòng {' . $moneyInfo->room->name . '} nhà {' . $moneyInfo->room->hostel->name . '}';
if ($moneyInfo->hostel->type_rent == Hostel::TYPE_RENT_EVERY) {
$desc = '{' . optional($user)->name . '} xóa hóa đơn mã ' . $moneyInfo->name . ' giường {' . optional(optional($moneyInfo->contract)->bed)->name . '} phòng {' . $moneyInfo->room->name . '} nhà {' . $moneyInfo->room->hostel->name . '}';
}
event(new LogAction([
'type' => 'delete-money-info',
'user_id' => optional($user)->id,
'object_id' => $moneyInfo->id,
'hostel_id' => $moneyInfo->hostel_id,
'room_id' => $moneyInfo->room_id,
'properties' => $moneyInfo->toArray(),
'desc' => $desc
]));
}
return response([
'status' => 1,
'message' => 'Thanh cong'
]);
}
public function deleteVoucher(Request $request)
{
$id = $request->input('id');
$voucher = MoneyInfo::find($id);
if (!$voucher) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
CollectSpend::where('money_info_id', $voucher->id)->delete();
Transaction::where('money_info_id', $voucher->id)->delete();
MoneyDetail::where('money_info_id', $voucher->id)->delete();
$voucher->delete();
return response([
'status' => 1,
'message' => 'Thanh cong'
]);
}
public function spend(Request $request)
{
$data = $request->all();
$ownerId = auth('backend')->user()->id;
if (auth('backend')->user()->type == User::STAFF) {
$ownerId = auth('backend')->user()->staff_owner_id;
}
$type_purpose = $data['type_purpose'];
$amount = $data['amount'];
if (empty($amount)) {
return response([
'status' => 0,
'message' => 'Không được bỏ trống số tiền'
]);
}
$amount = Functions::filterInputNumber($amount);
if (!is_numeric($amount)) {
return response([
'status' => 0,
'message' => 'Số tiền phải là số'
]);
}
if (!empty($data['date_action'])) {
$dateAction = Carbon::createFromFormat('d/m/Y', $data['date_action'])->toDateString();
} else {
$dateAction = Carbon::now()->toDateString();
}
$roomId = null;
$hostelId = null;
if (isset($data['room_id'])) {
$roomId = $data['room_id'];
}
if (isset($data['hostel_id'])) {
$hostelId = $data['hostel_id'];
}
try {
\DB::beginTransaction();
if ($type_purpose == null) {
$orther_type_purpose = $data['orther_type_purpose'];
if ($orther_type_purpose == null || $orther_type_purpose == '') {
return response([
'status' => 0,
'message' => 'Không được bỏ trống loại chi'
]);
} else {
$type_purpose = TypeSpend::create([
'name' => $orther_type_purpose,
'owner_id' => $ownerId,
])->id;
}
}
$transaction = Transaction::create([
'amount' => $amount,
'hostel_id' => $hostelId,
'room_id' => $roomId,
'date_action' => $dateAction,
'type' => CollectSpend::SPEND,
]);
$cp = CollectSpend::create([
'amount' => $amount,
'hostel_id' => $hostelId,
'room_id' => $roomId,
'owner_id' => $ownerId,
'note' => $data['note'],
'payment_method' => $data['payment_method'],
'date_action' => $dateAction,
'type' => CollectSpend::SPEND,
'receiver' => $data['receiver'],
'name' => $data['name'],
'transaction_id' => $transaction->id,
'type_purpose' => $type_purpose,
'is_allow_cycle' => true
//'type_spend_id' => '',
]);
$cnt = Receiver::query()->where('name', trim($data['receiver']))
->where('user_id', auth('backend')->user()->id)->count();
if ($cnt == 0) {
Receiver::create([
'user_id' => auth('backend')->user()->id,
'name' => $data['receiver']
]);
}
\DB::commit();
$files = $request->file('files');
if (!empty($files) && is_array($files)) {
foreach ($files as $key => $file) {
$name = time() . $file->getClientOriginalName();
$filePath = 'collect-spends/' . $cp->id . '/files/' . str_slug($name);
$filePath = $filePath . '.' . $file->getClientOriginalExtension();
\Storage::disk('s3')->put($filePath, file_get_contents($file), 'public');
CollectSpendFile::create([
'collect_spend_id' => $cp->id,
'name' => $file->getClientOriginalName(),
'file' => 'https://resident.sgp1.digitaloceanspaces.com/' . $filePath
]);
}
}
$repeatEvery = $request->input('repeat_every');
if ($repeatEvery) {
CollectSpendCycle::query()->updateOrCreate([
'collect_spend_id' => $cp->id,
], [
'collect_spend_id' => $cp->id,
'repeat_every' => $request->input('repeat_every'),
'repeat_every_custom' => $request->input('repeat_every_custom'),
'repeat_type_custom' => $request->input('repeat_type_custom'),
'cycles' => $request->input('cycles'),
'unlimited_cycles' => $request->input('unlimited_cycles') == 'on' ? true : false,
]);
} else {
CollectSpendCycle::query()
->where('collect_spend_id', $cp->id)
->delete();
}
$user = Functions::getCurrentUser();
$desc = '{' . optional($user)->name . '} vừa chi {' . number_format($cp->amount, 0, '.', '.') . '} với nội dung {' . $request->input('name') . '}';
event(new LogAction([
'type' => 'create-spend',
'user_id' => optional($user)->id,
'object_id' => $cp->id,
'hostel_id' => $cp->hostel_id,
'room_id' => $cp->room_id,
'properties' => $cp->toArray(),
'desc' => $desc
]));
} catch (\Exception $exception) {
\DB::rollBack();
return response([
'status' => 0,
'message' => 'Có lỗi xảy ra vui lòng thử lại sau'
]);
}
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
public function getVoucherByAttributeView(Request $request)
{
return view('admin2.money.voucher');
}
public function collect(Request $request)
{
$data = $request->all();
$amount = $data['amount'];
if (empty($amount)) {
return response([
'status' => 0,
'message' => 'Không được bỏ trống số tiền'
]);
}
$amount = Functions::filterInputNumber($amount);
if (!is_numeric($amount)) {
return response([
'status' => 0,
'message' => 'Số tiền phải là số'
]);
}
if (!empty($data['date_action'])) {
$dateAction = Carbon::createFromFormat('d/m/Y', $data['date_action'])->toDateString();
} else {
$dateAction = Carbon::now()->toDateString();
}
$roomId = $data['room_id'];
$hostelId = $data['hostel_id'];
try {
\DB::beginTransaction();
$transaction = Transaction::create([
'amount' => $amount,
'hostel_id' => $hostelId,
'room_id' => $roomId,
'date_action' => $dateAction,
'type' => CollectSpend::COLLECT,
'payer' => $data['payer']
]);
$cp = CollectSpend::create([
'amount' => $amount,
'hostel_id' => $hostelId,
'room_id' => $roomId,
'note' => $data['note'],
'payment_method' => $data['payment_method'],
'date_action' => $dateAction,
'type' => CollectSpend::COLLECT,
'name' => $data['name'],
'transaction_id' => $transaction->id,
'payer' => $data['payer'],
'receiver' => $data['receiver'],
'type_collect_id' => !empty($data['type_collect_id']) ? $data['type_collect_id'] : null,
]);
\DB::commit();
$files = $request->file('files');
if (!empty($files) && is_array($files)) {
foreach ($files as $key => $file) {
$name = time() . $file->getClientOriginalName();
$filePath = 'collect-spends/' . $cp->id . '/files/' . str_slug($name);
$filePath = $filePath . '.' . $file->getClientOriginalExtension();
\Storage::disk('s3')->put($filePath, file_get_contents($file), 'public');
CollectSpendFile::create([
'collect_spend_id' => $cp->id,
'name' => $file->getClientOriginalName(),
'file' => 'https://resident.sgp1.digitaloceanspaces.com/' . $filePath
]);
}
}
$user = Functions::getCurrentUser();
$desc = '{' . optional($user)->name . '} vừa thu {' . number_format($cp->amount, 0, '.', '.') . '} với nội dung {' . $request->input('name') . '}';
event(new LogAction([
'type' => 'create-collect',
'user_id' => optional($user)->id,
'object_id' => $cp->id,
'hostel_id' => $cp->hostel_id,
'room_id' => $cp->room_id,
'properties' => $cp->toArray(),
'desc' => $desc
]));
} catch (\Exception $exception) {
\DB::rollBack();
return response([
'status' => 0,
'message' => 'Có lỗi xảy ra vui lòng thử lại sau'
]);
}
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
public function edit(Request $request)
{
$data = $request->except([
'repeat_every',
'repeat_every_custom',
'repeat_type_custom',
'cycles',
'unlimited_cycles'
]);
$amount = $data['amount'];
if (empty($amount)) {
return response([
'status' => 0,
'message' => 'Không được bỏ trống số tiền'
]);
}
$amount = Functions::filterInputNumber($amount);
$data['amount'] = $amount;
if (!is_numeric($amount)) {
return response([
'status' => 0,
'message' => 'Số tiền phải là số'
]);
}
if (!empty($data['date_action'])) {
$data['date_action'] = Carbon::createFromFormat('d/m/Y', $data['date_action'])->toDateString();
} else {
$data['date_action'] = Carbon::now()->toDateString();
}
$roomId = $data['room_id'];
$hostelId = $data['hostel_id'];
if ($hostelId) {
$hostel = Hostel::find($hostelId);
if ($hostel) {
$data['hostel_name'] = $hostel->name;
} else {
$data['hostel_name'] = null;
}
} else {
$data['hostel_name'] = null;
}
if ($roomId) {
$room = Room::find($roomId);
if ($room) {
$data['room_name'] = $room->name;
} else {
$data['room_name'] = null;
}
} else {
$data['room_name'] = null;
}
try {
\DB::beginTransaction();
$collectSpend = CollectSpend::find($data['id']);
if (!$collectSpend) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
$collectSpend->update($data);
$dateAction = $collectSpend->date_action;
if (!empty($dateAction)) {
$month = $collectSpend->date_action->month;
$year = $collectSpend->date_action->year;
StatisticLog::query()->where('collect_spend_id', $collectSpend->id)
->update([
'month' => $month,
'year' => $year
]);
}
$transactionId = $collectSpend->transaction_id;
$transaction = Transaction::find($transactionId);
if ($transaction) {
$transaction->amount = $amount;
$transaction->save();
}
$paid = Transaction::where('money_info_id', $transaction->money_info_id)->sum('amount');
$moneyInfo = MoneyInfo::find($transaction->money_info_id);
if ($moneyInfo) {
$moneyInfo->pay = $paid;
$moneyInfo->remain = $moneyInfo->amount - $moneyInfo->discount - $paid;
$moneyInfo->save();
}
if (isset($data['receiver'])) {
$cnt = Receiver::where('name', trim($data['receiver']))
->where('user_id', auth('backend')->user()->id)->count();
if ($cnt == 0) {
Receiver::create([
'user_id' => auth('backend')->user()->id,
'name' => $data['receiver']
]);
}
}
\DB::commit();
$files = $request->file('files');
if (!empty($files) && is_array($files)) {
foreach ($files as $key => $file) {
$name = time() . $file->getClientOriginalName();
$filePath = 'collect-spends/' . $collectSpend->id . '/files/' . str_slug($name);
$filePath = $filePath . '.' . $file->getClientOriginalExtension();
\Storage::disk('s3')->put($filePath, file_get_contents($file), 'public');
CollectSpendFile::create([
'collect_spend_id' => $collectSpend->id,
'name' => $file->getClientOriginalName(),
'file' => 'https://resident.sgp1.digitaloceanspaces.com/' . $filePath
]);
}
}
$user = Functions::getCurrentUser();
if ($collectSpend->type == CollectSpend::SPEND) {
$desc = '{' . $user->name . '} sửa phiếu chi {' . $collectSpend->name . '}';
$type = 'update-spend';
} else {
$desc = '{' . $user->name . '} sửa phiếu thu {' . $collectSpend->name . '}';
$type = 'update-collect';
}
event(new LogAction([
'type' => $type,
'user_id' => optional($user)->id,
'object_id' => $collectSpend->id,
'hostel_id' => $collectSpend->hostel_id,
'room_id' => $collectSpend->room_id,
'properties' => $collectSpend->toArray(),
'desc' => $desc
]));
} catch (\Exception $exception) {
\DB::rollBack();
return response([
'status' => 0,
'message' => 'Có lỗi xảy ra vui lòng thử lại sau'
]);
}
$repeatEvery = $request->input('repeat_every');
if ($repeatEvery) {
CollectSpendCycle::query()->updateOrCreate([
'collect_spend_id' => $collectSpend->id,
], [
'collect_spend_id' => $collectSpend->id,
'repeat_every' => $request->input('repeat_every'),
'repeat_every_custom' => $request->input('repeat_every_custom'),
'repeat_type_custom' => $request->input('repeat_type_custom'),
'cycles' => $request->input('cycles'),
'unlimited_cycles' => $request->input('unlimited_cycles') == 'on' ? true : false,
]);
} else {
CollectSpendCycle::query()
->where('collect_spend_id', $collectSpend->id)
->delete();
}
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
public function updateTransactionCollect(Request $request)
{
$transactionId = $request->input('transaction_id');
$amount = Functions::filterInputNumber($request->input('amount'));
$transaction = Transaction::find($transactionId);
if (empty($amount)) {
return response([
'status' => 0,
'message' => 'Không được bỏ trống số tiền'
]);
}
if (!is_numeric($amount)) {
return response([
'status' => 0,
'message' => 'Số tiền phải là số'
]);
}
if (!$transaction) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
try {
\DB::beginTransaction();
$transaction->amount = $amount;
$transaction->save();
$collectSpend = CollectSpend::where('transaction_id', $transaction->id)->first();
if ($collectSpend) {
$collectSpend->amount = $amount;
$collectSpend->save();
}
$paid = Transaction::where('money_info_id', $transaction->money_info_id)->sum('amount');
$moneyInfo = MoneyInfo::find($transaction->money_info_id);
if ($moneyInfo) {
$moneyInfo->pay = $paid;
$moneyInfo->remain = $moneyInfo->amount - $moneyInfo->discount - $paid;
$moneyInfo->save();
}
\DB::commit();
} catch (\Exception $exception) {
\DB::rollBack();
return response([
'status' => 0,
'message' => 'Có lỗi xảy ra vui lòng thử lại sau'
]);
}
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
public function detailMoneyInfo(Request $request)
{
$moneyInfoId = $request->input('money_info_id');
$details = MoneyDetail::where('money_info_id', $moneyInfoId)->orderBy('id', 'desc')->get();
$pay = \App\Components\Functions::calculateAmountForOrder($moneyInfoId)['pay'];
$moneyInfoItem = MoneyInfo::find($moneyInfoId);
if (!$moneyInfoItem) {
return response([
'status' => 0,
'message' => 'Wrong data'
]);
}
$sum = 0;
foreach ($details as $detail) {
if (!empty($detail->sum_amount)) {
$sum += $detail->sum_amount;
} else {
$sum += $detail->amount;
}
}
return response([
'status' => 1,
'data' => view('admin2.money.detail_with_paid', compact('details', 'sum', 'pay', 'moneyInfoItem'))->render(),
'title' => 'Thông tin hóa đơn ' . $moneyInfoItem->name,
]);
}
public function editMoneyInfoContract(Request $request)
{
$contractId = $request->input('contract_id');
$month = $request->input('month');
if (empty($month)) {
$month = Carbon::now();
} else {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
}
$contract = Contract::find($contractId);
$owner = \auth('backend')->user();
if (\auth('backend')->user()->type == User::STAFF) {
$owner = \auth('backend')->user()->owner;
}
$typeDisplay = $owner->type_display_money_info;
// $typeDisplay = User::TYPE_DISPLAY_MONEY_INFO_CURRENT_MONTH;
$moneyInfos = MoneyInfo::query()
->where('contract_id', $contractId)
->when($typeDisplay == User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) {
$q->where(function ($q) use ($month) {
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
}, function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
})->get();
return response([
'status' => 1,
'data' => view('admin2.money.money_info_contracts', compact('moneyInfos'))->render()
]);
}
public function detailMoneyInfoContract(Request $request)
{
$contractId = $request->input('contract_id');
$month = $request->input('month');
if (empty($month)) {
$month = Carbon::now();
} else {
$month = Carbon::createFromFormat('d/m/Y', '01/' . $month);
}
$contract = Contract::find($contractId);
$owner = \auth('backend')->user();
if (\auth('backend')->user()->type == User::STAFF) {
$owner = \auth('backend')->user()->owner;
}
// $owner->type_display_money_info = User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH;
$moneyInfos = MoneyInfo::query()
->where('contract_id', $contractId)
->when($owner->type_display_money_info == User::TYPE_DISPLAY_MONEY_INFO_PREVIOUS_MONTH, function ($q) use ($month) {
$q->where(function ($q) use ($month) {
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
$q->whereIn('type', [
MoneyInfo::VOUCHER_CONTRACT,
MoneyInfo::VOUCHER_ROOM_PRICE
]);
});
$q->orWhere(function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->subMonth()->startOfMonth(),
$month->copy()->subMonth()->endOfMonth()
]);
$q->where('type', MoneyInfo::VOUCHER_SERVICE);
});
});
}, function ($q) use ($month) {
$q->whereBetween('date_action', [
$month->copy()->startOfMonth(),
$month->copy()->endOfMonth()
]);
});
$details = MoneyDetail::query()
->whereIn('money_info_id', $moneyInfos->pluck('id')->toArray())
->get();
$payItems = clone $moneyInfos;
$discountItems = clone $moneyInfos;
$pay = $payItems->sum('pay');
$discount = $discountItems->sum('discount');
$sum = 0;
foreach ($details as $detail) {
if (!empty($detail->sum_amount)) {
$sum += $detail->sum_amount;
} else {
$sum += $detail->amount;
}
}
return response([
'status' => 1,
'data' => view('admin2.money.detail_with_paid_contract', compact('details', 'sum', 'pay', 'discount'))->render(),
'title' => 'Thông tin hóa đơn HĐ ' . $contract->code . ' tháng ' . $month->copy()->format('m/Y'),
]);
}
public function destroy(Request $request)
{
$id = $request->input('id');
$item = CollectSpend::find($id);
if (!$item) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
if ($item->type == CollectSpend::COLLECT) {
if (auth('backend')->user()->cannot('delete-collect')) {
return response([
'status' => 0,
'message' => 'Bạn không có quyền thực hiện'
]);
}
}
if ($item->type == CollectSpend::SPEND) {
if (auth('backend')->user()->cannot('delete-spend')) {
return response([
'status' => 0,
'message' => 'Bạn không có quyền thực hiện'
]);
}
}
$hostelId = $item->hostel_id;
$hostel = Hostel::find($hostelId);
if ($hostel) {
if ($hostel->owner_id != auth('backend')->user()->id && $hostel->owner_id != auth('backend')->user()->staff_owner_id) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
}
$transactionId = $item->transaction_id;
$moneyInfoId = $item->money_info_id;
DB::beginTransaction();
try {
StatisticLog::query()
->where('collect_spend_id', $item->id)
->delete();
$item->delete();
$transaction = Transaction::find($transactionId);
if ($transaction) {
$transaction->delete();
}
$moneyInfo = MoneyInfo::find($moneyInfoId);
if ($moneyInfo) {
$paid = Functions::calculateAmountForOrder($moneyInfoId)['pay'];
$moneyInfo->pay = $paid;
$moneyInfo->remain = $moneyInfo->amount - $moneyInfo->discount - $paid;
$moneyInfo->save();
}
DB::commit();
$typeName = 'thu';
if ($item->type == CollectSpend::SPEND) {
$typeName = 'chi';
}
$user = Functions::getCurrentUser();
$desc = '{' . optional($user)->name . '} xóa phiếu ' . $typeName . ' với nội dung {' . $item->name . '}';
event(new LogAction([
'type' => 'delete-collect-spend',
'user_id' => optional($user)->id,
'object_id' => $item->id,
'hostel_id' => $item->hostel_id,
'room_id' => $item->room_id,
'properties' => $item->toArray(),
'desc' => $desc
]));
} catch (\Exception $exception) {
DB::rollBack();
return response([
'status' => 0,
'message' => 'Có lỗi xảy ra vui lòng thử lại sau'
]);
}
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
public function listAllUnpaidContractByHostel(Request $request)
{
$id = $request->input('hostel_id');
$token = auth('backend')->user()->token;
if (empty($token)) {
$token = uniqid();
auth('backend')->user()->token = $token;
auth('backend')->user()->save();
}
return response([
'status' => 1,
'message' => 'Success!',
'data' => url('bill/print-all-unpaid-contract-by-hostel?token=' . $token, ['id' => $id]),
]);
}
public function sendAllUnpaidByHostel(Request $request)
{
$id = $request->input('hostel_id');
$token = auth('backend')->user()->token;
if (empty($token)) {
$token = uniqid();
auth('backend')->user()->token = $token;
auth('backend')->user()->save();
}
$hostel = Hostel::find($id);
$fromUser = auth('backend')->user()->id;
if ($hostel->type_rent == Hostel::TYPE_RENT_ALL) {
$hostelRoomUnPaid = MoneyInfo::where('hostel_id', $id)->where('remain', '>', 0)->pluck('room_id')->toArray();
$conversations = Conversation::whereIn('room_id', array_unique($hostelRoomUnPaid))
->whereNotNull('hostel_id')
->get();
if ($conversations->count() <= 0) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
foreach ($conversations as $conversation) {
$content = 'Danh sách hóa đơn chưa thanh toán: ' . url('bill/print-all-unpaid-contract-by-hostel-room?token=' . $token, [
'id' => $id,
'room_id' => $conversation->room_id
]);
$content = strip_tags($content, '');
$message = Message::create([
'content' => $content,
'conversation_id' => $conversation->id,
'type' => Message::TYPE_TEXT,
'from' => $fromUser
]);
$conversation->update([
'last_message_id' => $message->id,
'last_message_time' => Carbon::now()->toDateTimeString()
]);
$messageArr = $message->toArray();
$content = $message->content;
$userOnlineArr = [];
if (isset($usersChannel['result'])) {
if (isset($usersChannel['result']['users'])) {
foreach ($usersChannel['result']['users'] as $item) {
$userIdOnline = $item['id'];
$userOnlineArr[] = $userIdOnline;
}
}
}
$membersArr = \DB::table('user_conversations')->where('conversation_id', $conversation->id)->pluck('user_id')->toArray();
foreach ($membersArr as $userId) {
$q = \DB::table('user_conversations')
->where('conversation_id', $conversation->id)
->where('user_id', $userId);
if (in_array($userId, $userOnlineArr)) {
$q->update([
'is_read_last_message' => 1
]);
} else {
$q->update([
'is_read_last_message' => 0
]);
}
if ($message->type == Message::TYPE_IMAGE || $message->type == Message::TYPE_SYSTEM) {
if ($userId == $fromUser) {
if ($message->type == Message::TYPE_IMAGE) {
$content = 'Bạn đã gửi một ảnh';
} else {
$content = 'Bạn ' . $content;
}
} else {
$fromUser = $message->fromUser;
if ($fromUser) {
if ($message->type == Message::TYPE_IMAGE) {
$content = $fromUser->name_text . ' đã gửi một ảnh';
} else {
$content = $fromUser->name_text . ' ' . $content;
}
}
}
}
$messageArr['content'] = $content;
$this->pusher->trigger('chat-' . $userId, 'new-message', $messageArr);
dispatch(new SendNotificationMessage($userId, $messageArr));
}
}
}
if ($hostel->type_rent == Hostel::TYPE_RENT_EVERY) {
$hostelRoomUnPaidUsers = MoneyInfo::where('hostel_id', $id)->where('remain', '>', 0)->groupBy('user_id')->get();
foreach ($hostelRoomUnPaidUsers as $hostelRoomUnPaidUser) {
$contractId = $hostelRoomUnPaidUser->contract_id;
$content = 'Hóa đơn chưa thanh toán:' . url('bill/print-all-contract-unpaid?token=' . $token, ['id' => $contractId]);
$content = strip_tags($content, ' ');
dispatch(new SendMessageBot($content, $hostelRoomUnPaidUser->user_id, $fromUser));
}
}
return response([
'status' => 1,
'message' => 'Thành công',
]);
}
public function sendAllUnpaidByHostel2(Request $request)
{
$id = $request->input('hostel_id');
$token = auth('backend')->user()->token;
if (empty($token)) {
$token = uniqid();
auth('backend')->user()->token = $token;
auth('backend')->user()->save();
}
if (empty($id)) {
if (auth('backend')->user()->type == User::STAFF) {
$hostelArrs = Functions::getHostelArrStaff();
} else {
$hostelArrs = Hostel::query()
->where('owner_id', auth('backend')->user()->id)
->pluck('id')
->toArray();
}
foreach ($hostelArrs as $hostelArr) {
$request->request->add([
'hostel_id' => $hostelArr
]);
$this->sendAllUnpaidByHostel2($request);
return response([
'status' => 1,
'message' => 'Thành công'
]);
}
}
$hostel = Hostel::find($id);
$fromUser = auth('backend')->user()->id;
if ($hostel->type_rent == Hostel::TYPE_RENT_ALL) {
$hostelRoomUnPaid = MoneyInfo::where('hostel_id', $id)
->where('remain', '>', 0)
->pluck('room_id')
->toArray();
$conversations = \App\Models_v2\Conversation::query()->whereIn('room_id', array_unique($hostelRoomUnPaid))
->get();
if ($conversations->count() <= 0) {
return response([
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
]);
}
//dd($conversations->pluck('id')->toArray());
foreach ($conversations as $conversation) {
$content = 'Danh sách hóa đơn chưa thanh toán: ' . url('bill/print-all-unpaid-contract-by-hostel-room?token=' . $token, [
'id' => $id,
'room_id' => $conversation->room_id
]);
$content = strip_tags($content, '