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; }
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; }