public static function selectByCompany($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM sim 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) { $sim = new Sim(); $sim->Id = (int) $row['id']; $sim->Imei = $row['sim_imei']; $sim->Number = $row['sim_number']; $sim->Roaming = (bool) $row['sim_roaming']; $sim->SimVendor = SimVendor::select($row['e_sim_vendor_id']); $sim->DtCreated = $row['sim_dt_created']; $sim->Status = Status::select($row['e_status_id']); $sim->Company = Company::select($row['company_id']); array_push($result, $sim); } return $result; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
} }); //============================================================================= //SimVendor //============================================================================= Flight::route('GET /v1/main/simvendor', function () { try { $array = SimVendor::selectAll(); Flight::ok($array); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('GET /v1/main/simvendor/@id', function ($id) { try { $object = SimVendor::select($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('POST /v1/main/simvendor', function () { try { $object = SimVendor::insert(); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); Flight::route('PUT /v1/main/simvendor/@id', function ($id) { try {