public function index()
{
$model_member_affiliation = model_member_affiliation::where(array('maff_status' => '1'))->get();
$model_business = model_business::where('business_status', '1')->orderBy('business_name')->pluck('business_name', 'business_id')->toArray();
$model_member = model_member::where('member_status', '1')->orderBy('member_name')->pluck('member_name', 'member_id')->toArray();
return view('backend.maff.index')->with(['model_maff' => $model_member_affiliation, 'model_business' => $model_business, 'model_member' => $model_member]);
}
public function detailBusiness($business_id)
{
$member_id = auth()->guard('member')->user()->member_id;
$model_business = model_business::find($business_id);
$model_review = model_review::where(['member_id' => $member_id, 'business_id' => $business_id, 'review_status' => 1])->orderBy('review_id', SORT_DESC)->first();
$model_claim = model_business_claim::where(['business_id' => $business_id, 'member_id' => $member_id, 'bclaim_status' => '1'])->get();
$model_maff = model_member_affiliation::where(['business_id' => $business_id, 'member_id' => $member_id, 'maff_status' => '1'])->get();
$model_pcat = model_photos_category::where(['business_id' => $business_id, 'pcat_status' => 1])->pluck('pcat_name', 'pcat_id')->toArray();
$model_pbusiness = model_photos_business::where(['business_id' => $business_id, 'pbusiness_status' => 1])->get();
$sisaticket = [];
$model_bticket = model_bticket::where(['business_id' => $business_id])->get();
foreach ($model_bticket as $bticket) {
$sisaticket[$bticket->ticket_id] = $bticket->bticket_amount;
}
return view('frontend.business.view_detail')->with(['member_id' => $member_id, 'business' => $model_business, 'alreadyClaim' => count($model_claim), 'isOwner' => count($model_maff), 'pcat' => $model_pcat, 'pbusiness' => $model_pbusiness, 'sisaticket' => $sisaticket, 'model_review' => $model_review]);
}
