MemCheck.prg

<?php

$dms_ok=array('check_number'=>'digits','check_amount'=>'string',
'rt'=>'digits','check_date'=>'string','check_micr'=>'digits','mode'=>'string');
dms_import_v2($SYSENV, "MEM", $dms_ok);
extract($SYSENV["MEM"]);

    // Always perform the check to see if check images are available for this credit union
    $sql = "SELECT img, flagset
                    FROM cuadmin
                    WHERE cu = '$Cu' ";

    $img_rs = db_query($sql, $dbh);

    list($img_vendor, $flagset) = db_fetch_row($img_rs, 0);
    $img_vendor = trim($img_vendor);
    db_free_result($img_rs);

    if ((trim($img_vendor) == '' || strtoupper(trim($img_vendor)) == 'NO') || (($flagset & $CU_SHOWIMAGES) != $CU_SHOWIMAGES)) {
        print <<< print_html
            <CENTER><TABLE WIDTH=95% BORDER=0 CELLPADDING=0 CELLSPACING=0>
                    <tr><td>&nbsp;</td></tr>
                    <tr class='hdrc'><td><DIV class='msg'>
                        Currently your credit union is not setup for on-line check images.
            </DIV> </td></tr> </table>
print_html;

        // Check images unavailable for this vendor
    } else {
        if (!isset($mode))
            $mode = "ENTER";

        $err_msg = "";
        if ($mode == "VIEW") {
            // Validate all information is correct and entered before trying to VIEW the image
            if (trim($check_number) == '' || !is_numeric($check_number)) {
                $err_msg .= "<li>Invalid information for check number.  Be sure the check number is entered.</li><br>";
            } else {
                $check_number = trim($check_number);
            }
            if (trim($check_amount) == '' || !is_numeric($check_amount)) {
                $err_msg .= "<li>Invalid information for check amount.  Be sure the check amount is entered.</li><br>";
            } else {
                $check_amount = number_format($check_amount, 2, '.', '');
            }
            if (trim($rt) == '' || !is_numeric($rt)) {
                $err_msg .= "<li>Invalid information for R&amp;T number.  Be sure the R&amp;T number is selected.</li><br>";
            } else {
                $rt = trim($rt);
            }

            list($mm,$dd,$yyyy) = explode("/",$check_date);
            if (!validateDate("$mm", "$dd", "$yyyy")) {
                $err_msg .= "<li>Invalid Check Date</li><br>";
            } else {
                $check_date = date('m/d/Y', strtotime($check_date));
            }

            if (trim($check_micr) == '' || !is_numeric($check_micr)) {
                $err_msg .= "<li>Invalid information for micr number.  Be sure the micr number is entered.</li><br>";
            } else {
                $check_micr = trim($check_micr);
            }


            if ($err_msg != '') {
                $err_msg = "Some information you entered was either incorrect or missing.<br>
                                        Please examine the error(s) and fix them before continuing.<br>$err_msg";
                $mode = "ENTER";
            }
        }

        if ($err_msg != '') {
            $err_msg = "<tr><td colspan=\"2\" class=\"dtlc\"><span class=\"msg\">$err_msg</span>
                                    </td></tr><tr><td colspan=\"2\" class=\"dtl\"><hr></td></tr>";
        }
        switch ($mode) {
            case "VIEW":
                // Now drop some code to allow the window to be loaded
                // Start out by printing out the information they entered on the previous screen
                // Get any needed information from the cuadmin table

# pass micr as sortkey to ImageSRC program for MidAt clients using tracenumber
# and not micr to retrieve images
/*
 * changed 12/19/12 if FEDIMAGE, send check_number; if MAC send check_micr; else send ''
 * so old legacy hacks for FEDIMAGE and MAC still work without breaking new alternate MICR for
 * WASATCH / ISUCU
 */

if ($img_vendor == 'FEDIMAGE') $sortkey = $check_number;
elseif ($img_vendor == 'MAC') $sortkey = $check_micr;
else $sortkey = '';

                    $dmskey=sha1("${Cu}${img_vendor}${check_number}${check_amount}${check_date}${rt}${check_micr}${sortkey}${Cn}cierto");
                $img_url = "https://{$_SERVER['SERVER_NAME']}" . ($Cl == "L" ? "/hculive7" : "/hcubin7") . "/ImageSRC"
                                        . "?cu=$Cu&chome=$chome&img=$img_vendor&check={$check_number}&amount={$check_amount}"
                                        . "&date={$check_date}&rt={$rt}&micr={$check_micr}&sk=$sortkey&adm=1&dmskey=${dmskey}";
            case "ENTER":
                // This allows the credit union to Enter in the information for the check
                // image, then it validates all the neccessary information is entered
                // before calling the imagesrc

# Get any extra R/T numbers

                    $sql = "SELECT trim(rt), 'P' as pri from cuadmin where cu='$Cu'
                                    UNION ALL
                                    SELECT trim(rt), 'X' as pri from cualtroute where cu='$Cu'
                                    ORDER BY 2,1 ";

                    $sql_rs = db_query($sql, $dbh);

        if (db_num_rows($sql_rs) == 1 ) {
            $hide_rt=1;
            list($key,$value) = db_fetch_array($sql_rs,0);
            $rt_select = "<input type='hidden' name='rt' value='$key'>";
        } else {
            $hide_rt=0;
            $rt_select = "<select name='rt' size=1>
                        <option value=''>Select R/T#</option>\n";
      for ($row=0;list($key, $value) = db_fetch_array($sql_rs,$row); $row++) {
                $rt_select .="<option value='$key'>$key</option>\n";
            }
            $rt_select .= "</select>";
        }

                print <<< print_html
                    <form name="checkinfo" method="post" action="{$_SERVER['SCRIPT_NAME']}?ft={$ft}">
                        <input type="hidden" name="mode" value="VIEW">
                    <br>
                    <table width="90%" border=0 cellpadding=0 cellspacing=0>
                        <tr>
                            <td colspan="2" class="bar" align="center">
                                View Member's Check Image
                            </td>
                        </tr>
                        $err_msg
                        <tr>
                            <td colspan="2" class="hdrl">
                                Check Information
                            </td>
                        </td>
                        <tr>
                            <td class="dtlr" width="30%">
                                Check Number:
                            </td>
                            <td class="dtll" width="70%">
                                <input type="text" name="check_number" value="{$check_number}" size="15" maxlength="20">
                                <font color="green">###</font>
                            </td>
                        </tr>
                        <tr>
                            <td class="dtlr">
                                Check Amount:
                            </td>
                            <td class="dtll">
                                <input type="text" name="check_amount" value="{$check_amount}" size="15" maxlength="15">
                                <font color="green">####.##</font>
                            </td>
                        </tr>
                        <tr>
                            <td class="dtlr">
                                Check Date:
                            </td>
                            <td class="dtll">
                                <input type="text" name="check_date" value="{$check_date}" size="10" maxlength="10">
                                <font color="green">MM/DD/YYYY</font>
                            </td>
                        </tr>
                        <tr>
                            <td class="dtlr">
                                MICR Account Number:
                            </td>
                            <td class="dtll">
                                <input type="text" name="check_micr" value="{$check_micr}" size="20" maxlength="20">
                                <font color="green">###</font>
                            </td>
                        </tr>
print_html;
            if ($hide_rt) {
                    print "$rt_select";
            } else {
                print <<< print_html
                        <tr>
                            <td class="dtlr">
                                Routing &amp; Transit Number:
                            </td>
                            <td class="dtll">
                                $rt_select
                            </td>
                        </tr>
print_html;
}
                print <<< print_html
                        <tr>
                            <td colspan="2" class="dtl"><hr></td>
                        </tr>
                        <tr>
                            <td class="dtl">&nbsp;</td>
                            <td class="dtll">
                                <input type="submit" value="View Image&gt;&gt;" name="btnCheck">
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2" class="dtl">&nbsp;</td>
                        </tr>
print_html;

                if ($img_url != '') {
                    print <<< print_html
                        <script language="javascript">
                            <!--
                            var url='$img_url';
                            window.open (url, "ViewCheck", "scrollbars=yes,resizable=yes");
                            // -->
                        </script>
                        <tr>
                            <td class="msg">&nbsp;</td>
                            <td colspan="1" class="msg">Check Image Loaded</td>
                        </tr>
print_html;
                }

            print "</table></form>";
        }
    }
?>