コード例 #1
0
function send($_POST)
{
    extract($_POST);
    $es = qryEmailSettings();
    $out = "\n\t\t\t<h3>Results</h3>\n\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t<tr>\n\t\t\t\t\t<th>Quote Num</th>\n\t\t\t\t\t<th>Customer</th>\n\t\t\t\t\t<th>Email Address</th>\n\t\t\t\t\t<th>Result</th>\n\t\t\t\t</tr>";
    $i = 0;
    db_conn('cubit');
    foreach ($evs as $id) {
        $id += 0;
        if (!isset($t)) {
            $Sl = "SELECT quoid,cusnum FROM quotes WHERE quoid='{$id}'";
            $Ri = db_exec($Sl);
        } else {
            $Sl = "SELECT quoid,cusid AS cusnum FROM nons_quotes WHERE quoid='{$id}'";
            $Ri = db_exec($Sl);
        }
        $idd = pg_fetch_array($Ri);
        $idd['cusnum'] += 0;
        $Sl = "SELECT surname,email FROM customers WHERE cusnum='{$idd['cusnum']}'";
        $Ri = db_exec($Sl);
        $cd = pg_fetch_array($Ri);
        if (!isset($t)) {
            $out .= "<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$idd['quoid']}</td>\n\t\t\t\t<td>{$cd['surname']}</td>\n\t\t\t\t<td>" . $email[$idd["cusnum"]] . "</td>\n\t\t\t\t<td>" . sendvoice($id, "genpdf", $email[$idd["cusnum"]], $message) . "</td>\n\t\t\t</tr>";
        } else {
            $out .= "<tr class='" . bg_class() . "'>\n\t\t\t\t<td>{$idd['quoid']}</td>\n\t\t\t\t<td>{$cd['surname']}</td>\n\t\t\t\t<td>" . $email[$idd["cusnum"]] . "</td>\n\t\t\t\t<td>" . sendvoice($id, "gennonspdf", $email[$idd["cusnum"]], $message) . "</td>\n\t\t\t</tr>";
        }
        $i++;
    }
    $out .= "</table>";
    return $out;
}
コード例 #2
0
function send($_POST)
{
    extract($_POST);
    $out = "<h3>Results</h3>\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\n\t<tr><th>Inv Num</th><th>Customer</th><th>Email Address</th><th>Result</th></tr>";
    $i = 0;
    db_conn('cubit');
    foreach ($evs as $id) {
        $id += 0;
        if (!isset($t)) {
            $Sl = "SELECT invnum,cusnum FROM invoices WHERE invid='{$id}'";
            $Ri = db_exec($Sl);
        } else {
            $Sl = "SELECT invnum,cusid AS cusnum FROM nons_invoices WHERE invid='{$id}'";
            $Ri = db_exec($Sl);
        }
        $idd = pg_fetch_array($Ri);
        $idd['cusnum'] += 0;
        $Sl = "SELECT surname,email FROM customers WHERE cusnum='{$idd['cusnum']}'";
        $Ri = db_exec($Sl);
        $cd = pg_fetch_array($Ri);
        if (!isset($t)) {
            $out .= "<tr class='" . bg_class() . "'><td>{$idd['invnum']}</td><td>{$cd['surname']}</td><td>{$cd['email']}</td><td>" . sendvoice($id) . "</td></tr>";
        } else {
            $out .= "<tr class='" . bg_class() . "'><td>{$idd['invnum']}</td><td>{$cd['surname']}</td><td>{$cd['email']}</td><td>" . sendnvoice($id) . "</td></tr>";
        }
        $i++;
    }
    $out .= "</table>";
    return $out;
}