Esempio n. 1
0
 public function excel()
 {
     $registration = Registration::all();
     Excel::create('Registrations', function ($excel) use($registration) {
         $excel->sheet('List of Registrants', function ($sheet) use($registration) {
             $sheet->fromModel($registration, null, 'A1', false, false);
             $sheet->prependRow(1, array('ID', 'Reg_ID', 'Name', 'Gender', 'Degree', 'Course', 'Year', 'Department', 'College with Address', 'Email ID', 'Contanct No.', 'Guardian\'s contanct No.', 'Amount', 'DD No.', 'DD Date', 'Bank Name', 'Reason', 'is NITT', 'Email Sent'));
             $sheet->freezePane('C2');
             $sheet->getColumnDimension('A')->setVisible(false);
             $sheet->getColumnDimension('R')->setVisible(false);
             $sheet->getColumnDimension('S')->setVisible(false);
         });
     })->export('xlsx');
 }
Esempio n. 2
0
 public function store_registration(Request $request)
 {
     $messages = ['digits_between' => 'The :attribute must be 10 digits.'];
     $v = Validator::make($request->all(), ['name' => 'required|min:3|max:255', 'gender' => 'required|in:male,female', 'degree' => 'required|in:UG,PG', 'course' => 'required|in:B.E,B.Tech,B.Sc,B.Com,B.A,M.Tech,M.B.A,M.Sc,other', 'other_course' => 'required_if:course,other', 'year' => 'required|in:Final year U.G.,Final year P.G.,Pre-final year of Engineering', 'branch' => 'required|min:2|max:20', 'college' => 'required|min:10|max:150', 'email' => 'required|email|unique:registrations', 'phone' => 'required|integer|digits_between:10,10', 'guardian_phone' => 'required|integer|digits_between:10,10', 'dd_no' => 'required|min:5|max:10', 'dd_date' => 'required|min:10|max:30', 'bank_name' => 'required|min:2|max:20', 'reason' => 'required|min:20|max:200'], $messages);
     //redirect to registration page with errors if there is any
     if ($v->fails()) {
         return redirect()->back()->withErrors($v->errors());
     }
     //else
     if (strcmp($request->course, "other") == 0) {
         $request->course = $request->other_course;
     }
     if (strcmp($request->degree, "UG") == 0) {
         $amount = 960;
     } else {
         $amount = 1560;
     }
     $registration = new Registration();
     $registration->name = $request->name;
     $registration->gender = $request->gender;
     $registration->degree = $request->degree;
     $registration->course = $request->course;
     $registration->year = $request->year;
     $registration->dept = $request->branch;
     $registration->college_address = $request->college;
     $registration->email = $request->email;
     $registration->mobile_no = $request->phone;
     $registration->guardian_mobile_no = $request->guardian_phone;
     $registration->amount = $amount;
     $registration->dd_no = $request->dd_no;
     $registration->dd_date = $request->dd_date;
     $registration->bank_name = $request->bank_name;
     $registration->reason = $request->reason;
     //save the record to table
     $save_status = $registration->save();
     if (!$save_status) {
         return redirect('/registration');
     }
     //update the reg_id of the inserted record
     $registration->reg_id = $registration->id + 1000;
     $registration->save();
     //generating the pdf
     $path = getcwd();
     $im_page_1 = imagecreatefromjpeg($path . '/images/Page1.jpg');
     $black = imagecolorallocate($im_page_1, 0, 0, 0);
     $font = $path . '/font/Helvetica.otf';
     $d = strtotime("now");
     $today = date("d-m-Y", $d);
     $college = $registration->college_address;
     $words = explode(" ", $college);
     $lines = [""];
     $k = 0;
     foreach ($words as $word) {
         if (strlen($lines[$k]) + strlen($word) <= 50) {
             $lines[$k] .= " " . $word;
         } else {
             $k++;
             $lines[$k] = "";
             $lines[$k] .= " " . $word;
         }
     }
     $k = 0;
     foreach ($lines as $line) {
         imagettftext($im_page_1, 35, 0, 740, 1475 + $k * 50, $black, $font, $line);
         $k++;
     }
     imagettftext($im_page_1, 35, 0, 2000, 1065, $black, $font, $registration->reg_id);
     imagettftext($im_page_1, 35, 0, 750, 1325, $black, $font, $registration->name);
     imagettftext($im_page_1, 35, 0, 750, 1625, $black, $font, $registration->degree);
     imagettftext($im_page_1, 35, 0, 750, 1775, $black, $font, $registration->course);
     imagettftext($im_page_1, 35, 0, 540, 2175, $black, $font, $today);
     $filename_page_1 = $registration->reg_id . ".png";
     imagepng($im_page_1, $filename_page_1);
     $pdf = new Imagick(array($filename_page_1));
     $pdf->setImageFormat("pdf");
     $filename_pdf = $registration->reg_id . '.pdf';
     if (!$pdf->writeImages($filename_pdf, true)) {
         die('Could not write!');
     }
     header('Content-Type: application/pdf');
     header("Content-Disposition: inline; filename=" . $filename_pdf);
     @readfile($filename_pdf);
     $delete_status_page_1 = unlink($filename_page_1);
     $delete_status_pdf = unlink($filename_pdf);
 }
Esempio n. 3
0
 public function show_registration(Request $request)
 {
     $id = $request->get('id');
     $registration = Registration::find($id);
     echo json_encode($registration);
 }