public function run()
{
DB::table('mats')->delete();
Mat::create(array('kdmat' => 'M01', 'kdjmat' => 'JM01', 'nama' => 'Material 1', 'satuan' => 'Kg', 'minstok' => '1', 'kdrekan' => 'RK01', 'tglpakai' => '2015-01-20', 'harga' => '100000', 'created_at' => new DateTime(), 'updated_at' => new DateTime()));
Mat::create(array('kdmat' => 'M02', 'kdjmat' => 'JM02', 'nama' => 'Material 2', 'satuan' => 'Gram', 'minstok' => '10', 'kdrekan' => 'RK02', 'tglpakai' => '2015-01-10', 'harga' => '250000', 'created_at' => new DateTime(), 'updated_at' => new DateTime()));
Mat::create(array('kdmat' => 'M03', 'kdjmat' => 'JM02', 'nama' => 'Material 3', 'satuan' => 'Kg', 'minstok' => '50', 'kdrekan' => 'RK01', 'tglpakai' => '2015-01-20', 'harga' => '400000', 'created_at' => new DateTime(), 'updated_at' => new DateTime()));
}
public function getRelasi()
{
$mat = Mat::select(array('mats.kdmat', 'mats.kdjmat', 'mats.nama', 'mats.satuan', 'mats.minstok', 'mats.kdrekan', 'mats.tglpakai', 'mats.harga'));
return Datatables::of($mat)->remove_column('rn')->make();
}
public function getData()
{
$mats = Mat::select(array('mats.kdmat', 'mats.kdjmat', 'mats.nama', 'mats.satuan', 'mats.minstok', 'mats.kdrekan', 'mats.tglpakai', 'mats.harga'));
return Datatables::of($mats)->add_column('actions', '
<div>
<a href="{{{ URL::to(\'admin/mats/\' . $kdmat . \'/\' . $kdrekan . \'/edit\' ) }}}" class="btn btn-primary btn-xs iframe" ><i class="fa fa-pencil"></i></a> <a href="{{{ URL::to(\'admin/mats/\' . $kdmat . \'/delete\' ) }}}" class="btn btn-xs btn-danger iframe"><i class="fa fa-trash-o"></i></a>
</div>
')->remove_column('rn')->make();
}
