PHP database2::sumPartial_new Exemples

Exemple #1

Fichier : summaryEditable.php Projet : rickyx12/protacio

    echo "</tr>";
}
$grandTotalz = $gross - $ro->getRegistrationDetails_discount() + $pf_cash;
$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo);
$netTotal = $gross - $ro->getRegistrationDetails_discount() - $ro->getPaymentHistory_showUp_returnPaid() - $ro->sumPartial($registrationNo);
if ($netTotal < 0) {
    $netTotal = 0;
}
//echo "<Tr>";
//echo "<td>&nbsp;<b>Payment's</b></tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->getPaymentHistory_showUp_returnPaid() ,2)."</b>&nbsp;</tD>";
//echo "</tr>";
$paidz1 = $ro->sumPartial_new($registrationNo, "amountPaid") + $ro->sumPartial_new($registrationNo, "pf") + $ro->sumPartial_new($registrationNo, "admitting");
echo "<Tr>";
echo "<td>&nbsp;<font size=2><b>" . $ro->descPartialPayment($registrationNo) . "</b></font></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;<b>" . number_format($ro->sumPartial_new($registrationNo), 2) . "</b>&nbsp;</tD>";
echo "</tr>";
//$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo);
//$netTotal = (  ($gross - $disc) - $ro->getPaymentHistory_showUp_returnPaid() );
//if( $netTotal < 0 ) $netTotal=0;
if ($ro->checkIfPackageExist($registrationNo) > 0) {
    echo "<Tr>";
    echo "<td>&nbsp;<font color=red>Balance</font></tD>";
    echo "<td>&nbsp;</tD>";
    echo "<td>&nbsp;</tD>";

Exemple #2

Fichier : summaryCompany.php Projet : rickyx12/mendero

echo "</tr>";
$refund = $ro->doubleSelectNow("patientPayment", "amountPaid", "registrationNo", $registrationNo, "paymentFor", "REFUND");
echo "<tr>";
echo "<Td>&nbsp;<b>REFUND</b></td>";
echo "<TD></tD>";
echo "<td></td>";
echo "<td></td>";
echo "<TD>" . number_format($refund, 2) . "</tD>";
echo "</tr>";
$totalCompanyPayment = $ro->getCompanyPayment_total + $ro->getCompanyPayment_discount + $ro->getCompanyPayment_tax();
echo "<Tr>";
echo "<td>&nbsp;<b>Balance</b></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;<b>" . number_format($grandTotalPHIC - $ro->getPHICPayment_total(), 2) . "</b></tD>";
echo "<td>&nbsp;<b>" . number_format($grandTotalCompany1 - $totalCompanyPayment, 2) . "</b></tD>";
$paidz = $ro->sumPartial_new($registrationNo, "amountPaid");
//$remainBalance = ( $grandTotalz - $ro->sumPartial_new($registrationNo) );
$remainBalance = $grandTotalz - $ro->descPartialPayment_total();
if ($remainBalance > 0) {
    echo "<td>&nbsp;<b>" . number_format($remainBalance, 2) . "</b>&nbsp;</tD>";
} else {
    echo "<td>&nbsp;<b>" . number_format($remainBalance + $refund, 2) . "</b>&nbsp;</tD>";
}
echo "</tr>";
echo "</table>";
echo "<br>";
//echo "<font size=2>Payment's</font>";
//$ro->getPaymentHistory_showUp($registrationNo);
$logusername = $ro->selectNow("registeredUser", "completeName", "username", $username);
echo "<br>\n<Table border=0>\n<td>\n__________________________<br><font size=2>Signature over Printed Name</font><br><font size=3>Relationship to Patient:___________________________</font></font>\n</tD>\n<tD width='40%'>&nbsp;</tD>\n\n\n</table>\n<Br>\n<Table width='100%'>\n<tD>\n<font size=2><u>" . strtoupper($logusername) . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</u><Br><b>Billing Section</b></font>\n</tD>\n\n\n<tD>\n\n\n<font size=2><u>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</u><Br><b>Cashier</b></font>\n</tD>\n</table>\n<Br>\n\n\n\n<font size=2>" . date("M_d_Y") . "@" . date("H:i:s") . "</font>\n\n<br>";
$ro->coconutBoxStop();

Exemple #3

Fichier : summary-apr26.php Projet : rickyx12/protacio

    echo "</tr>";
}
$grandTotalz = $gross - $ro->getRegistrationDetails_discount() + $pf_cash;
$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo);
$netTotal = $gross - $ro->getRegistrationDetails_discount() - $ro->getPaymentHistory_showUp_returnPaid() - $ro->sumPartial($registrationNo);
if ($netTotal < 0) {
    $netTotal = 0;
}
//echo "<Tr>";
//echo "<td>&nbsp;<b>Payment's</b></tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->getPaymentHistory_showUp_returnPaid() ,2)."</b>&nbsp;</tD>";
//echo "</tr>";
$paidz1 = $ro->sumPartial_new($registrationNo, "amountPaid") + $ro->sumPartial_new($registrationNo, "pf") + $ro->sumPartial_new($registrationNo, "admitting");
echo "<Tr>";
echo "<td>&nbsp;<font size=2><b>" . $ro->descPartialPayment($registrationNo) . "</b></font></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->sumPartial_new($registrationNo) ,2)."</b>&nbsp;</tD>";
echo "</tr>";
//$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo);
//$netTotal = (  ($gross - $disc) - $ro->getPaymentHistory_showUp_returnPaid() );
//if( $netTotal < 0 ) $netTotal=0;
if ($ro->checkIfPackageExist($registrationNo) > 0) {
    echo "<Tr>";
    echo "<td>&nbsp;<font color=red>Balance</font></tD>";
    echo "<td>&nbsp;</tD>";
    echo "<td>&nbsp;</tD>";