public function searchDataCase() { $start_date = Input::get('start_date'); $end_date = Input::get('end_date'); // return $start_date; $datacase = DataCase::with('criminalhistory', 'criminalhistory.nametitle')->whereBetween('date_case', [$start_date, $end_date])->get(); $person = CriminalHistory::with('datacase', 'nametitle')->whereBetween('date', [$start_date, $end_date])->get(); $person_general = GuestHistory::with('nametitle')->whereBetween('date', [$start_date, $end_date])->get(); $data = [$person, $person_general, $datacase]; return $data; }
public function printPhotoPerson($id) { //return $id; $criminalhistory = CriminalHistory::with('nametitle')->find($id); // return $criminalhistory; //$pdf = \App::make('mpdf.wrapper',['ภาษา','ขนาดการดาษ-L=แนวนอน ไม่- แนวตั้ง','','',ขอบซ้ายกระดาษ,ขอบขวากระดาษ,ขอบขนกระดาษ,ขอบล่างกระดาษ,ระยะ title,ระยะ footter]); $pdf = \App::make('mpdf.wrapper', ['th', 'A4', '', '', 20, 15, 20, 25, 10, 10]); $pdf->setTitle("export"); $pdf->SetWatermarkText("TEST"); $pdf->SetDisplayMode('fullpage'); $html = view('PDF.photo_person')->with('criminalhistory', $criminalhistory)->render(); // return $html; $pdf->WriteHTML($html); $pdf->stream(); }
/* |-------------------------------------------------------------------------- | Application Routes |-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the controller to call when that URI is requested. | */ Route::get('/test', 'WelcomeController@test'); Route::get('/pdfrank', 'WelcomeController@pdfrank'); Route::get('/profile', 'WelcomeController@typecase'); Route::get('/test', function () { $criminalhistory = \App\Models\CriminalHistory::with('datacase.cases.typecase', 'typepeople', 'sex', 'addresspresent', 'addressoriginal', 'datafather', 'datamother', 'dataspouse', 'datachild', 'addressoffice')->find(8); return View('test3')->with('criminalhistory', $criminalhistory); }); Route::get('/pdf', function () { $profile = App\Models\DataCase::with('criminalhistory')->find(29); return $profile; //$pdf = \App::make('mpdf.wrapper',['ภาษา','ขนาดการดาษ-L=แนวนอน ไม่- แนวตั้ง','','',ขอบซ้ายกระดาษ,ขอบขวากระดาษ,ขอบขนกระดาษ,ขอบล่างกระดาษ,ระยะ title,ระยะ footter]); $pdf = \App::make('mpdf.wrapper', ['th', 'A4', '', '', 20, 15, 20, 25, 10, 10]); $pdf->SetWatermarkText("TEST"); $pdf->SetDisplayMode('fullpage'); $html = view('test')->with('profile', $profile)->render(); $pdf->WriteHTML($html); $pdf->stream(); }); Route::get('/testqq', function () { $type = App\Models\TypeCase::with('cases')->find(5);
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($personId, $childId) { $person = CriminalHistory::find($personId); if ($childId) { $datachild = DataChild::find($childId)->delete(); return $person; } else { return null; } }
public function searchDataCase() { $start_date = Input::get('start_date'); $end_date = Input::get('end_date'); // return $start_date; $datacase = DataCase::with('criminalhistory', 'criminalhistory.nametitle')->whereBetween('date_case', [$start_date, $end_date])->get(); $person = CriminalHistory::with('datacase', 'nametitle')->whereBetween('date', [$start_date, $end_date])->get(); $person_general = GuestHistory::with('nametitle')->whereBetween('created_at', [$start_date, $end_date])->get(); $data = [$person, $person_general, $datacase]; $start_date = Input::get('start_date'); $end_date = Input::get('end_date'); // return $start_date; $datacase = DataCase::with('criminalhistory', 'criminalhistory.nametitle')->whereBetween('date_case', [$start_date, $end_date])->get(); $person = CriminalHistory::with('datacase', 'nametitle')->whereBetween('date', [$start_date, $end_date])->get(); $person_general = GuestHistory::with('nametitle')->whereBetween('created_at', [$start_date, $end_date])->get(); $data = [$person, $person_general, $datacase]; $pdf = \App::make('mpdf.wrapper', ['th', 'A4', '', '', 20, 15, 20, 25, 10, 10]); $pdf->SetHeader(' <table width="100%" style="vertical-align: bottom; font-family: TH SarabunPSK; font-size: 14pt; color: #000000; font-weight: bold; font-style: italic;"><tr> <td width="20%"><img src="img/police.jpg" width="20" height="20"></td> <td width="30%" style="text-align: right; ">{PAGENO}</td> <td width="55%" style="text-align: right; "> สำนักงานตำรวจตรวจคนเข้าเมือง จังหวัด เชียงราย</td> </tr></table> '); $pdf->SetFooter(' <table width="100%" style="vertical-align: bottom; font-family: garuda; font-size: 8pt; color: #000000; font-weight: bold; font-style: italic;"><tr> <td width="33%"></td> <td width="33%"></td> <td width="55%" style="text-align: right; ">พิมพ์เมื่อ {DATE D} ที่ {DATE j-m-Y} เวลา {DATE H:i:s} </td> </tr></table> '); $pdf->SetWatermarkText(""); $pdf->SetDisplayMode('fullpage'); $html = view('PDF.statistic')->with('data', $data)->render(); // return $html; $pdf->WriteHTML($html); return $data; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($personId, $officeId) { $person = CriminalHistory::find($personId); if ($officeId) { $addressoffice = AddressOffice::find($officeId)->delete(); return $person; } else { return null; } }
public function generatedPdfPerson($id) { $criminalhistory = CriminalHistory::with('datacase', 'nametitle', 'addresspresent', 'addressoriginal', 'datafather', 'datamother', 'dataspouse', 'datachild', 'addressoffice', 'datacase.vehicle', 'datacase.weapon')->find($id); Event::fire(new PrintPdfDataPersonCrimeEvent($criminalhistory)); //return $dataperson; //$pdf = \App::make('mpdf.wrapper',['ภาษา','ขนาดการดาษ-L=แนวนอน ไม่- แนวตั้ง','','',ขอบซ้ายกระดาษ,ขอบขวากระดาษ,ขอบขนกระดาษ,ขอบล่างกระดาษ,ระยะ title,ระยะ footter]); //return $datacase; $pdf = \App::make('mpdf.wrapper', ['th', 'A4', '', '', 20, 15, 20, 25, 10, 10]); //$pdf->SetHeader('|{PAGENO}/{nbpg}|สำนักงานตำรวจตรวจคนเข้าเมือง จังหวัด เชียงราย'); // $pdf->SetFooter('พิมพ์เมื่อ วัน {DATE D} ที่ {DATE j-m-Y} เวลา {DATE H:i:s} '); $pdf->SetHeader(' <table width="100%" style="vertical-align: bottom; font-family: TH SarabunPSK; font-size: 14pt; color: #000000; font-weight: bold; font-style: italic;"><tr> <td width="20%"><img src="img/police.jpg" width="20" height="20"></td> <td width="30%" style="text-align: right; ">{PAGENO}</td> <td width="55%" style="text-align: right; "> สำนักงานตำรวจตรวจคนเข้าเมือง จังหวัด เชียงราย</td> </tr></table> '); $pdf->SetFooter(' <table width="100%" style="vertical-align: bottom; font-family: garuda; font-size: 8pt; color: #000000; font-weight: bold; font-style: italic;"><tr> <td width="33%"></td> <td width="33%"></td> <td width="55%" style="text-align: right; ">พิมพ์เมื่อ {DATE D} ที่ {DATE j-m-Y} เวลา {DATE H:i:s} </td> </tr></table> '); $pdf->SetWatermarkText(""); $pdf->SetDisplayMode('fullpage'); $html = view('PDF.personOne')->with('dataperson', $criminalhistory)->render(); //return $html; $pdf->WriteHTML($html); $pdf->stream(); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($caseId, $personId) { /* @var Datacase $case */ $case = DataCase::find($caseId); $person = CriminalHistory::find($personId); if ($person) { $case->criminalhistory()->detach($person->id); return $case; } else { return null; } }
public function generatedPdfPerson($id) { $criminalhistory = CriminalHistory::find($id); $idcard = $criminalhistory->idcard; $datacasesPerson = CriminalHistory::with('datacase', 'addresspresent', 'addressoriginal', 'datafather', 'datamother', 'dataspouse', 'datachild', 'addressoffice', 'datacase.vehicle', 'datacase.weapon')->where(function ($q) use($idcard) { return $q->where('idcard', '=', "{$idcard}"); })->get(); $criminalhistory = CriminalHistory::with('datacase', 'addresspresent', 'addressoriginal', 'datafather', 'datamother', 'dataspouse', 'datachild', 'addressoffice', 'datacase.vehicle', 'datacase.weapon')->find($id); Event::fire(new PrintPdfDataPersonCrimeEvent($criminalhistory)); //return $dataperson; //$pdf = \App::make('mpdf.wrapper',['ภาษา','ขนาดการดาษ-L=แนวนอน ไม่- แนวตั้ง','','',ขอบซ้ายกระดาษ,ขอบขวากระดาษ,ขอบขนกระดาษ,ขอบล่างกระดาษ,ระยะ title,ระยะ footter]); //return $datacase; $pdf = \App::make('mpdf.wrapper', ['th', 'A4', '', '', 20, 15, 20, 25, 10, 10]); $pdf->setTitle("export"); //$pdf->SetHeader('|{PAGENO}/{nbpg}|สำนักงานตำรวจตรวจคนเข้าเมือง จังหวัด เชียงราย'); // $pdf->SetFooter('พิมพ์เมื่อ วัน {DATE D} ที่ {DATE j-m-Y} เวลา {DATE H:i:s} '); $pdf->SetHeader(' <table width="100%" style="vertical-align: bottom; font-family: TH SarabunPSK; font-size: 14pt; color: #000000; font-weight: bold; font-style: italic;"><tr> <td width="20%"></td> <td width="30%" style="text-align: right; ">{PAGENO}</td> <td width="55%" style="text-align: right; "> ตรวจคนเข้าเมืองจังหวัดเชียงราย</td> </tr></table> '); $user = Auth::user(); $rank = $user->rank->rank; \Carbon\Carbon::setLocale('th'); setlocale(LC_TIME, 'th_TH'); $date = \Carbon\Carbon::now(); $daymonth = $date->formatLocalized('%d/%m/'); $year = $date->year + 543; $pdf->SetFooter("\n <table width='100%' style='vertical-align: bottom; font-family: garuda; font-size: 8pt; color: #000000; font-weight: bold; font-style: italic;'><tr>\n \n <td width='45%'>พิมพ์โดย {$rank} {$user->name_police} {$user->surname_police}</td>\n <td width='55%' style='text-align: right; '>พิมพ์เมื่อ {$daymonth}{$year}</td>\n </tr></table>\n "); $pdf->SetWatermarkText(""); $pdf->SetDisplayMode('fullpage'); $html = view('PDF.personOne')->with('dataperson', $criminalhistory)->with('datacases', $datacasesPerson)->render(); //return $html; $pdf->WriteHTML($html); $pdf->stream(); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($personId, $employeeId) { $person = CriminalHistory::find($personId); if ($employeeId) { $employee = Employee::find($employeeId)->delete(); return $person; } else { return null; } }