====== Sonstige Themen ======
===== Ärzte =====
Klaus Weinert
Facharzt für Kinder- und Jugendmedizin in Köln
Görlinger-Zentrum 5 - 7
50829 Köln
Tel +49 221 508887
Fax +49 221 80064591
Praxis Gerald S. Langner
Facharzt für Kinder- und Jugendpsychiatrie und Psychotherapie
=> Fr. Dr. Paul
Vogelsanger Str. 106-108
50823 Köln
Tel +49 221 5708330
Fax +49 221 57083366
Gemeinschaftspraxis Bocklemünd
Görlinger-Zentrum 5 - 7
50829 Köln
Tel.: +49 221 501349
^ Öffnungszeiten (Nachmittags nur mit Termin) |||
^ Montag | 08:00 – 11:00 Uhr | 15:30 – 18:00 Uhr |
^ Dienstag | 08:00 – 11:00 Uhr | 15:30 – 18:00 Uhr |
^ Mittwoch | 08:00 – 11:00 Uhr | |
^ Donnerstag | 08:00 – 11:00 Uhr | 15:30 – 18:00 Uhr |
^ Freitag | 08:00 – 11:00 Uhr | |
Hausarzt Dr. med. Alexander Lang
Grevenbroicher Str. 25
50829 Köln
Tel.: +49 221 508111
^ Öffnungszeiten |||
^ Montag | 09:30 – 12:00 Uhr | 16:00 – 18:00 Uhr |
^ Dienstag | 09:30 – 12:00 Uhr | 16:00 – 18:00 Uhr |
^ Mittwoch | 09:30 – 12:00 Uhr | |
^ Donnerstag | 09:30 – 12:00 Uhr | 16:00 – 18:00 Uhr |
^ Freitag | 09:30 – 12:00 Uhr | 16:00 – 18:00 Uhr |
===== Syntaxhighlighting =====
@media (max-width: 664px) {
.wp-block-group:not(.alignfull):not(.alignwide) > .wp-block-group__inner-container > * {
width: 302px;
}
}
==== SQL ====
SELECT mass.DisplayText Assignment, mc.CustomerId, mc.ShortName, COUNT(mc.CustomerId) Counter
FROM masCustomerAccumulation mca
INNER JOIN masCustomer mc ON mc.CustomerId = mca.Customer_Id
INNER JOIN masAccumulation macc ON macc.AccumulationId = mca.Accumulation_Id
INNER JOIN masAssignment mass ON mass.AssignmentId = macc.Assignment_Id
WHERE mass.DisplayText IN ('Food', 'Gas')
GROUP BY mass.DisplayText, mc.CustomerId, mc.ShortName
ORDER BY Assignment, Counter DESC, ShortName
==== Visual Basic ====
Case "PROSKURNIN", "CAMES", "INTERTABAK", "MACK", "SZZ", "BRUECK"
Filename = CreatingFilename(pRow("LocalFilePath").ToString, pRow("LocalFilePrefix").ToString, strTakeorderNumber, "CSV")
Dim OutputFile As CSVFile = New CSVFile(Filename)
If Organisation = "CAMES" Then
OutputFile.ExportMode = "Plain"
OutputFile.CustomerFields = {"KdNr beim Spediteur", "Name", "Bestellnummer", "Bestelldatum", "Bestellinfo", "Position", "Artikelnummer",
"Menge", "Mengeneinheit", "GTIN", "Preislistenname", "Packungen pro Karton", "Inhalt", "Preis", "Preisliste"}
OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
ElseIf Organisation = "SZZ" Then
OutputFile.ExportSZZ(pRow, strTakeorderNumber, OriginOfOrder, relation)
ElseIf Organisation = "BRUECK" Then
OutputFile.ExportMode = "Excel"
OutputFile.CustomerFields = {"Name", "Strasse", "PLZ", "Ort", "Bestellnummer", "Bestelldatum", "Bestellinfo", "Position", "Artikelnummer",
"Menge", "Mengeneinheit", "Preislistenname", "Preis", "Preisliste", "Packungen pro Karton", "Inhalt"}
OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
Else ' PROSKURNIN, MACK und INTERTABAK
OutputFile.ExportMode = "Excel"
OutputFile.Export(pRow, strTakeorderNumber, OriginOfOrder, relation)
End If
==== C# ====
if (posibleCustomerIds.Count < 1)
{
if (cust.DisplayName.Equals("TGV, Sindelfingen", StringComparison.OrdinalIgnoreCase))
{
posibleCustomerIds = await reader.CustomerIdGet(new FindCustomer("TGV Süd", "1003060", true));
}
else if (cust.DisplayName.Equals("Fütterer, St. Leon Rot", StringComparison.OrdinalIgnoreCase))
{
posibleCustomerIds = await reader.CustomerIdGet(new FindCustomer("Fütterer, Tabak", cust.CustomerNumber, true));
} ...
}
==== Python ====
class ShikakuSolver:
def __init__(self, dimension):
self.width = dimension[0]
self.height = dimension[1]
self.rows = 0
self.values = defaultdict(int)
self.grid = defaultdict(list)
self.solution = defaultdict(dict)
self.solutions = list()
self.requirements = list()
self.actions = defaultdict(list)
self.names = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
self.id = 0
def add_row(self, row):
for i, value in enumerate(row):
self.grid[self.rows].append(value)
self.requirements.append(('cell covered', self.rows, i))
if value > 0:
self.values[(self.rows, i)] = value
self.requirements.append(('value covered', self.rows, i))
self.rows += 1
if self.rows == self.height:
self.set_shapes()
def set_shapes(self):
for p in self.values.keys():
r = p[0]
c = p[1]
n = self.values[(r, c)]
i = 1
shapes = set()
while i <= n:
if n % i == 0 and i <= self.height and n // i <= self.width:
shapes.add((i, n // i))
i += 1
for shape in shapes:
h = shape[0]
w = shape[1]
self.place_shape(r, c, w, h)
def place_shape(self, rn, cn, w, h):
r0 = rn - h if rn - h > 0 else 0
c0 = cn - w if cn - w > 0 else 0
for r in range(r0, rn + 1):
for c in range(c0, cn + 1):
cells = self.check_rectangle(r, c, w, h, rn, cn)
if r + h <= self.height and c + w <= self.width and cells != None:
self.actions[('set rectangle', r, c, w, h)] = [('value covered', rn, cn), *cells]
def check_rectangle(self, r0, c0, w, h, rn, cn):
value_included = False
cells = list()
for r in range(r0, r0 + h):
for c in range(c0, c0 + w):
cells.append(('cell covered', r, c))
if r == rn and c == cn:
value_included = True
elif (r, c) in self.values.keys():
return None
if value_included:
return cells
return None
def get_solutions(self):
solver = AlgorithmXSolver(self.requirements, self.actions)
for solution in solver.solve():
self.solution.clear()
self.id = 0
for i, action in enumerate(sorted(solution)):
self.set_rectangle(action)
self.id += 1
self.solutions.append(self.solution)
#break
print(solver.solution_count)
return self.solutions
def set_rectangle(self, action):
_, row, col, width, height = action
value = self.names[self.id]
#print(self.names[i], row, col, width, height)
for r in range(row, row + height):
for c in range(col, col + width):
#print("({}|{})={}".format(r, c, value))
self.solution[r][c] = value
def print_grid(self):
output = "--" * self.width + "-"
for r in range(self.height):
output += "\n"
for c in range(self.width):
output += "{:2d}".format(self.grid[r][c])
print(output)
print("--" * self.width + "-")
# Test the first simple grids:
for riddle in riddles:
solver = ShikakuSolver(riddle[0])
for i in range(riddle[0][1]):
solver.add_row(riddle[i + 1])
solver.print_grid()
#print(solver.actions)
solutions = solver.get_solutions().sort()
solution = solutions[0]
for r in range(riddle[0][1]):
row = ""
for c in range(riddle[0][0]):
row += solution[r][c]
print(row)
==== XML ====
0000304362
20201211
4032800000009
4399901095458
Schuller, Margot
Lädle Tee & Geschenke
Flamingoweg 1
Stuttgart
70378
10109
0000802831
ä=ae; Ä=Ae, ö=oe; Ö=Oe; ü=ue; Ü=Ue; ß=sz
1
4032800066821
PR_42150
WINSTON RED LONGS BP XXL
WINSTON RED LONGS BP XXL
8
29
8.0000
Z079E
1
CAR
2
4032800054736
PR_42135
WINSTON VOLUME RED GIANT BOX
WINSTON VOLUME RED GIANT BOX
1
280
49.9500
F037E
1
PAC
==== SMTP ====
To: "G=MG1;S=MGATE;CN=MG1 MGATE;O=TESTAG;P=MGATE;A=VIAT;C=DE" <49603@viaT.de>
From: "G=ipm;S=tester;O=testag;A=viaT;C=de" <49637@viaT.de>
Message-ID: 614 07/11/13
X-MPDUID: 8B0663A011DCEC4417009682
Date: 13 Nov 2010 13:10:22 +0100
Subject: Test mit 3 Bodyparts
Disposition-Notification-To: "G=ipm;S=tester;O=testag;A=viaT;C=de"
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="MG_=_CA610D0211DC91E900007CAD_=_MG"
--MG_=_CA610D0211DC91E900007CAD_=_MG
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
Test äöüÄÖÜß
--MG_=_CA610D0211DC91E900007CAD_=_MG
Content-Type: application/octet-stream
Content-Disposition: attachment; filename="4d654d1d.zip