implementing PDO on api offer module