$aTH = array('Verein', 'Meldeart', 'PassNr', 'Meldung Ende', 'ID', 'Vorname', 'Nachname', 'Aktion'); $ROWS = RecordsetToDataTable($RS, array(2, 3, 4, 5, 6, 7, 8), array('playeredit', 'memberdel'), array(array(6), array(0, 6)), array('Edit Player', 'Del')); } $HEAD = ArrayToTableHead($aTH); $sum = '<div>Search criteria returned ' . sizeof($RS) . ' records.</div>'; return $sum . '<table class="tchild" id="tmembers" name="tmembers">' . $HEAD . $ROWS . '</table>'; } function _listPlayerActiveMemberShip($player_id) { return LSTable_PlayerActiveMemberShips('tmember', $player_id); } header('Content-Type: application/html; charset=ISO-8859-1'); switch ($myAction) { default: break; case 'delete': echo dso_deletemembership($membership_id); break; case 'edit': echo _showform_membership($membership_id, $player_id); break; case 'save': echo dso_insupdmembership($membership_id, $player_id, $verein_id, $mtype_id, $v_passnr, $v_mstart, $v_mend); break; case 'list': echo _listMemberShip($player_id, $verein_id, $mtype_id, $verband_ID, $m_active); break; case 'listp': echo _listPlayerActiveMemberShip($player_id); break; }
function _uploadMembership($file, $membertype_id) { # # // add a payment record to this player ... depending on OEDV / OEDSO # // passnr;start;end;firstname;lastname;vereinID => $membertype_id # // $fp = fopen($file, "r"); while ($lineIn = fgetcsv($fp, 1000, ";")) { if (sizeof($lineIn) < 6) { die_red('Error517:DataSetSize:' . debug($lineIn)); } if (strlen($lineIn[5]) < 5) { die_red('Err518:NoValidVereinsZVR:' . debug($lineIn)); } if (strlen($lineIn[1]) < 8) { die_red('Err519:MalformedStartDate:' . debug($lineIn)); } if (strlen($lineIn[2]) < 8) { die_red('Err519:MalformedEndDate:' . debug($lineIn)); } $RS[] = $lineIn; } fclose($fp); foreach ($RS as $R) { // check if player exist -> msg // check if verein exist -> msg // action .... -> msg $PID = dso_checkPlayerByPassNr($R[0]); if ($PID > 0) { $aMSG[] = '<font color=green>Identified Player ' . $R[3] . ' ' . $R[4] . ' as unique ID:' . $PID . '</font>'; $VID = dso_verifyVereinZVR($R[5]); if ($VID > 0) { $aMSG[] = '<font color=green>Player OK, Verein OK -- adding Membership</font>'; $aMSG[] = dso_insupdmembership(0, $PID, $VID, $membertype_id, $R[0], $R[1], $R[2]); } else { $aMSG[] = '<font color=red>Verein with ID ' . $R[5] . ' not found or no rights to register players for this Verein</font>'; $aMSG[] = '<font color=red>REJECTED LINE:' . $R[0] . ';' . $R[1] . ';' . $R[2] . ';' . $R[3] . ';' . $R[4] . ';' . $R[5] . ';</font>'; } } else { $aMSG[] = '<font color=red>Player ' . $R[3] . ' ' . $R[4] . ' can not be identified, no membership added</font>'; $aMSG[] = '<font color=red>REJECTED LINE:' . $R[0] . ';' . $R[1] . ';' . $R[2] . ';' . $R[3] . ';' . $R[4] . ';' . $R[5] . ';</font>'; } } // == OUTPUT == // // ============ // echo setPageTitle('Log Output from Bulk IMPORT (Records:' . sizeof($RS) . ') for Type=' . $membertype_id); echo '<p>The loader is doing some minimum checks on the expected fieldvalues - rejected entries are shown in <font color="red">red</font>.</p>'; OpenTable('output'); foreach ($aMSG as $MSG) { echo '<tr><td>' . $MSG . '</td></tr>'; } CloseTable(); }