PHP dso_insupdmembership Examples

Example #1

File: Membership.php Project: robmat/samplebator

        $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;
}

Example #2

File: egate.php Project: robmat/samplebator

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();
}