

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: save_client_filings.php</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>&lt;?php
// save_client_filings.php
require_once &#039;db.php&#039;; // must create $mysqli here

function clean($v) {
    return htmlspecialchars(trim($v ?? &#039;&#039;), ENT_QUOTES, &#039;UTF-8&#039;);
}
function to_db_date_from_us($str) {
    if ($str === &#039;&#039;) return null;
    if (!preg_match(&#039;/^(0[1-9]|1[0-2])\/(0[1-9]|[12]\d|3[01])\/\d{4}$/&#039;, $str)) {
        return false;
    }
    [$mm,$dd,$yyyy] = explode(&#039;/&#039;, $str);
    return &quot;$yyyy-$mm-$dd&quot;;
}
function valid_phone($v) {
    return preg_match(&#039;/^\+?[0-9\s\-\(\)]{7,18}$/&#039;, $v);
}
function valid_email($v) {
    return filter_var($v, FILTER_VALIDATE_EMAIL);
}

if ($_SERVER[&#039;REQUEST_METHOD&#039;] !== &#039;POST&#039;) {
    header(&quot;Location: client_filings_form.php&quot;);
    exit;
}

$tax_year           = clean($_POST[&#039;tax_year&#039;] ?? &#039;2024&#039;);
$filing_status      = clean($_POST[&#039;filing_status&#039;] ?? &#039;&#039;);
$primary_first_name = clean($_POST[&#039;primary_first_name&#039;] ?? &#039;&#039;);
$primary_middle_name= clean($_POST[&#039;primary_middle_name&#039;] ?? &#039;&#039;);
$primary_last_name  = clean($_POST[&#039;primary_last_name&#039;] ?? &#039;&#039;);
$primary_ssn_itin   = clean($_POST[&#039;primary_ssn_itin&#039;] ?? &#039;&#039;);
$primary_dob_raw    = clean($_POST[&#039;primary_dob&#039;] ?? &#039;&#039;);
$primary_occupation = clean($_POST[&#039;primary_occupation&#039;] ?? &#039;&#039;);

$visa_status        = clean($_POST[&#039;visa_status&#039;] ?? &#039;&#039;);
$entry_date_raw     = clean($_POST[&#039;entry_date&#039;] ?? &#039;&#039;);

$state_res_json     = $_POST[&#039;state_res_2025_json&#039;] ?? &#039;[]&#039;;
$states_arr         = json_decode($state_res_json, true);
if (!is_array($states_arr)) $states_arr = [];
$states_arr         = array_slice($states_arr, 0, 5);
$state_res_2025     = implode(&#039;, &#039;, $states_arr);

$spouse_first_name  = clean($_POST[&#039;spouse_first_name&#039;] ?? &#039;&#039;);
$spouse_middle_name = clean($_POST[&#039;spouse_middle_name&#039;] ?? &#039;&#039;);
$spouse_last_name   = clean($_POST[&#039;spouse_last_name&#039;] ?? &#039;&#039;);
$spouse_ssn_itin    = clean($_POST[&#039;spouse_ssn_itin&#039;] ?? &#039;&#039;);
$spouse_dob_raw     = clean($_POST[&#039;spouse_dob&#039;] ?? &#039;&#039;);
$spouse_occupation  = clean($_POST[&#039;spouse_occupation&#039;] ?? &#039;&#039;);

$current_address    = clean($_POST[&#039;current_address&#039;] ?? &#039;&#039;);
$cell_number        = clean($_POST[&#039;cell_number&#039;] ?? &#039;&#039;);
$alt_number         = clean($_POST[&#039;alt_number&#039;] ?? &#039;&#039;);
$email              = clean($_POST[&#039;email&#039;] ?? &#039;&#039;);
$remarks            = clean($_POST[&#039;remarks&#039;] ?? &#039;&#039;);

$errors = [];

if ($filing_status === &#039;&#039;) $errors[] = &quot;Filing status required.&quot;;
if ($primary_first_name === &#039;&#039;) $errors[] = &quot;Primary first name required.&quot;;
if ($primary_last_name === &#039;&#039;) $errors[] = &quot;Primary last name required.&quot;;
if ($primary_ssn_itin === &#039;&#039; || !preg_match(&#039;/^\d{4}$/&#039;, $primary_ssn_itin)) $errors[] = &quot;Primary SSN / ITIN must be last 4 digits.&quot;;
if ($primary_dob_raw === &#039;&#039;) $errors[] = &quot;Date of birth required.&quot;;
if ($visa_status === &#039;&#039;) $errors[] = &quot;Visa status required.&quot;;
if ($entry_date_raw === &#039;&#039;) $errors[] = &quot;Port of entry date required.&quot;;
if (empty($states_arr)) $errors[] = &quot;State of residence in 2025 required.&quot;;
if ($current_address === &#039;&#039;) $errors[] = &quot;Current address required.&quot;;
if ($cell_number === &#039;&#039; || !valid_phone($cell_number)) $errors[] = &quot;Valid cell number required.&quot;;
if ($email === &#039;&#039; || !valid_email($email)) $errors[] = &quot;Valid email required.&quot;;

$entry_date_db   = null;
$primary_dob_db  = null;
$spouse_dob_db   = null;

if ($entry_date_raw !== &#039;&#039;) {
    $entry_date_db = to_db_date_from_us($entry_date_raw);
    if ($entry_date_db === false) $errors[] = &quot;Entry date must be in MM/DD/YYYY format.&quot;;
}
if ($primary_dob_raw !== &#039;&#039;) {
    $primary_dob_db = to_db_date_from_us($primary_dob_raw);
    if ($primary_dob_db === false) $errors[] = &quot;Primary DOB must be in MM/DD/YYYY format.&quot;;
}
if ($spouse_dob_raw !== &#039;&#039;) {
    $spouse_dob_db = to_db_date_from_us($spouse_dob_raw);
    if ($spouse_dob_db === false) $errors[] = &quot;Spouse DOB must be in MM/DD/YYYY format.&quot;;
}

if (!empty($errors)) {
    $err = urlencode(implode(&quot; &quot;, $errors));
    header(&quot;Location: client_filings_form.php?err={$err}&quot;);
    exit;
}

$stmt = $mysqli-&gt;prepare(&quot;INSERT INTO taxpayer_forms
(tax_year, filing_status, primary_first_name, primary_middle_name, primary_last_name,
 primary_ssn_itin, primary_dob, primary_occupation, address, cell_number, alt_number,
 email, remarks, entry_date, visa_status, state_res_2025)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)&quot;);

$stmt-&gt;bind_param(
    &quot;ssssssssssssssss&quot;,
    $tax_year,
    $filing_status,
    $primary_first_name,
    $primary_middle_name,
    $primary_last_name,
    $primary_ssn_itin,
    $primary_dob_db,
    $primary_occupation,
    $current_address,
    $cell_number,
    $alt_number,
    $email,
    $remarks,
    $entry_date_db,
    $visa_status,
    $state_res_2025
);

$ok = $stmt-&gt;execute();
if (!$ok) {
    $err = urlencode(&quot;DB error: &quot; . $stmt-&gt;error);
    header(&quot;Location: client_filings_form.php?err={$err}&quot;);
    exit;
}
$form_id = $stmt-&gt;insert_id;
$stmt-&gt;close();

// spouse
if (!in_array($filing_status, [&#039;SINGLE&#039;,&#039;HOH&#039;]) &amp;&amp;
    ($spouse_first_name !== &#039;&#039; || $spouse_last_name !== &#039;&#039; || $spouse_ssn_itin !== &#039;&#039;)
) {
    $sp = $mysqli-&gt;prepare(&quot;INSERT INTO spouses
        (form_id, first_name, middle_name, last_name, ssn_itin, dob, occupation)
        VALUES (?,?,?,?,?,?,?)&quot;);
    $sp-&gt;bind_param(
        &quot;issssss&quot;,
        $form_id,
        $spouse_first_name,
        $spouse_middle_name,
        $spouse_last_name,
        $spouse_ssn_itin,
        $spouse_dob_db,
        $spouse_occupation
    );
    $sp-&gt;execute();
    $sp-&gt;close();
}

// dependents
if ($filing_status !== &#039;SINGLE&#039;) {
    $dep_first_name = $_POST[&#039;dep_first_name&#039;] ?? [];
    $dep_middle_name= $_POST[&#039;dep_middle_name&#039;] ?? [];
    $dep_last_name  = $_POST[&#039;dep_last_name&#039;] ?? [];
    $dep_ssn_itin   = $_POST[&#039;dep_ssn_itin&#039;] ?? [];
    $dep_dob        = $_POST[&#039;dep_dob&#039;] ?? [];
    $dep_rel        = $_POST[&#039;dep_relationship&#039;] ?? [];

    for ($i=0; $i&lt;count($dep_first_name); $i++) {
        $df = clean($dep_first_name[$i] ?? &#039;&#039;);
        $dm = clean($dep_middle_name[$i] ?? &#039;&#039;);
        $dl = clean($dep_last_name[$i] ?? &#039;&#039;);
        $ds = clean($dep_ssn_itin[$i] ?? &#039;&#039;);
        $dd_raw = clean($dep_dob[$i] ?? &#039;&#039;);
        $dr = clean($dep_rel[$i] ?? &#039;&#039;);
        if ($df === &#039;&#039; &amp;&amp; $dl === &#039;&#039; &amp;&amp; $ds === &#039;&#039;) continue;

        $dd_db = null;
        if ($dd_raw !== &#039;&#039;) {
            $dd_db = to_db_date_from_us($dd_raw);
            if ($dd_db === false) $dd_db = null;
        }

        $dp = $mysqli-&gt;prepare(&quot;INSERT INTO dependents
          (form_id, first_name, middle_name, last_name, ssn_itin, dob, relationship)
          VALUES (?,?,?,?,?,?,?)&quot;);
        $dp-&gt;bind_param(
            &quot;issssss&quot;,
            $form_id,
            $df,
            $dm,
            $dl,
            $ds,
            $dd_db,
            $dr
        );
        $dp-&gt;execute();
        $dp-&gt;close();
    }
}

header(&quot;Location: client_filings_form.php?ok=1&quot;);
exit;
</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/securetaxfiles.com/save_client_filings.php'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2Fsecuretaxfiles.com' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>