Rajin Ngoding: laravel

Upload Multi Table Relation Dengan Laravel Excel

Admin Ganteng 0 Aplikasi, Info Tekno, laravel, linux, tips and tricks Minggu, Desember 22, 2019

<div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="text-align: left;" trbidi="on"><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;">Assalamwalaikum Warohmatullahi Wabarokatuh.<br />
Hi.. sahabat rajin, kali ini kita akan membahas bagaimana cara Upload ke banyak table berelasi dengan 1 file excel pada package laravel excel.</div><div style="line-height: 100%; margin-bottom: 0in;">Pastikan mesin kamu sudah terinstall extentions php berikut :</div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_zip enabled</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_xml enabled</div><div style="line-height: 100%; margin-bottom: 0in;">PHP extension php_gd2 enabled</div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;">disini saya menggunakan laravel versi 6 dan mysql sebagai databasenya.</div><div style="line-height: 100%; margin-bottom: 0in;">Oya tujuan tulisan ini bukan untuk manggurui teman-teman sekalian, tetapi untuk catatan saya ketika saya lupa / mentok ketika ada masalah. Rasulullah shallallaahu ‘alaihi wa sallam bersabda:</div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="letter-spacing: normal;">“</span></span></span><em><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-weight: normal;">Ikatlah ilmu dengan dengan menulisnya</span></span></span></span></span></em><span style="font-variant: normal;"><span style="color: black;"><span style="letter-spacing: normal;">”</span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Kasus :</span></span></span></span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
<ul style="text-align: left;"><li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Users</b></span></span></span></span></span></span></li>
<li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Mahasiswa</b></span></span></span></span></span></span></li>
<li><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><b>Table Profile</b></span></span></span></span></span></span></li>
</ul></div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;"><br />
</span></span></span></span></span></span></span><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Dimana table mahasiswa dan profile masing-masing mempunyai field users_id</span></span></span></span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;"><span style="font-weight: normal;">Persiapan :</span></span></span></span></span></span></span></div><br />
<code><br />
composer require maatwebsite/excel<br />
</code><br />
<br />
<code><br />
'providers' => [<br />
/*<br />
* Package Service Providers...<br />
*/<br />
Maatwebsite\Excel\ExcelServiceProvider::class,<br />
]<br />
<br />
'aliases' => [<br />
...<br />
'Excel' => Maatwebsite\Excel\Facades\Excel::class,<br />
]<br />
</code><br />
<br />
<br />
<div style="font-weight: normal; line-height: 100%; margin-bottom: 0in;"><span style="font-variant: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: small;"><span style="letter-spacing: normal;"><span style="font-style: normal;">Lalu Publish Vendor Providers dengan perintah</span></span></span></span></span></span></div><style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>    <br />
<div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><div style="line-height: 100%; margin-bottom: 0in;"><pre><code>
php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"
</code>
</pre></div><br />
<style type="text/css">
  @page { margin: 0.79in }
  p { margin-bottom: 0.1in; line-height: 115% }
  a:link { so-language: zxx }
 </style>   <br />
<div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: 12pt;">Selanjutnya kita akan buat file import dengan melakukan perintah :</span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><span style="font-variant-east-asian: normal; font-variant-numeric: normal;"><span style="color: black;"><span style="font-family: "lato" , sans-serif;"><span style="font-size: 12pt;"><br />
</span></span></span></span></div><div style="line-height: 100%; margin-bottom: 0in;"><br />
</div><pre><code>
php artisan make:import MhsImport
</code>
</pre>Jika Kita Cek ada folder baru di dalam app/Imports/MhsImport<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDoz5sWb8TZWpF27aLpT25pDbnnEt3oaa2M1CLy-PTAOliOXzguxJ1of88o34JYJPELl-wVWSxigv8h6eB4QeUFvB1IB_ijY-vVFAjCmIBOAUsPVXRpi6ClAN3r50BrxIqDfi3KO_GZyE/s1600/folder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="258" data-original-width="190" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDoz5sWb8TZWpF27aLpT25pDbnnEt3oaa2M1CLy-PTAOliOXzguxJ1of88o34JYJPELl-wVWSxigv8h6eB4QeUFvB1IB_ijY-vVFAjCmIBOAUsPVXRpi6ClAN3r50BrxIqDfi3KO_GZyE/s320/folder.png" width="233" /></a></div><br />
Pertama kita akan menggunakan metode collection untuk membaca isi dari file excel yang akan kita buat :<br />
Untuk Template excel saya buat seperti berikut :<br />
<style type="text/css">
  body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small }
  a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em;  } 
  a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em;  } 
  comment { display:none;  } 
 </style>      <br />
<table border="0" cellspacing="0"><colgroup width="92"></colgroup>  <colgroup width="69"></colgroup>  <colgroup width="167"></colgroup>  <colgroup width="89"></colgroup>  <colgroup width="84"></colgroup>  <colgroup width="75"></colgroup>  <colgroup width="90"></colgroup>  <colgroup width="77"></colgroup>  <colgroup width="80"></colgroup>  <colgroup width="61"></colgroup>  <colgroup width="63"></colgroup>  <colgroup width="71"></colgroup>  <tbody>
<tr>   <td align="center" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">NAMA</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">NIM</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">EMAIL</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">PASSWORD</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ANGKATAN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">JURUSAN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">KURIKULUM</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">TTL</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">KELAMIN</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">AGAMA</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">STATUS</td>   <td align="center" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">DIBUAT</td>  </tr>
<tr>   <td align="left" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">aman</td>   <td align="right" sdnum="1033;" sdval="14050880" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">14050880</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">aman@email.com</td>   <td align="right" sdnum="1033;" sdval="123" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">123</td>   <td align="right" sdnum="1033;" sdval="192" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">192</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Ekonomi</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Ekonomi</td>   <td align="left" sdnum="1033;0;@" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1991-05-05</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">LAKI-LAKI</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ISLAM</td>   <td align="right" sdnum="1033;" sdval="1" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">admin</td>  </tr>
<tr>   <td align="left" height="17" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">asas</td>   <td align="right" sdnum="1033;" sdval="1405051" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1405051</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">asas@email.com</td>   <td align="right" sdnum="1033;" sdval="124" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">124</td>   <td align="right" sdnum="1033;" sdval="192" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">192</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Perbankan</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">Perbankan</td>   <td align="left" sdnum="1033;0;@" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1991-05-06</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">LAKI-LAKI</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">ISLAM</td>   <td align="right" sdnum="1033;" sdval="1" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">1</td>   <td align="left" style="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000;" valign="bottom">admin</td>  </tr>
</tbody></table><code><br />
<br />
namespace App\Imports;<br />
<br />
use Illuminate\Support\Collection;<br />
use Maatwebsite\Excel\Concerns\ToCollection;<br />
use Maatwebsite\Excel\Concerns\WithHeadingRow;<br />
use DB;<br />
use App\User;<br />
use Carbon\Carbon;<br />
<br />
</code></div><br />
<br />
Code Lengkap Isi Dari Class MhsImport<br />
<pre><code>
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use DB;
use App\User;
use Carbon\Carbon;
use App\Notifications\UserWelcome;

class MhsImport implements WithHeadingRow,ToCollection
{
/**
* @param Collection $collection
*/
public function collection(Collection $rows)
{

foreach ($rows as $key) {
$user=User::updateOrCreate(
['email'=>$key['email'],'nim'=>$key['nim']]
,[
'uuid'=>unik(),
'name'=>$key['nama'],

'password'=>bcrypt($key['password']),
'old_password'=>$key['password'],
'status'=>$key['status'],
'created_by'=>$key['dibuat']

]);
$selectuser=User::where('email',$key['email'])->get();
$jurusan=DB::table('jurusan')->where('name','LIKE','%'.$key['jurusan'].'%')->first();
$kurikulum=DB::table('kurikulum')->where('name','LIKE','%'.$key['kurikulum'].'%')->first();

foreach ($selectuser as $mhs ) {
$x=DB::table('mahasiswa')->updateOrInsert(['users_uuid'=>$mhs->uuid],[
'uuid'=>unik(),
'nim'=>$mhs->nim,
'angkatan'=>$key['angkatan'],
'jurusan_uuid'=>$jurusan->uuid,
'kurikulum_uuid'=>$kurikulum->uuid,
'created_by'=>'Import',
'created_at'=>Carbon::now(),

]);
}
foreach ($selectuser as $pro ) {
DB::table('profile')->updateOrInsert(['users_uuid'=>$pro->uuid],[
'uuid'=>unik(),
'nama_lengkap'=>$pro->name,
'religion'=>$key['agama'],
'dob'=>$key['ttl'],
'sex'=>$key['kelamin']
]);
}
}

}

}
</code>
</pre></div><br />
<br />
Lalu isi file Controller<br />
<pre><code>
use App\Imports\MhsImport;
use Excel;
use DB;

class TesController extends Controller
{

public function store(Request $request)
{
DB::beginTransaction();

try {
DB::commit();

$file = $request->file('file');
Excel::import(new MhsImport,$file);

echo "OK";
} catch (\Exception $e) {
DB::rollback();
//toastr()->error($e->getMessage());
echo $e->getMessage();
}

}
</code>
</pre></div><br />
Ok sekian wasalamwalikum..</div>

Upload Multi Table Relation Dengan Laravel Excel

Assalamwalaikum Warohmatullahi Wabarokatuh. Hi.. sahabat rajin, kali ini kita akan membahas bagaimana cara Upload ke banyak table berel...

Baca selengkapnya »

Mengatasi A non-numeric value encountered pada looping laravel

Admin Ganteng 0 laravel, tips and tricks Sabtu, November 02, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
Simple<br />
Masalah ini disebabkan karena operator arimatika tidak berfungsi jika integer + string<br />
seperti : 20+'30'<br />
jadi bagaimana mensiasatinya?<br />
berikut<br />
contoh : Salah<br />
<code><br />
$total='';<br />
$data=DB::table('jadwal')<br />
->select('jadwal.uuid as uuid','mata_kuliah.sks as sks')<br />
->join('krs_mhs','krs_mhs.jadwal_uuid','=','jadwal.uuid')<br />
->join('mata_kuliah','mata_kuliah.mk_uuid','=','jadwal.mk_uuid')<br />
->where('jadwal.akademik_uuid',tahunakademik())<br />
->where('krs_mhs.users_uuid', $user)<br />
->groupBy('jadwal.uuid','mata_kuliah.sks')<br />
->get();<br />
<br />
foreach ($data as $key) {<br />
$total+=$key->sks;<br />
}<br />
return $total;<br />
</code><br />
<br />
Bisa kita perhatikan bahwa variable <b>$total </b>bernilai string sehingga outpunya pun terpengaruh menjadi string.<br />
coba edit variable nya menjadi <b>$total=0 </b>, lalu lakukan refresh kembali.<br />
<br />
tulisan ini bertujuan supaya saya tidak lupa.<br />
teriamkasih semua. ⺗<br />
<br /></div>

Mengatasi A non-numeric value encountered pada looping laravel

Simple Masalah ini disebabkan karena operator arimatika tidak berfungsi jika integer + string seperti : 20+'30' jadi bagaimana m...

Baca selengkapnya »

Cara Parser Variable {{}} Dinamis Laravel Blade

Admin Ganteng 0 Aplikasi, Info Tekno, laravel, postgress, Web Programming Selasa, Mei 21, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Hai Assalamwalaikum, Hari ini saya akan mencoba berbagi tips bagaimana cara parser variable dinamis menggunakan blade di laravel untuk kebutuhan tamplate email, dokumen, surat menyurat dan lain-lain.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Tujuan saya menulis ini sebenarnya supaya tidak lupa, karena ilmu masih belum seberapa. Jadi mohon dimaklumi jika ada tulisan saya yang tidak teman-teman mengerti.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Awalnya saya mencari bagaimana cara parser variable dinamis ke editor (Ckeditor)  dengan segala keterbatasan dan ditambah jadwal dateline yang mepet, karena harus menyelesaikan modul ini kebayang gimana putus asa. Wkwk.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Awalnya tulisan menarik saya temukan pada blog </span><a href="http://tnt.studio/blog/email-templates-from-database"><u><span class="15" style="color: blue; font-family: "times new roman"; text-decoration: underline;">tnt.studio</span></u></a><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"> disana di jelaskan bagaimana cara membuat email tamplate yang datanya dari DB.</span><span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: SimSun; mso-spacerun: 'yes';">Sebenarnya ada 2 metode untuk melakukannya, yang pertama menggunakan </span><b><span style="font-family: "calibri"; font-weight: bold;">str_replace , preg_replace_callback .</span></b><b><span style="font-family: "calibri"; font-weight: bold;"><o:p></o:p></span></b></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;">Bisa kita taruh di helper ataupun di dalam model.</span><span style="font-family: "calibri"; font-weight: normal;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;">Dalam case ini saya akan menaruhnya di model, sesuai tutorial dari blog di atas,  dengan bahasa yang fahami.</span><span style="font-family: "calibri"; font-weight: normal;"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<span style="font-family: "calibri"; font-weight: normal;"> Metode pertama:</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<pre><span style="font-family: "calibri"; font-weight: normal;"><code>     $nama_user='Admin Ganteng';
     $data=str_replace('{{$nama_user}}',$nama_user,'' );
     $text="Haloo {$nama_user}... Apa Kabar?";
     return view('tes',['konten'=>$text]);</code></span></pre>
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj4ZQ5CytSSJD0JKucBxTIGfqRZcMCcPKKCAYP8fjYXKpC1YJqJ8PSBh38KR-K7j4ZFCq2Ope1JcgnPhwKwYElN40TjqoOX4iq6fJpKYTuP0K3ScEknfUtAdAOwZ2qxZLXP3fy503qPiI/s1600/Screenshot+from+2019-05-21+10-38-03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="135" data-original-width="481" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj4ZQ5CytSSJD0JKucBxTIGfqRZcMCcPKKCAYP8fjYXKpC1YJqJ8PSBh38KR-K7j4ZFCq2Ope1JcgnPhwKwYElN40TjqoOX4iq6fJpKYTuP0K3ScEknfUtAdAOwZ2qxZLXP3fy503qPiI/s1600/Screenshot+from+2019-05-21+10-38-03.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXCMTyGK62nj1ryV6BUrCYqMG8eXJGrBYTcPItnAgo0lPcmEvXnY-SgtjaBNeHkxUuYxh8W5oSUWQJH0a4QcGH5THsXSNdd5Zv5CsFtnQT5SXUN0cy205wECYLIrG0vJqQe4OQLEOXNCM/s1600/Screenshot+from+2019-05-21+10-38-52.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="390" data-original-width="957" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXCMTyGK62nj1ryV6BUrCYqMG8eXJGrBYTcPItnAgo0lPcmEvXnY-SgtjaBNeHkxUuYxh8W5oSUWQJH0a4QcGH5THsXSNdd5Zv5CsFtnQT5SXUN0cy205wECYLIrG0vJqQe4OQLEOXNCM/s1600/Screenshot+from+2019-05-21+10-38-52.png" /></a></div>
<pre><span style="font-family: "calibri"; font-weight: normal;"><code><div class="MsoNormal">
<div class="MsoNormal">
</div>
</div>
</code></span></pre>
<br />
Metode ke 2,<br />
Siapkan 1 Controller dan 1 Models:<br />
<br />
<br />
<pre><code>
    protected $table="tes";
    public function parse($data)
{
    $parsed = preg_replace_callback('/{{(.*?)}}/', function ($matches) use ($data) {
        list($shortCode, $index) = $matches;

if( isset($data[$index]) ) {
            return $data[$index];
        } else {
            throw new Exception("Shortcode {$shortCode} not found in template id {$this->id}", 1);
        }

}, $this->content);

return $parsed;
</code>
</pre>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8JQfe_2wj8tImB18mLPJvNQYLEl9vOIML6ROEUUiz54wqSfHAcmLDZx78MUqgkyxtSMViSKsFb9ztHKszluKiosW9wA9_VYlASxY1s-0-7CmB-Vzp7bgiof2D7zj7omz7hmDnSQe8y8/s1600/Screenshot+from+2019-05-21+11-16-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="519" data-original-width="839" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8JQfe_2wj8tImB18mLPJvNQYLEl9vOIML6ROEUUiz54wqSfHAcmLDZx78MUqgkyxtSMViSKsFb9ztHKszluKiosW9wA9_VYlASxY1s-0-7CmB-Vzp7bgiof2D7zj7omz7hmDnSQe8y8/s1600/Screenshot+from+2019-05-21+11-16-19.png" /></a></div>
<br />
Bagian Controller<br />
<pre><code>
$db=DB::table('tes')->where('id',44)->first();
     $template          = new Tes;
     $template->id      = 44;
     $template->content =$db->nama_aja;
     $data              = [
       'nama_pt'=>'PT. ABC',
       'nama_saya'=>"Admin Ganteng"
     ];
     return view('tes',['konten'=>$template->parse($data)]);
</code>
</pre>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVSvLpjLxYaHwDPQxLENd-cpJDMdmvm1_wsZuuwsMhpoBx198y80PCH_1UPtF2pCHb4CoCt_jovXlM5BXU7S_siPvV6OJvUzBFCKRKXVVyrtEeR7H7s3Vv2mkozlxDk-DsSbwwPUocKa0/s1600/xd.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="341" data-original-width="530" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVSvLpjLxYaHwDPQxLENd-cpJDMdmvm1_wsZuuwsMhpoBx198y80PCH_1UPtF2pCHb4CoCt_jovXlM5BXU7S_siPvV6OJvUzBFCKRKXVVyrtEeR7H7s3Vv2mkozlxDk-DsSbwwPUocKa0/s1600/xd.png" /></a></div>
<br />
Source database yang isinya HTML:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhxvRbLBr8yAm_M5uWJYn7iKmylKCEKMGs2WzA2LQuiGheacq6oPu3yuG60szaTin-_5TvIBKFf7W4yyIS5caacuNoO9jjbRlMl7LcxqIPY-eX6-W6pYsI9WM1c-aOEdaHOGxPcKc7ctk/s1600/Screenshot+from+2019-05-21+11-29-25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="229" data-original-width="652" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhxvRbLBr8yAm_M5uWJYn7iKmylKCEKMGs2WzA2LQuiGheacq6oPu3yuG60szaTin-_5TvIBKFf7W4yyIS5caacuNoO9jjbRlMl7LcxqIPY-eX6-W6pYsI9WM1c-aOEdaHOGxPcKc7ctk/s1600/Screenshot+from+2019-05-21+11-29-25.png" /></a></div>
<br />
<br />
Output:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN1_qfKosCdKq4GB7p_fUGuYszqjTLxB_twmybnitmHFfWxVIh_lNbin6lL2fRy8tO2ulMox8kuYe5TDl00KOGXgkgvwKL_IXC8FVc4No8GvYJ0Q9s_bBvxTCJSJDHOrMHasenyU5eRhA/s1600/Screenshot+from+2019-05-21+11-49-15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="315" data-original-width="944" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN1_qfKosCdKq4GB7p_fUGuYszqjTLxB_twmybnitmHFfWxVIh_lNbin6lL2fRy8tO2ulMox8kuYe5TDl00KOGXgkgvwKL_IXC8FVc4No8GvYJ0Q9s_bBvxTCJSJDHOrMHasenyU5eRhA/s1600/Screenshot+from+2019-05-21+11-49-15.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
Caranya masih sama cukup menambahkan <b>{{nama_pt}}, {{nama_saya}} </b>dalam value databse tsb.<br />
<br />
<br />
ok sekian tipsnya, wasalam.<br />
<br /></div>
</div>

Cara Parser Variable {{}} Dinamis Laravel Blade

Hai Assalamwalaikum, Hari ini saya akan mencoba berbagi tips bagaimana cara parser variable dinamis menggunakan blade di laravel untuk keb...

Baca selengkapnya »

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Admin Ganteng 0 laravel, postgress, tips and tricks, Web Programming Senin, April 22, 2019

<div dir="ltr" style="text-align: left;" trbidi="on">
Assalamwalaikum man teman,<br />
Kali ini saya Akan membagikan sedikit trik bagaimana membuat penomoran otomatis pada laravel 5.8,<br />
Sebenarnya cara ini saya adopsi dari tulisan bang fikri di <a href="http://mfikri.com/artikel/Membuat-Kode-unik-berdasarkan-tanggal-dengan-Codeigniter.html" target="_blank">http://mfikri.com</a> . Tapi bedanya saya  terapkan pada laravel, Oya dalam case ini Laravel yang  saya pakai versi 5.8 dan database Postgress jika kalian menggunakan Mysql jangan khawatir, karena syntax query builder tidak jauh berbeda.<br />
oke langsung aja, saya anggap temen-temen sudah instal pacakage Laravel nya, jadi tidak harus dijeslakan hehe.<br />
<br />
pertama kita buat table nya terlebih dahulu.<br />
<code><br />
</code><br />
<pre><code>-- Table: public.project

-- DROP TABLE public.project;

CREATE TABLE public.project
(
    id bigint NOT NULL DEFAULT nextval('project_id_seq'::regclass) ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
    kode character varying(50) COLLATE pg_catalog."default",
    jenis_id integer NOT NULL,
    layanan_id integer NOT NULL,
    user_id integer,
    total_penghadap integer,
    status character varying(15) COLLATE pg_catalog."default",
    create_at timestamp without time zone,
    add_by character varying(50) COLLATE pg_catalog."default",
    update_at time without time zone,
    update_by character varying(50) COLLATE pg_catalog."default",
    CONSTRAINT project_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.project
    OWNER to postgres;
</code></pre>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLDulmf4KOGH2mOCinZzQrTo8-edF1oFYbpbnBfZIC9OZxyt46yiMJM1gNsyc97A8Ir4rJ5QBIKph2L-Ia65BNDW35ovcMQX2AqwebVVn2cY4xYyVC4gFVxzeu34b5DhmmIZbo0EEeyZM/s1600/blog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="412" data-original-width="666" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLDulmf4KOGH2mOCinZzQrTo8-edF1oFYbpbnBfZIC9OZxyt46yiMJM1gNsyc97A8Ir4rJ5QBIKph2L-Ia65BNDW35ovcMQX2AqwebVVn2cY4xYyVC4gFVxzeu34b5DhmmIZbo0EEeyZM/s1600/blog.png" /></a></div>
<br />
lalu buat controler baru dengan perintah<br />
<code><br />
</code><br />
<pre><code>php artisan make:controller KodeController
</code></pre>
<code><br />
</code><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Iq8NgWwydedT0CnA5DuM22jWsSXZbwAOnIlZfPXngM4TW2pfQaf-2pD_AL-wdQGeF4kyaEmU5JIoFe2yVO454unHvN5BhYGGTz8-oB9isKnunKMDUa0Tb8t93doxwwHbmAq2QcrUrmE/s1600/terminal.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="122" data-original-width="907" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Iq8NgWwydedT0CnA5DuM22jWsSXZbwAOnIlZfPXngM4TW2pfQaf-2pD_AL-wdQGeF4kyaEmU5JIoFe2yVO454unHvN5BhYGGTz8-oB9isKnunKMDUa0Tb8t93doxwwHbmAq2QcrUrmE/s1600/terminal.png" /></a></div>
Kurang lebih isinya seperti ini :<br />
<code class="php"><br />
</code><br />
<pre><code class="php">namespace App\Http\Controllers;

use DB;

use Carbon\Carbon;
class KodeController extends Controller
{
  //
  public function index()
  {
    
    echo $this->kode();

}
  protected function kode()
  {
    $kd="";
   $query = DB::table('project')
   ->select(DB::raw('MAX(RIGHT(kode,4)) as kd_max'))
    ->whereDate('create_at',Carbon::today());
   if ($query->count()>0) {
    foreach ($query->get() as $key ) {
    $tmp = ((int)$key->kd_max)+1;
    $kd = sprintf("%04s", $tmp);
    }
   }else {
$kd = "0001";
   }

return  "PR-".date('dmy').$kd;
  }
   
}
</code></pre>
<code class="php"><br />
</code><br />
setelah itu kita buat <b>Route </b>untuk mengarahkan ke Controller yang kita buat tadi.<br />
<br />
<code class="php"></code><br />
<pre><code class="php">Route::get('tes', 'KodeController@index');
</code></pre>
<br />
<br />
lalu bisa langsung panggil <i>localhost/nama_aplikasi/kode </i>Maka harusnya outputnya seperti ini<br />
<b>PR-2204190002<i>  </i></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHNyJE-Jz0XNQO1QZ82LG3yVgIiM_MP9s4QUyGOttTiXModqvy6cOH4ktMFh2OzbLEgJr8Fyvt3d5CztfU2togU5zbx6HwtWkYgzdDDbge_mfBQqpzI_2EPhBRx_NEAgOXmzto64vduec/s1600/web.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="98" data-original-width="620" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHNyJE-Jz0XNQO1QZ82LG3yVgIiM_MP9s4QUyGOttTiXModqvy6cOH4ktMFh2OzbLEgJr8Fyvt3d5CztfU2togU5zbx6HwtWkYgzdDDbge_mfBQqpzI_2EPhBRx_NEAgOXmzto64vduec/s1600/web.png" /></a></div>
<b><i><br /></i></b>
Seperti yang di jelaskan di tulisan situs sumber bahwa kode unik tersebut berarti 22 (day), 04 (month),19(year), dan 0001 (jumlah digit yang mampu ditampung).<br />
<br />
Hah 0001, berarti jumlah digit yang mampu ditampung juga 9999 donk?<br />
<br />
Benar, jumlah digit yang mampu ditampung memang 9999. Tetapi, yang mampu ditampung adalah 9999 per-hari. Jika tanggalnya berubah, misalkan tanggal 23/04/2019 maka jumlah digit akan kembali ke 0001. Sehingga kode uniknya menjadi 23042019. Dalam arti kata kode unik berdasarkan tanggal ini mampu menampung 9999 transaksi perhari.<br />
<br />
oke sekian dan terimakasih,<br />
sumber terkait : <a href="http://mfikri.com/artikel/Membuat-Kode-unik-berdasarkan-tanggal-dengan-Codeigniter.html" target="_blank">http://mfikri.com</a><br />
Wasalam</div>

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Assalamwalaikum man teman, Kali ini saya Akan membagikan sedikit trik bagaimana membuat penomoran otomatis pada laravel 5.8, Sebenarnya c...

Baca selengkapnya »

Rajin Ngoding

Upload Multi Table Relation Dengan Laravel Excel

Mengatasi A non-numeric value encountered pada looping laravel

Cara Parser Variable {{}} Dinamis Laravel Blade

Membuat Nomor Transaksi Otomatis Tidak Habis Pada Laravel 5.8

Entri Populer

Arsip Blog

Labels