public function get_id_view() { global $FANNIE_URL; $ret = ''; $ret .= '<input onclick="location=\'GumEquityPayoffPage.php?id=' . $this->id . '&pdf=1\'; return false;" type="button" value="Print" />'; $ret .= ' '; $ret .= sprintf('<label for="issueCheckbox">Check has been issued</label> <input type="checkbox" onclick="return issueWarning();" onchange="issueCheck(\'%s\');" id="issueCheckbox" %s /> <span id="issueDate">%s</span>', $this->id, $this->check_info->checkIssued() ? 'checked disabled' : '', $this->check_info->checkIssued() ? $this->check_info->issueDate() : ''); $this->add_script('js/equity_payoff.js'); if (file_exists('img/letterhead.png')) { $ret .= '<img src="img/letterhead.png" style="width: 100%;" />'; } $ret .= '<p> Based on the terms of Wholefoods Community Coop Class C Stock you Payout Request has been received and approved by our Board of Directors. Please find attached a schedule of your most recent Class C activity as well as a check for the class C payout. Thankyou for your continued support. </p>'; $ret .= '<table id="infoTable" cellspacing="0" cellpadding="4">'; $ret .= '<tr><td colspan="3">Class C Schedule</td></tr>'; $ret .= '<tr><td>Date</td><td>Shares</td><td>Total</td></tr>'; foreach ($this->all->find('tdate') as $obj) { $ret .= sprintf('<tr class="%s"> <td>%s</td> <td>%d</td> <td>%s</td> </tr>', $obj->shares() < 0 ? 'red' : '', date('m/d/Y', strtotime($obj->tdate())), $obj->shares(), number_format($obj->value(), 2)); if ($obj->gumEquityShareID() == $this->id) { break; } } $ret .= '</table>'; $ret .= '<hr />'; $check = new GumCheckTemplate($this->custdata, $this->meminfo, $this->payoff->value() * -1, 'Class C Payout', $this->check_info->checkNumber()); $ret .= $check->renderAsHTML(); return $ret; }
public function get_id_view() { global $FANNIE_URL; $ret = ''; $ret .= '<input onclick="location=\'GumLoanPayoffPage.php?id=' . $this->id . '&pdf=1\'; return false;" type="button" value="Print" />'; $ret .= ' '; $ret .= sprintf('<label for="issueCheckbox">Check has been issued</label> <input type="checkbox" onclick="return issueWarning();" onchange="issueCheck(\'%s\');" id="issueCheckbox" %s /> <span id="issueDate">%s</span>', $this->id, $this->check_info->checkIssued() ? 'checked disabled' : '', $this->check_info->checkIssued() ? $this->check_info->issueDate() : ''); $this->add_script('js/loan_payoff.js'); if (file_exists('img/letterhead.png')) { $ret .= '<img src="img/letterhead.png" style="width: 100%;" />'; } $ret .= '<p>Pursuant to the terms of your Promissory Note with WFC, below please find a check for the principal and, as applicable, compound interest due. A statement showing the terms of your loan and annual compounding of the interest thereon is provided. If your loan was for more than 0.00% interest, also below is an IRS form 1099-INT to be included with your ' . date('Y') . ' federal tax filing. If you have questions regarding this payment, please contact Financial Manager Dale Maiers (dmaiers@wholefoods.coop). Thank you very much for your support.</p>'; $ret .= '<div>'; $ret .= '<table style="border: solid 1px black; border-collapse: collapse; width: 20%; float:left;">'; $ret .= '<tr><td style="text-align:center; border: solid 1px black;"><b>Loan Amount</b><br />'; $ret .= number_format($this->loan->principal(), 2); $ret .= '</td></tr>'; $ret .= '<tr><td style="text-align:center; border: solid 1px black;"><b>Term</b><br />'; $ret .= $this->loan->termInMonths() / 12 . ' Years'; $ret .= '</td></tr>'; $ret .= '<tr><td style="text-align:center; border: solid 1px black;"><b>Loan Date</b><br />'; $ret .= date('m/d/Y', strtotime($this->loan->loanDate())); $ret .= '</td></tr>'; $ret .= '<tr><td style="text-align:center; border: solid 1px black;"><b>Interest Rate</b><br />'; $ret .= $this->loan->interestRate() * 100 . '%'; $ret .= '</td></tr>'; $ld = strtotime($this->loan->loanDate()); $ed = mktime(0, 0, 0, date('n', $ld) + $this->loan->termInMonths(), date('j', $ld), date('Y', $ld)); $ret .= '<tr><td style="text-align:center; border: solid 1px black;"><b>Maturity Date</b><br />'; $ret .= date('m/d/Y', $ed); $ret .= '</td></tr>'; $ret .= '</table>'; $loan_info = GumLib::loanSchedule($this->loan); $ret .= '<table style="width: 75%; float: left;">'; $ret .= '<tr> <td style="font-weight: bold; text-decoration: underline; text-align:center;">Ending Period</td> <td style="font-weight: bold; text-decoration: underline; text-align:center;">Days</td> <td style="font-weight: bold; text-decoration: underline; text-align:right;">Interest</td> <td style="font-weight: bold; text-decoration: underline; text-align:right;">Closing Balance</td> </tr>'; foreach ($loan_info['schedule'] as $year) { $ret .= sprintf('<tr> <td style="text-align:center;">%s</td> <td style="text-align:center;">%s</td> <td style="text-align:right;">%s</td> <td style="text-align:right;">%s</td> </tr>', $year['end_date'], $year['days'], number_format($year['interest'], 2), number_format($year['balance'], 2)); } $ret .= sprintf('<tr> <td style="text-align:right;">Total</td> <td style="text-align:right;">%s</td> <td style="text-align:right;">%s</td> <td style="text-align:right;">%s</td> </tr>', number_format($this->loan->principal(), 2), number_format($loan_info['total_interest'], 2), number_format($loan_info['balance'], 2)); $ret .= '</table>'; $ret .= '</div>'; $ret .= '<div style="clear: left;"></div>'; $ret .= '<hr />'; $fields = array(1 => $loan_info['balance']); $this->settings->key('storeStateID'); if ($this->settings->load()) { $fields[12] = $this->settings->value(); } $this->settings->key('storeState'); if ($this->settings->load()) { $fields[11] = $this->settings->value(); } $ssn = 'Unknown'; if ($this->taxid->load()) { $ssn = 'xxx-xx-' . $this->taxid->maskedTaxIdentifier(); } $form = new GumTaxFormTemplate($this->custdata, $this->meminfo, $ssn, date('Y'), $fields, $this->loan->accountNumber()); $ret .= $form->renderAsHTML(); $ret .= '<hr />'; $check = new GumCheckTemplate($this->custdata, $this->meminfo, $loan_info['balance'], 'Loan Repayment', $this->check_info->checkNumber()); $ret .= $check->renderAsHTML(); return $ret; }
function post_printFY_handler() { global $FANNIE_PLUGIN_SETTINGS, $FANNIE_OP_DB, $FANNIE_ROOT; $dbc = FannieDB::get($FANNIE_PLUGIN_SETTINGS['GiveUsMoneyDB']); if (!class_exists('FPDF')) { include $FANNIE_ROOT . 'src/fpdf/fpdf.php'; define('FPDF_FONTPATH', 'font/'); } $pdf = new FPDF('P', 'mm', 'Letter'); $pdf->SetMargins(6.35, 6.35, 6.35); // quarter-inch margins $pdf->SetAutoPageBreak(false); $key = FormLib::get('key'); $privkey = false; if ($key) { $privkey = openssl_pkey_get_private($key); } $map = new GumDividendPayoffMapModel($dbc); $bridge = GumLib::getSetting('posLayer'); $dividends = new GumDividendsModel($dbc); $dividends->yearEndDate($this->printFY); $acc = array(); $prevCN = -1; $combined = array(); foreach ($dividends->find('card_no') as $dividend) { if (!isset($combined[$dividend->card_no()])) { $combined[$dividend->card_no()] = array(); } $combined[$dividend->card_no()][] = $dividend; } foreach ($combined as $card_no => $acc) { if (!empty($acc)) { $ttl = 0.0; // roll up totals to a single amount foreach ($acc as $a) { $ttl += $a->dividendAmount(); } // lookup check $map->reset(); $map->gumDividendID($acc[0]->gumDividendID()); $checkID = false; foreach ($map->find('gumPayoffID', true) as $obj) { $checkID = $obj->gumPayoffID(); break; } if ($checkID) { $check = new GumPayoffsModel($dbc); $check->gumPayoffID($checkID); $check->load(); } else { // allocate a new check if needed $checkID = GumLib::allocateCheck($map); $check = new GumPayoffsModel($dbc); $check->gumPayoffID($checkID); $check->load(); $check->amount($ttl); $check->save(); // map rolled up dividends to same check foreach ($acc as $a) { $map->gumDividendID($a->gumDividendID()); $map->gumPayoffID($checkID); $map->save(); } } $pdf->AddPage(); $custdata = $bridge::getCustdata($card_no); $meminfo = $bridge::getMeminfo($card_no); // bridge may change selected database $dbc = FannieDB::get($FANNIE_PLUGIN_SETTINGS['GiveUsMoneyDB']); $this->taxid = new GumTaxIdentifiersModel($dbc); $this->taxid->card_no($custdata->CardNo()); $ssn = 'Unknown'; if ($this->taxid->load()) { $ssn = 'xxx-xx-' . $this->taxid->maskedTaxIdentifier(); if ($privkey) { $try = openssl_private_decrypt($this->taxid->encryptedTaxIdentifier(), $decrypted, $privkey); if ($try) { $ssn = $decrypted; } } } $form = new GumTaxDividendFormTemplate($custdata, $meminfo, $ssn, date('Y'), array(1 => sprintf('%.2f', $ttl))); $ret .= $form->renderAsPDF($pdf, 105); $template = new GumCheckTemplate($custdata, $meminfo, $ttl, 'Dividend Payment', $check->checkNumber()); $template->renderAsPDF($pdf); $check->checkIssued(1); $check->issueDate(date('Y-m-d H:i:s')); $check->save(); $pdf->Image('img/new_letterhead.png', 10, 10, 35); if (!isset($pdf->fonts['gillsansmtpro-book'])) { $pdf->AddFont('GillSansMTPro-Book', '', 'GillSansMTPro-Book.php'); } $pdf->SetFont('GillSansMTPro-Book', '', 11); $l = 55; $pdf->SetXY($l, 20); $pdf->Cell(0, 5, date('j F Y'), 0, 1); $pdf->Ln(5); $pdf->SetX($l); $pdf->Cell(0, 5, 'Dear Owner:', 0, 1); $pdf->Ln(2); $pdf->SetX($l); $pdf->MultiCell(135, 5, 'Based on the Co-op\'s profitability in Fiscal Year 2015 (July 1, 2014-June 30, 2015), the Board of Directors approved a four percent (4%) dividend on your Class C equity investment. Your dividend is pro-rated based on when you made your investment during that fiscal year. As this check represents an annual return on your investment, the amount cannot be compounded.'); $pdf->Ln(2); $pdf->SetX($l); $pdf->MultiCell(135, 5, 'You are welcome to cash your check toward a purchase at the Co-op. Thank you for investing in Whole Foods Co-op'); $pdf->Ln(4); $pdf->SetX($l); $pdf->Cell(0, 5, 'Thank you,', 0, 1); $pdf->Ln(4); $pdf->SetX($l); $pdf->Cell(0, 5, 'Sharon Murphy', 0, 1); $pdf->Ln(2); $pdf->SetX($l); $pdf->Cell(0, 5, 'General Manager', 0, 1); } } $pdf->Output('Dividends.pdf', 'I'); return false; }
public function post_handler() { global $FANNIE_OP_DB; $dbc = FannieDB::get($FANNIE_OP_DB); $fy = FormLib::get('fy'); $per_page = FormLib::get('per_page'); $custdata = new CustdataModel($dbc); $meminfo = new MeminfoModel($dbc); $query = $dbc->prepare(' SELECT p.cardno, p.cash_pat, m.zip, p.check_number FROM patronage AS p INNER JOIN meminfo AS m ON p.cardno=m.card_no INNER JOIN custdata AS c ON p.cardno=c.CardNo AND c.personNum=1 WHERE p.FY=? ORDER BY m.zip, c.LastName, c.FirstName'); $result = $dbc->execute($query, array($fy)); $pdf = new FPDF('P', 'mm', 'Letter'); $pdf->SetMargins(6.35, 6.35, 6.35); // quarter-inch margins $pdf->SetAutoPageBreak(false); $filename = ''; $this->files = array(); $filenumber = 1; set_time_limit(0); while ($w = $dbc->fetch_row($result)) { if (empty($filename)) { $filename = $filenumber . '-' . substr($w['zip'], 0, 5); } $dbc = FannieDB::get($FANNIE_OP_DB); $custdata->CardNo($w['cardno']); $custdata->personNum(1); $custdata->load(); $meminfo->card_no($w['cardno']); $meminfo->load(); if ($w['check_number'] == '') { $patronage = new PatronageModel($dbc); $patronage->cardno($w['cardno']); $patronage->FY($fy); $number = GumLib::allocateCheck($patronage, false); $dbc = FannieDB::get($FANNIE_OP_DB); $patronage->check_number($number); $patronage->save(); $w['check_number'] = $number; } $pdf->AddPage(); $pdf->Image('rebate_body.png', 10, 0, 190); $check = new GumCheckTemplate($custdata, $meminfo, $w['cash_pat'], 'Rebate ' . $fy, $w['check_number']); $check->renderAsPDF($pdf); if ($pdf->PageNo() == $per_page) { $filename .= '-' . substr($w['zip'], 0, 5) . '.pdf'; $filenumber++; $pdf->Output('/tmp/' . $filename, 'F'); $this->files[] = $filename; $filename = ''; $pdf = new FPDF('P', 'mm', 'Letter'); $pdf->SetMargins(6.35, 6.35, 6.35); // quarter-inch margins $pdf->SetAutoPageBreak(false); } } $filename .= '-End.pdf'; $pdf->Output('/tmp/' . $filename, 'F'); $this->files[] = $filename; return true; }