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;
}
}
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/simvendor/@id', function ($id) {
try {
$object = SimVendor::update($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('DELETE /v1/main/simvendor/@id', function ($id) {
try {
$object = SimVendor::delete($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
//=============================================================================
//Status
//=============================================================================
Flight::route('GET /v1/main/status', function () {
try {
$array = Status::selectAll();
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
