public function getVipbookingform($vip_id)
 {
     $id = $vip_id;
     // dd($id);
     $vipdata = vipbooking::where('leadcode', $id)->where('id', DB::raw("(select max(`id`) from vipbooking)"))->get();
     $leadsheet = leadsheet::where('leadcode', $id)->get();
     $dealdata = Deal::where('leadcode', $id)->get();
     foreach ($dealdata as $data) {
         $event = $data->Eventcode;
     }
     $event = Event::where('eventcode', $event)->get();
     $benefits = benefits::where('leadcode', $id)->get();
     $html22 = View('vipbookingform')->with(array('vipdata' => $vipdata, 'dealdata' => $dealdata, 'event' => $event, 'leadsheet' => $leadsheet, 'benefits' => $benefits))->render();
     require_once app_path() . '/libs/html2pdf/html2pdf.class.php';
     $html2pdf = new \HTML2PDF('P', 'A4', 'en', true, 'UTF-8', array(0, 0, 0, 0));
     // $html2pdf->pdf->SetDisplayMode('fullpage');
     $html2pdf->WriteHTML($html22);
     $html2pdf->Output('Invoice.pdf');
 }
 public function getServiceform($token1)
 {
     $status = 0;
     $token = explode('===', $token1);
     $lead_id = hotelform::where('token', $token[0])->get();
     // dd($lead_id);
     foreach ($lead_id as $lead) {
         $leadcode = $lead->leadcode;
         if ($lead->token == $token[0]) {
             $status = 1;
         }
     }
     //dd($dealtype);
     if ($status == 1) {
         $dealtype = Deal::where('leadcode', $leadcode)->get();
         foreach ($dealtype as $dealt) {
             $evcode = $dealt->Eventcode;
             # code...
         }
         $vip = vipbooking::where('leadcode', $leadcode)->max('id');
         $event = Event::where('eventcode', $evcode)->get();
         $leadsheet = leadsheet::where('leadcode', $leadcode)->get();
         $benefits = benefits::where('leadcode', $leadcode)->get();
         return View('form/serviceform')->with(array('lead_id' => $lead_id, 'dealtype' => $dealtype, 'event' => $event, 'leadsheet' => $leadsheet, 'benefits' => $benefits, 'vip' => $vip));
     } else {
         echo 'token expired';
     }
 }
 public function getUpdatedeal($leadcode)
 {
     // dd($leadcode);
     $varr = Auth::user()->empid;
     $evarr = User::where('empid', $varr)->get();
     $edetails = Employee::where('emp_ide_id', $varr)->get();
     $deal = Deal::where('leadcode', $leadcode)->get();
     $vip = vipbooking::where('leadcode', $leadcode)->get();
     $benefits = benefits::where('leadcode', $leadcode)->get();
     return view('reviewer/updatedeal')->with(array('vip' => $vip, 'benefits' => $benefits, 'edetails' => $edetails, 'deal' => $deal));
 }