public function create_propbuilding($ac_id, $tipe)
 {
     $golongan = TransGol::lists('name', 'id');
     $investors = TransInvestor::lists('name', 'id');
     $status_sertifikat = TransStatusCert::lists('name', 'id');
     $forbuildings = TransForBuilding::lists('name', 'id');
     $statusbuildings = TransStatusBuilding::lists('name', 'id');
     $index_tanah = TransactionPropland::lists('index', 'index');
     return view('transaction_assets.create_propbuilding', compact('tipe', 'ac_id', 'golongan', 'investors', 'forbuildings', 'statusbuildings', 'index_tanah'));
 }
    public function trans_status_cert()
    {
        \DB::statement(\DB::raw('set @rownum=0'));
        $trans_status_certs = TransStatusCert::select([\DB::raw('@rownum  := @rownum  + 1 AS rownum'), 'id', 'name']);
        return Datatables::of($trans_status_certs)->addColumn('action', function ($trans_status_cert) {
            return '
      <button id="btn-delete" class="btn btn-xs btn-danger" data-remote="./destroy/' . $trans_status_cert->id . '/' . 'status_cert' . '">Delete</button>

      ';
        })->make(true);
    }