protected function get_id_fixaddress_handler()
{
global $FANNIE_OP_DB;
$susp = new SuspensionsModel(FannieDB::get($FANNIE_OP_DB));
$susp->cardno($this->id);
if (!$susp->load()) {
// not currently suspended
header('Location: PIMemberPage.php?id=' . $this->id);
return False;
} else {
if ($susp->reasoncode() == 16) {
// clear suspension for bad address
return $this->post_id_handler();
} else {
return $this->unknown_request_handler();
}
}
}
function process_file($linedata)
{
global $FANNIE_OP_DB, $FANNIE_TRANS_DB;
$EMP_NO = $this->config->get('EMP_NO');
$LANE_NO = $this->config->get('REGISTER_NO');
$OFFSET_DEPT = $this->config->get('MISC_DEPT');
$card_no = $this->get_column_index('card_no');
$classA = $this->get_column_index('classA');
$classB = $this->get_column_index('classB');
$note = $this->get_column_index('note');
$dbc = FannieDB::get($FANNIE_OP_DB);
$dtrans_table = $FANNIE_TRANS_DB . $dbc->sep() . 'dtransactions';
$prep = $dbc->prepare('SELECT MAX(trans_no) as tn FROM ' . $dtrans_table . '
WHERE emp_no=? AND register_no=?');
$result = $dbc->execute($prep, array($EMP_NO, $LANE_NO));
$trans = 1;
if ($dbc->num_rows($result) > 0) {
$row = $dbc->fetch_row($result);
if ($row['tn'] != '') {
$trans = $row['tn'] + 1;
}
}
foreach ($linedata as $data) {
if (!isset($data[$card_no])) {
continue;
} elseif (!is_numeric($data[$card_no])) {
continue;
}
$cn = trim($data[$card_no]);
$a_amt = trim($data[$classA], '$ ');
$b_amt = trim($data[$classB], '$ ');
$offset_amt = $a_amt + $b_amt;
if ($offset_amt == 0) {
continue;
}
$now = date('Y-m-d H:i:s');
$custdata = new CustdataModel($dbc);
$custdata->CardNo($cn);
$custdata->personNum(1);
$custdata->load();
$meminfo = new MeminfoModel($dbc);
$meminfo->card_no($cn);
$meminfo->load();
$susp = new SuspensionsModel($dbc);
$susp->cardno($cn);
$susp->load();
$susp->type('T');
$susp->memtype1($custdata->memType());
$susp->memtype2($custdata->Type());
$susp->suspDate($now);
$susp->discount($custdata->Discount());
$susp->chargelimit($custdata->ChargeLimit());
$susp->mailflag($meminfo->ads_OK());
$susp->reasoncode(64);
$susp->save();
$suspHistory = new SuspensionHistoryModel($dbc);
$suspHistory->username('abandon-import');
$suspHistory->postdate($now);
$suspHistory->cardno($cn);
$suspHistory->reasoncode(64);
$suspHistory->save();
$meminfo->ads_OK(0);
$meminfo->save();
$custdata->reset();
$custdata->CardNo($cn);
foreach ($custdata->find() as $obj) {
$obj->Type('TERM');
$obj->memType(0);
$obj->Discount(0);
$obj->ChargeLimit(0);
$obj->MemDiscountLimit(0);
$obj->save();
}
if (isset($data[$note]) && !empty($data[$note])) {
$memNote = new MemberNotesModel($dbc);
$memNote->cardno($cn);
$memNote->note($data[$note]);
$memNote->stamp($now);
$memNote->username('abandon-import');
$memNote->save();
}
$trans_id = 1;
if ($a_amt > 0) {
$record = DTrans::$DEFAULTS;
$record['register_no'] = $LANE_NO;
$record['emp_no'] = $EMP_NO;
$record['trans_no'] = $trans;
$record['upc'] = $a_amt . 'DP992';
$record['description'] = 'Class A Equity';
$record['trans_type'] = 'D';
$record['department'] = 992;
$record['unitPrice'] = -1 * $a_amt;
$record['total'] = -1 * $a_amt;
$record['regPrice'] = -1 * $a_amt;
$record['card_no'] = $cn;
$record['trans_id'] = $trans_id;
$trans_id++;
$info = DTrans::parameterize($record, 'datetime', $dbc->now());
$prep = $dbc->prepare("INSERT INTO {$dtrans_table} ({$info['columnString']}) VALUES ({$info['valueString']})");
$dbc->execute($prep, $info['arguments']);
}
if ($b_amt > 0) {
$record = DTrans::$DEFAULTS;
$record['register_no'] = $LANE_NO;
$record['emp_no'] = $EMP_NO;
$record['trans_no'] = $trans;
$record['upc'] = $a_amt . 'DP991';
$record['description'] = 'Class B Equity';
$record['trans_type'] = 'D';
$record['department'] = 991;
$record['unitPrice'] = -1 * $b_amt;
$record['total'] = -1 * $b_amt;
$record['regPrice'] = -1 * $b_amt;
$record['card_no'] = $cn;
$record['trans_id'] = $trans_id;
$trans_id++;
$info = DTrans::parameterize($record, 'datetime', $dbc->now());
$prep = $dbc->prepare("INSERT INTO {$dtrans_table} ({$info['columnString']}) VALUES ({$info['valueString']})");
$dbc->execute($prep, $info['arguments']);
}
$record = DTrans::$DEFAULTS;
$record['register_no'] = $LANE_NO;
$record['emp_no'] = $EMP_NO;
$record['trans_no'] = $trans;
$record['upc'] = $offset_amt . 'DP' . $OFFSET_DEPT;
$record['description'] = 'Abandon Equity';
$record['trans_type'] = 'D';
$record['department'] = $OFFSET_DEPT;
$record['unitPrice'] = $offset_amt;
$record['total'] = $offset_amt;
$record['regPrice'] = $offset_amt;
$record['card_no'] = $cn;
$record['trans_id'] = $trans_id;
$trans_id++;
$info = DTrans::parameterize($record, 'datetime', $dbc->now());
$prep = $dbc->prepare("INSERT INTO {$dtrans_table} ({$info['columnString']}) VALUES ({$info['valueString']})");
$dbc->execute($prep, $info['arguments']);
$record = DTrans::$DEFAULTS;
$record['register_no'] = $LANE_NO;
$record['emp_no'] = $EMP_NO;
$record['trans_no'] = $trans;
$record['upc'] = '0';
$record['description'] = '63350';
$record['trans_type'] = 'C';
$record['trans_subtype'] = 'CM';
$record['card_no'] = $cn;
$record['trans_id'] = $trans_id;
$info = DTrans::parameterize($record, 'datetime', $dbc->now());
$prep = $dbc->prepare("INSERT INTO {$dtrans_table} ({$info['columnString']}) VALUES ({$info['valueString']})");
$dbc->execute($prep, $info['arguments']);
$trans++;
}
return true;
}
</tr>
<tr>
<td colspan="9"><a href="mainMenu.php" target="_top" onclick="MM_nbGroup('down','group1','Members','../images/memDown.gif',1)" onmouseover="MM_nbGroup('over','Members','../images/memOver.gif','../images/memUp.gif',1)" onmouseout="MM_nbGroup('out')"><img src="../images/memDown.gif" alt="" name="Members" border="0" id="Members" onload="MM_nbGroup('init','group1','Members','../images/memUp.gif',1)" /></a><a href="javascript:;" target="_top" onclick="MM_nbGroup('down','group1','Reports','../images/repDown.gif',1)" onmouseover="MM_nbGroup('over','Reports','../images/repOver.gif','../images/repUp.gif',1)" onmouseout="MM_nbGroup('out')"><img src="../images/repUp.gif" alt="" name="Reports" width="81" height="62" border="0" id="Reports" onload="" /></a><a href="javascript:;" target="_top" onClick="MM_nbGroup('down','group1','Items','../images/itemsDown.gif',1)" onMouseOver="MM_nbGroup('over','Items','../images/itemsOver.gif','../images/itemsUp.gif',1)" onMouseOut="MM_nbGroup('out')"><img name="Items" src="../images/itemsUp.gif" border="0" alt="Items" onLoad="" /></a><a href="javascript:;" target="_top" onClick="MM_nbGroup('down','group1','Reference','../images/refDown.gif',1)" onMouseOver="MM_nbGroup('over','Reference','../images/refOver.gif','../images/refUp.gif',1)" onMouseOut="MM_nbGroup('out')"><img name="Reference" src="../images/refUp.gif" border="0" alt="Reference" onLoad="" /></a></td>
</tr>
</table>
<?php
$memNum = $memID;
if (!isset($_POST['submit']) && !isset($_GET['fixedaddress'])) {
echo " Reason for suspending membership {$memNum}<br />";
echo "<form action=alterstatus.php method=post>";
echo "<input type=hidden name=memNum value={$memID}>";
$sus = new SuspensionsModel($sql);
$sus->cardno($memNum);
$sus->load();
$curReasonCode = $sus->reasonCode();
$cust = new CustdataModel($sql);
$cust->CardNo($memNum);
$cust->personNum(1);
$cust->load();
$curType = $cust->Type();
$stats = array('INACT' => 'Inactive', 'TERM' => 'Termed', 'INACT2' => 'Term pending');
echo "<select name=status>";
foreach ($stats as $k => $v) {
echo "<option value=" . $k;
if ($k == $curType) {
echo " selected";
}
echo ">" . $v . "</option>";
}
