function addTempMembers($dbc = "")
{
//global $dbConn2;
global $tempMemberRange;
/* End of range to fill with NEW MEMBER records.
* 0 means "do no fill"
*/
global $tempMemberRangeMax;
/* Placeholder custdata.LastName that will be:
* - ignored when it occurrs in the range of synced records
* - assigned to new placeholder records if filling is being done.
*/
global $tempMemberLastName;
/* custdata.memType for placeholder records.
* Must be real.
*/
global $tempMemberMemberType;
/* memContact.pref for placeholder records.
* Must be real.
*/
global $tempMemberContactPref;
$retval = null;
$errors = '';
if ($dbc == "") {
$errors = "addTempMembers() no database connection supplied.";
return $errors;
}
/* Much of what follows is lifted from $MEM/NewMemberTool.php
*/
$name = $tempMemberLastName;
/* Validate in memtypes.memtype
*/
$mtype = $tempMemberMemberType;
$memtypes = new MemtypeModel($dbc);
$memtypes->memtype($mtype);
$mtypes = $memtypes->find();
if (count($mtypes) == 0) {
$errors = "Member type {$mtype} is not known.";
return $errors;
}
/* Validate in memContactPrefs.pref_id
*/
$pref = $tempMemberContactPref;
$memprefs = new MemContactPrefsModel($dbc);
$memprefs->pref_id($pref);
$mprefs = $memprefs->find();
if (count($mprefs) == 0) {
$errors = "Contact preference {$pref} is not known.";
return $errors;
}
$mt = $dbc->tableDefinition('memtype');
$dQuery = "SELECT custdataType,discount,staff,ssi from memtype " . "WHERE memtype=?";
$defaultsQ = $dbc->prepare_statement($dQuery);
if ($dbc->tableExists('memdefaults') && (!isset($mt['custdataType']) || !isset($mt['discount']) || !isset($mt['staff']) || !isset($mt['ssi']))) {
$dQuery = "SELECT cd_type as custdataType,discount,staff,SSI as ssi " . "FROM memdefaults WHERE memtype=?";
$defaultsQ = $dbc->prepare_statement($dQuery);
}
$defaultsR = $dbc->exec_statement($defaultsQ, array($mtype));
$defaults = $dbc->fetch_row($defaultsR);
$start = $tempMemberRange + 1;
$end = $tempMemberRangeMax;
$custdata = new CustdataModel($dbc);
/* Pre-populate most custdata fields. */
$custdata->personNum(1);
$custdata->LastName($name);
$custdata->FirstName('');
$custdata->CashBack(999.99);
$custdata->Balance(0);
$custdata->memCoupons(0);
$custdata->Discount($defaults['discount']);
$custdata->Type($defaults['custdataType']);
$custdata->staff($defaults['staff']);
$custdata->SSI($defaults['ssi']);
$custdata->memType($mtype);
$meminfo = new MeminfoModel($dbc);
/* Pre-populate most meminfo fields. */
$meminfo->last_name('');
$meminfo->first_name('');
$meminfo->othlast_name('');
$meminfo->othfirst_name('');
$meminfo->street('');
$meminfo->city('');
$meminfo->state('');
$meminfo->zip('');
$meminfo->phone('');
$meminfo->email_1('');
$meminfo->email_2('');
$chkP = $dbc->prepare_statement('SELECT CardNo FROM custdata WHERE CardNo=?');
$mdP = $dbc->prepare_statement("INSERT INTO memDates VALUES (?,NULL,NULL)");
$mcP = $dbc->prepare_statement("INSERT INTO memContact (card_no,pref) VALUES (?,?)");
$membersAdded = 0;
for ($i = $start; $i <= $end; $i++) {
// skip if record already exists
$chkR = $dbc->exec_statement($chkP, array($i));
if ($dbc->num_rows($chkR) > 0) {
continue;
}
$custdata->CardNo($i);
$custdata->blueLine($i . ' ' . $name);
$custdata->save();
$meminfo->card_no($i);
$meminfo->save();
/* memDates */
$dbc->exec_statement($mdP, array($i));
/* memContact */
$dbc->exec_statement($mcP, array($i, $pref));
$membersAdded++;
}
$retval = $errors ? $errors : $membersAdded;
return $retval;
// addTempMembers()
}
