PHP Unit::select方法代码示例

 /**
  * function for send ajax request to view
  *
  * @return Response
  */
 public function listingJson()
 {
     //$query = Building::all();
     $query = Unit::select('id', 'block', 'unit_type_id', 'additional_land_area', 'additional_facility', 'changed_by')->with('User')->with('UnitType')->get();
     return Datatable::collection($query)->addColumn('block', function ($model) {
         return ucfirst($model->block);
     })->addColumn('unit_type_id', function ($model) {
         // return $model->unit_type_id;
         return ucfirst($model->unitType->name);
     })->addColumn('additional_land_area', function ($model) {
         return $model->additional_land_area;
     })->addColumn('additional_facility', function ($model) {
         $additional_facility = $model->additional_facility ? 'Yes' : 'No';
         return $additional_facility;
     })->addColumn('changed_by', function ($model) {
         return $model->user->name;
         // return $model->changed_by;
     })->addColumn('show', function ($model) {
         return '<a href="' . action('UnitsController@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('UnitsController@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('UnitsController@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('block', 'additional_land_area', 'status_id')->orderColumns('id', 'block', 'unit_type_id', 'additional_land_area', 'additional_facility')->make();
 }

Flight::route('GET /v1/main/unit', function () {
    $company = Flight::request()->query->company;
    try {
        if ($company) {
            $array = Unit::selectByCompany($company);
        } else {
            $array = Unit::selectAll();
        }
        Flight::ok($array);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('GET /v1/main/unit/@id', function ($id) {
    try {
        $object = Unit::select($id);
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('POST /v1/main/unit', function () {
    try {
        $object = Unit::insert();
        Flight::ok($object);
    } catch (Exception $exception) {
        Flight::error($exception);
    }
});
Flight::route('PUT /v1/main/unit/@id', function ($id) {
    try {

 public static function selectByCompany($id)
 {
     $connection = Flight::dbMain();
     try {
         $sql = "SELECT * FROM vehicle WHERE company_id = :company;";
         $query = $connection->prepare($sql);
         $query->bindParam(':company', $id, PDO::PARAM_INT);
         $query->execute();
         $rows = $query->fetchAll(PDO::FETCH_ASSOC);
         $result = array();
         foreach ($rows as $row) {
             $vehicle = new Vehicle();
             $vehicle->Id = (int) $row['id'];
             $vehicle->DtCreated = $row['vehicle_dt_created'];
             $vehicle->DtSubscribed = $row['vehicle_dt_subscribed'];
             $vehicle->Plate = $row['vehicle_plate'];
             $vehicle->Name = $row['vehicle_name'];
             $vehicle->Model = $row['vehicle_model'];
             $vehicle->MaInitial = (int) $row['vehicle_ma_initial'];
             $vehicle->MaLimit = (int) $row['vehicle_ma_limit'];
             $vehicle->MaMaintenance = (int) $row['vehicle_ma_maintenance'];
             $vehicle->SpeedMax = (int) $row['vehicle_speed_max'];
             $vehicle->FuelMax = (int) $row['vehicle_fuel_max'];
             // $vehicle->Status = (int)$row['e_status_id'];
             // $vehicle->Driver =  $row['driver_id'] == null ? null : (int)$row['driver_id'];
             // $vehicle->Unit = $row['unit_id'] == null ? null : (int)$row['unit_id'];
             // $vehicle->Company = (int) $row['company_id'];
             // $vehicle->TrackeeType = (int) $row['e_trackee_type_id'];
             $vehicle->Status = (int) $row['e_status_id'];
             $vehicle->Driver = Driver::select($row['driver_id']);
             $vehicle->Unit = Unit::select($row['unit_id']);
             $vehicle->Company = Company::select($row['company_id']);
             $vehicle->TrackeeType = TrackeeType::select($row['e_trackee_type_id']);
             $vehicle->Status = Status::select($row['e_status_id']);
             array_push($result, $vehicle);
         }
         return $result;
     } catch (PDOException $pdoException) {
         throw $pdoException;
     } catch (Exception $exception) {
         throw $exception;
     } finally {
         $connection = null;
     }
 }