<?php

require "../settings.php";
if (isset($_POST["key"])) {
    $OUTPUT = write_remove();
} else {
    $OUTPUT = confirm_remove();
}
require "gw-tmpl.php";
function confirm_remove()
{
    extract($_GET);
    if (!isset($docid)) {
        return "Invalid Use Of Module.";
    }
    db_conn('crm');
    $get_cust_doc = "SELECT * FROM customer_docs WHERE id = '{$docid}' LIMIT 1";
    $run_cust_doc = db_exec($get_cust_doc) or errDie("Unable to get customer document information.");
    if (pg_numrows($run_cust_doc) > 0) {
        $darr = pg_fetch_array($run_cust_doc);
    } else {
        return "Invalid Use Of Module. Selected Document Not Found.";
    }
    $display = "\n\t\t<h4>Confirm Removal Of Customer Document</h4>\n\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t<input type='hidden' name='docid' value='{$docid}'>\n\t\t<table " . TMPL_tblDflts . ">\n\t\t\t<tr>\n\t\t\t\t<td>Document Description</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>{$darr['filename']}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Document File Name</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>{$darr['real_filename']}</td>\n\t\t\t</tr>\n\t\t\t<tr><td><br></td></tr>\n\t\t\t<tr>\n\t\t\t\t<td><input type='submit' value='Remove'></td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</form>";
    return $display;
}
function write_remove()
{
    extract($_POST);
    db_conn('crm');
    #remove the document
<?php

require "settings.php";
if (isset($_POST["key"])) {
    $OUTPUT = write_remove($_POST);
} else {
    $OUTPUT = confirm_email($_GET);
}
require "template.php";
function confirm_email($_GET)
{
    extract($_GET);
    if (!isset($email) or strlen($email) < 1) {
        return "Invalid Use Of Module. Invalid Email Address.";
    }
    db_connect();
    #verify if this is a valid email adress
    $get_check = "SELECT * FROM cubit.email_groups WHERE emailaddress = '{$email}' LIMIT 1";
    $run_check = db_exec($get_check) or errDie("Unable to get email address information.");
    if (pg_numrows($run_check) < 1) {
        #email address not found ??
        return "Email Address Not Found In List.";
    }
    $display = "\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t<form action='" . SELF . "' method='POST'>\n\t\t\t\t\t\t<input type='hidden' name='key' value='confirm'>\n\t\t\t\t\t\t<input type='hidden' name='email' value='{$email}'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Confirm Removal Of This Email Address From Email Groups</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>{$email}</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t" . TBL_BR . "\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td align='right'><input type='submit' value='Confirm Removal'></td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</form>\n\t\t\t\t\t</table>\n\t\t\t\t";
    return $display;
}
function write_remove($_POST)
{
    extract($_POST);
    if (!isset($email)) {
        return "Invalid Use Of Email.";