function getNewNum($control_type, $plus = false)
{
$sql = "SELECT * FROM v_controlno WHERE control_type = '{$control_type}'";
$qry = mysql_query($sql);
$row = mysql_fetch_array($qry);
$digit = $row['digit'];
$control_code = $row['control_code'];
if ($plus == false) {
$lastseqno = $row['lastseqno'] + 1;
} else {
$lastseqno = $row['lastseqno'] + $plus;
}
$newnum = formatNum($lastseqno, $digit);
return $control_code . $newnum;
}
<td class="text-right"><?php
echo formatNum(get_count_twitter_klout());
?>
</td>
<td class="text-right"><?php
echo formatNum(get_count_twitter_klout_score());
?>
</td>
<td class="text-right"><?php
echo formatNum(get_count_twitter_klout() - get_count_twitter_klout_score());
?>
</td>
</tr>
<tr>
<td><a href="http://owloo.com/wservice/instagram/call.php?type=profile" target="_blank">Instagram Profiles</a></td>
<td class="text-right"><?php
echo formatNum(get_count_instagram_profiles());
?>
</td>
<td class="text-right"><?php
echo formatNum(get_count_instagram_profiles_followers());
?>
</td>
<td class="text-right"><?php
echo formatNum(get_count_instagram_profiles() - get_count_instagram_profiles_followers());
?>
</td>
</tr>
</table>
</body>
</html>
<td class="text-right"><?php
echo formatNum($total_city * 5);
?>
</td>
<td class="text-right"><? $aux = get_total_record('city_comportamiento'); echo formatNum($aux); ?></td>
<td class="<?php
echo $total_city * 5 == $aux ? 'ok' : 'alert';
?>
"><?php
echo $total_city * 5 == $aux ? 'ok' : '<a target="_blank" href="http://www.owloo.com/wservice/city_3_1/record_aux.php?type=city_comportamiento">alert</a>';
?>
</td>
</tr>
<tr>
<td>Intereses</td>
<td class="text-right"><?php
echo formatNum($total_city * 5);
?>
</td>
<td class="text-right"><? $aux = get_total_record('city_interest'); echo formatNum($aux); ?></td>
<td class="<?php
echo $total_city * 5 == $aux ? 'ok' : 'alert';
?>
"><?php
echo $total_city * 5 == $aux ? 'ok' : '<a target="_blank" href="http://www.owloo.com/wservice/city_3_1/record_aux.php?type=city_interest">alert</a>';
?>
</td>
</tr>
</table>
</body>
</html>
$salesamount = "--";
$Tpurchaseunits = $Tpurchaseunits + $unitspurchased;
$purchasetotals = $purchasetotals + $purchasecost;
} elseif ($transtype == "WITHDRAWAL") {
$unitspurchased = "--";
$purchaseprice = "--";
$purchasecost = "--";
$unitssold = abs($trans->NOOFSHARES);
$saleprice = $trans->NAV;
$salesamount = abs($trans->AMOUNT);
$Tsoldunits = $Tsoldunits + $unitssold;
$salestotals = $salestotals + $salesamount;
}
$balance_units = $Tpurchaseunits - $Tsoldunits;
echo "<td align=left valign=top class=tab>" . $trans_id . "</td><td align=left valign=top class=tab>" . $trans_date . "</td><td align=left valign=top class=tab>" . formatNum($unitspurchased) . "</td><td align=left valign=top class=tab>" . formatMoney($purchaseprice, true) . "</td><td align=left valign=top class=tab align=right>" . formatMoney($purchasecost, true) . "</td>";
echo "<td align=left valign=top class=tab>" . formatNum($unitssold) . "</td><td align=left valign=top class=tab align=right>" . formatMoney($saleprice, true) . "</td><td align=left valign=top class=tab align=right>" . formatMoney($salesamount, true) . "</td><td align=left valign=top class=tab>" . formatNum($balance_units) . "</td><td align=left valign=top class=tab align=right>" . formatMoney($purchaseprice, true) . "</td>";
echo "</tr>";
}
//END OF WHILE LOOP
$market_value = $balance_units * $nav_amount;
?>
<tr valign="TOP" onMouseOver="bgColor='WhiteSmoke'" onMouseOut="bgColor='White'"
bgcolor="White">
<td align="center" valign="top" class="form_header">Summation</td>
<td align="left" valign="top" class="form_header"></td>
<td align="left" valign="top"
class="form_header"><?php
echo formatMoney($Tpurchaseunits, true);
?>
</td>
<td align="left" valign="top" class="form_header"> </td>
/**
* Modifica el numero al formato Sin Decimales y con Separador de Miles
*
* Type: modifier<br>
* Name: num<br>
* Purpose:
*/
function smarty_modifier_num($numero)
{
return formatNum($numero);
}
$purchaseprice = $trans['PRICE'];
$purchasecost = "";
$unitssold = abs($trans['NOOFSHARES']);
$saleprice = $trans['NAV'];
$salesamount = abs($trans['AMOUNT']);
$Tsoldunits = $Tsoldunits + $unitssold;
$salestotals = $salestotals + $salesamount;
}
$balance_units = $Tpurchaseunits - $Tsoldunits;
$statement->SetFont('Times', '', '10');
$statement->setTextColor(05, 05, 05);
$statement->Cell(15, 8, $trans_id, 1);
//outputting the selected data
$statement->Cell(20, 8, $trans_date, 1);
$statement->Cell(25, 8, formatNum($unitspurchased), 1, 0, "C");
$statement->Cell(20, 8, formatMoney($purchaseprice, true), 1, 0, "R");
$statement->Cell(35, 8, formatMoney($purchasecost, true), 1, 0, "R");
$statement->Cell(25, 8, formatNum($unitssold), 1, 0, "C");
$statement->Cell(25, 8, formatMoney($saleprice, true), 1, 0, "R");
$statement->Cell(25, 8, formatMoney($salesamount, true), 1);
$statement->Cell(30, 8, formatNum($balance_units), 1, 0, "C");
$statement->Cell(30, 8, formatMoney($nav_amount, true), 1);
$y += 8;
//Defining my page break
if ($y > 170) {
$statement->AddPage("L", "A4");
$y = 40;
}
$statement->setXY($x, $y);
}
} else {
//APPLICATION
$values = array($application->shareBalance, $application->loanBalance, $application->addOn, $application->newBalance, $application->accountNumber, date("Y-m-d"), $application->security, $application->securityOther, $applicant_id, $application->coMakersName, $loan_id);
$application_query = "INSERT INTO applications (share_balance, loan_balance, add_on, new_balance, account_number, date, security, security_other, applicant_id, comakers_names, loan_id) VALUES " . format_values($values);
if ($mysqli->query($application_query)) {
echo '<p>application success</p>';
echo '<p>Application: ' . $application_query . '</p>';
}
//SEND EMAIL
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: FSCU Application Form <*****@*****.**>' . "\r\n";
$headers .= 'Bcc: webmaster@artisticdigital.com' . "\r\n";
//admin
$to = '*****@*****.**';
$subject = 'A new application has been submitted at FSCU';
$message = '<p>' . $applicant->name . ' has submitted an application for a loan of $' . formatNum($loan->amount) . ', with monthly payments of $' . $loan->payment->amount . ' ' . $loan->payment->interest . '.</p>';
$message .= '<p><a href="https://firstsecurity-creditunion.com/application/admin/">View all of the loan details</a></p>';
$message .= '<p>Applicant Phone: ' . formatPhone($applicant->phone) . '</p>';
$message .= '<p>Applicant Cell Phone: ' . formatPhone($applicant->cellPhone) . '</p>';
$message .= '<p>Applicant Email: <a href="mailto:' . $applicant->email . '">' . $applicant->email . '</a></p>';
mail($to, $subject, $message, $headers);
function format_values($values)
{
global $mysqli;
$i = 0;
$return = "(";
foreach ($values as $val) {
if ($i > 0) {
$return .= ", ";
}
if (is_null($val) || $val == '' || $val === 0) {
