public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
$user_id = rand(1, 10);
AkadBookedUnit::create(['booked_unit_id' => rand(1, 9), 'is_valid' => rand(0, 1), 'bank_id' => rand(1, 5), 'akad_amount' => rand(1000000, 9000000), 'akad_evidence' => rand(1111111111, 9999999999) . 'be', 'created_by' => $user_id, 'changed_by' => $user_id, 'change_reason' => $faker->realText(100)]);
}
}
/**
* function for send ajax request to view
*
* @return Response
*/
public function listingJson()
{
$query = AkadBookedUnit::select('id', 'booked_unit_id', 'is_valid', 'bank_id', 'akad_amount', 'created_at', 'changed_by')->with('User')->with('BookedUnit')->get();
return Datatable::collection($query)->addColumn('id', function ($model) {
return $model->id;
})->addColumn('is_valid', function ($model) {
$is_valid = $model->is_valid == '1' ? 'Yes' : 'No';
return $is_valid;
})->addColumn('bank_id', function ($model) {
//return $model->bank->name;
return '<a href="' . action('BanksController@detail', $model->bank_id) . '">' . ucfirst($model->bank->name) . '</a>';
})->addColumn('akad_amount', function ($model) {
return $model->akad_amount;
// return $model->project->name . $model->project_id;
})->addColumn('created_at', function ($model) {
return $model->created_at->format('d-m-Y');
})->addColumn('changed_by', function ($model) {
return $model->user->name;
})->addColumn('show', function ($model) {
return '<a href="' . action('AkadBookedUnitsController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>';
})->addColumn('edit', function ($model) {
return '<a href="' . action('AkadBookedUnitsController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>';
})->addColumn('delete', function ($model) {
return '<form action="' . action('AkadBookedUnitsController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>';
})->searchColumns('id', 'booked_unit_id', 'is_valid')->orderColumns('id', 'booked_unit_id', 'is_valid', 'bank_id', 'akad_amount', 'changed_by')->make();
}
