<?php
session_start();
print_r($_POST);
    if (file_exists ("/xampp/runningLocal/runningLocal")) { 
        $thisdomain = 'localhost';
    } else {
        $thisdomain = 'zapquotes.com';
    }
$agentpath = $_POST['agentpath'];


//=======================================================================================check password=================================================
    $servername = "localhost";
    $username = "root";
    $password = "gardner521";
    $dbname = "agents";
    if (file_exists ("/xampp/runningLocal/runningLocal")) {   
    $servername = "localhost";
    $username = "root";
    $password = "Hos^zap521soH";
    $dbname = "agents";
    }
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    $result = mysqli_query($conn, "SELECT pwd FROM agents
                      WHERE agentpath='$agentpath';");
    $row = mysqli_fetch_array($result);
if ($row[0] !== $_POST['password'] && !isset($_POST['effyear'])) {
   die('Password not valid');
}
//=======================================================================================end checkpassword=================================================

if (isset($_POST['agentpath']) && isset($_POST['credentials'])) {
    $agentpath = $_POST['agentpath'];
    //print '--post--';
    //print_r($_POST);
  
    if ($_POST['emplrname'] === '') {
        echo 'You must enter an employer name';
        die();
    }
    if ($_POST['emplrzip'] === '') {
        echo 'You must a zip code for the employer';
        die();
    }
    if ($_POST['effmonth'] === '') {
        echo 'You must enter an effectove month';
        die();
    }
    if ($_POST['effyear'] === '') {
        echo 'You must enter an effectove year';
        die();
    }
    if ($_POST['emplrzip'] === '') {
        echo 'You must enter the number of employees';
        die();
    }
}
if (isset($_GET['agentpath'])) {
    print '--get--';
    print_r($_GET);
}

$groupdirectory = '../homepage/group/'.$agentpath;
if(!is_dir($groupdirectory)){
    mkdir($groupdirectory);
}
$imgdirectory = '../homepage/group/'.$agentpath.'/logos';
if(!is_dir($imgdirectory)){
    mkdir($imgdirectory);
    
    //$outfile = fopen((__DIR__).'/u/'.$usercode.'/'.$showcode.'/uploadimg.html','w');
    //create html upload form
    $htmlfile = fopen('../homepage/group/'.$agentpath.'/uploadimg.html','w');
    fwrite($htmlfile,'<html>'.chr(10));
       fwrite($htmlfile,'<body>'.chr(10));

          fwrite($htmlfile,'<form action="https://'.$thisdomain.'/fl/homepage/group/'.$agentpath.'/uploadimg.php" method="POST" enctype="multipart/form-data">'.chr(10));
             fwrite($htmlfile,'<input type="file" name="image" /><p>'.chr(10));
             fwrite($htmlfile,'<input type="submit"/>'.chr(10));
          fwrite($htmlfile,'</form>'.chr(10));
       fwrite($htmlfile,'</body>'.chr(10));
    fwrite($htmlfile,'</html>'.chr(10));
    fclose($htmlfile);
    //create php file to process uploads
    $phpfile = fopen('../homepage/group/'.$agentpath.'/uploadimg.php','w');
    fwrite($phpfile,"<?php".chr(10));
        fwrite($phpfile,'if(isset($_FILES["image"])){'.chr(10));
    fwrite($phpfile,'  $errors = array();'.chr(10));
    fwrite($phpfile,'$file_name = $_FILES["image"]["name"];'.chr(10));
    fwrite($phpfile,'$tfile_name = $_FILES["image"]["name"];'.chr(10));
    fwrite($phpfile,'$tfile_name = $_FILES["image"]["name"];'.chr(10));
    fwrite($phpfile,'$file_size =$_FILES["image"]["size"];'.chr(10));
    fwrite($phpfile,'$file_tmp =$_FILES["image"]["tmp_name"];'.chr(10));
    fwrite($phpfile,'$file_type=$_FILES["image"]["type"];'.chr(10));
    fwrite($phpfile,'$file_name = strtolower($file_name);'.chr(10));
    fwrite($phpfile,'$tlist = explode(".",$file_name);'.chr(10));
    fwrite($phpfile,'$file_ext = end($tlist);'.chr(10));
    fwrite($phpfile,'$extensions= array("jpeg","jpe","jpg","png","gif");'.chr(10));
    fwrite($phpfile,'if(in_array($file_ext,$extensions)=== false){'.chr(10));
    fwrite($phpfile,'  $errors[]="extension not allowed, please choose a JPEG, JPE, JPG, GIG or PNG file.";'.chr(10));
    fwrite($phpfile,"}".chr(10));
    fwrite($phpfile,'if($file_size > 5097152){'.chr(10));
    fwrite($phpfile,'   $errors[]="File size must be less than 5 MB";'.chr(10));
    fwrite($phpfile,"}".chr(10));
    fwrite($phpfile,'if(empty($errors)==true){'.chr(10));
    fwrite($phpfile,'  move_uploaded_file($file_tmp,"logos/".$file_name);'.chr(10));
    fwrite($phpfile,'     echo "Success<br>";'.chr(10));
    fwrite($phpfile,"echo '<b>Link:</b><br> https://'.$thisdomain.'/fl/homepage/group/$agentpath/logos/'.");
    fwrite($phpfile, '$file_name.');
    fwrite($phpfile, "'</a>';".chr(10));
    fwrite($phpfile,"  echo '<p><a href='.chr(34).'javascript:history.back()'.chr(34).'>Upload another image file</a>';".chr(10));
    fwrite($phpfile,"}else{".chr(10));
    fwrite($phpfile,'print_r($errors);'.chr(10));
    fwrite($phpfile,"}".chr(10));
    fwrite($phpfile,"}".chr(10));
    fwrite($phpfile,"?>".chr(10));
    fclose($phpfile);
    
}

echo '<!DOCTYPE html><html><head><meta charset="utf-8"><title>ZapIndex</title><meta http-equiv="cache-control" content="no-cache" />';

echo '</head><body>'.chr(10);

echo '<input type="hidden" name="agentpath" id="hidagentpath" value="'.$agentpath.'">';
$_SESSION["agentpath"] = $_POST['agentpath'];
$_SESSION["agelist"] = array();

$_SESSION["agent"] = $_POST['agent'];
echo '<input type="hidden" name="agent" id="hidagent" value="'.$_POST['agent'].'">';
//["emplrname"] = $_POST['emplrname'];
$_SESSION["effmonth"] = $_POST['effmonth'];
//echo '<input type="hidden" name="effmonth" id="hideffmonth" value="'.$_POST['effmonth'].'">';
$_SESSION["effyear"] = $_POST['effyear'];
$_SESSION["eecount"] = $_POST['eecount'];
$_SESSION["agency"] = $_POST['agency'];
echo '<input type="hidden" name="agency" id="hidagency" value="'.$_POST['agency'].'">';
$_SESSION["address"] = $_POST['address'];
echo '<input type="hidden" name="address" id="hidaddress" value="'.$_POST['address'].'">';
$_SESSION["city"] = $_POST['city'];
echo '<input type="hidden" name="city" id="hidcity" value="'.$_POST['city'].'">';
$_SESSION["state"] = $_POST['state'];
echo '<input type="hidden" name="state" id="hidstate" value="'.$_POST['state'].'">';
$_SESSION["zip"] = $_POST['zip'];
echo '<input type="hidden" name="zip" id="hidzip" value="'.$_POST['zip'].'">';
$_SESSION["email"] = $_POST['email'];
echo '<input type="hidden" name="email" id="hidemail" value="'.$_POST['email'].'">';
$_SESSION["phone"] = $_POST['phone'];
echo '<input type="hidden" name="phone" id="hidphone" value="'.$_POST['phone'].'">';
$_SESSION["username"] = $_POST['username'];
$_SESSION["license"] = $_POST['license'];
echo '<input type="hidden" name="license" id="hidlicense" value="'.$_POST['license'].'">';

$quotenum = '';


$emplrname = '';
if (isset($_POST['emplrname'])) {
    $emplrname = $_POST['emplrname'];
    echo '<div style="font-size:1.5em;font-weight:bold;">'.$emplrname.'</div>'.chr(10);    
}
$emplrzip = '';
if (isset($_POST['emplrzip'])) {
    $emplrzip = $_POST['emplrzip'];
    echo '<div style="font-size:1.3em;font-weight:bold;">Zip Code: '.$emplrzip.'</div>'.chr(10);
}

$effmonth = '';
$effyear = '';
if (isset($_POST['effmonth']) && isset($_POST['effyear'])) {
    $effmonth = $_POST['effmonth'];
    $effyear = $_POST['effyear'];
    echo '<div style="font-size:1.3em;font-weight:bold;">Eff. Date: '.$effmonth.'/'.$effyear.'</div>'.chr(10);   

//if ($_POST['emplrname'] !== '') {
if (isset($_POST['quotenum'])) {
    echo '<p>Click the link below to open census for quoting<p>';
    echo '<div>';
    echo '<a href="https://'.$thisdomain.'/group/recall.php/?agentpath='.$agentpath.'">Recall census</a>';
    echo '</div>';
}

}






include 'ages.php';    //===================================================================================================================include ages.php================

if (isset($_POST['eedob1'])) {
    $_SESSION["agelist"] = getagelist($agentpath);  //in ages.php - makes agelist
} 



function getemplrcounty($emplrzip) {
    $pairs = "90001^Los Angeles~90002^Los Angeles~90003^Los Angeles~90004^Los Angeles~90005^Los Angeles~90006^Los Angeles~90007^Los Angeles~90008^Los Angeles~90009^Los Angeles~90010^Los Angeles~90011^Los Angeles~90012^Los Angeles~90013^Los Angeles~90014^Los Angeles~90015^Los Angeles~90016^Los Angeles~90017^Los Angeles~90018^Los Angeles~90019^Los Angeles~90020^Los Angeles~90021^Los Angeles~90022^Los Angeles~90023^Los Angeles~90024^Los Angeles~90025^Los Angeles~90026^Los Angeles~90027^Los Angeles~90028^Los Angeles~90029^Los Angeles~90030^Los Angeles~90031^Los Angeles~90032^Los Angeles~90033^Los Angeles~90034^Los Angeles~90035^Los Angeles~90036^Los Angeles~90037^Los Angeles~90038^Los Angeles~90039^Los Angeles~90040^Los Angeles~90041^Los Angeles~90042^Los Angeles~90043^Los Angeles~90044^Los Angeles~90045^Los Angeles~90046^Los Angeles~90047^Los Angeles~90048^Los Angeles~90049^Los Angeles~90050^Los Angeles~90051^Los Angeles~90052^Los Angeles~90053^Los Angeles~90054^Los Angeles~90055^Los Angeles~90056^Los Angeles~90057^Los Angeles~90058^Los Angeles~90059^Los Angeles~90060^Los Angeles~90061^Los Angeles~90062^Los Angeles~90063^Los Angeles~90064^Los Angeles~90065^Los Angeles~90066^Los Angeles~90067^Los Angeles~90068^Los Angeles~90069^Los Angeles~90070^Los Angeles~90071^Los Angeles~90072^Los Angeles~90073^Los Angeles~90074^Los Angeles~90075^Los Angeles~90076^Los Angeles~90077^Los Angeles~90078^Los Angeles~90079^Los Angeles~90080^Los Angeles~90081^Los Angeles~90082^Los Angeles~90083^Los Angeles~90084^Los Angeles~90086^Los Angeles~90087^Los Angeles~90088^Los Angeles~90089^Los Angeles~90091^Los Angeles~90093^Los Angeles~90094^Los Angeles~90095^Los Angeles~90096^Los Angeles~90099^Los Angeles~90101^Los Angeles~90102^Los Angeles~90103^Los Angeles~90189^Los Angeles~90201^Los Angeles~90202^Los Angeles~90209^Los Angeles~90210^Los Angeles~90211^Los Angeles~90212^Los Angeles~90213^Los Angeles~90220^Los Angeles~90221^Los Angeles~90222^Los Angeles~90223^Los Angeles~90224^Los Angeles~90230^Los Angeles~90231^Los Angeles~90232^Los Angeles~90233^Los Angeles~90239^Los Angeles~90240^Los Angeles~90241^Los Angeles~90242^Los Angeles~90245^Los Angeles~90247^Los Angeles~90248^Los Angeles~90249^Los Angeles~90250^Los Angeles~90251^Los Angeles~90254^Los Angeles~90255^Los Angeles~90260^Los Angeles~90261^Los Angeles~90262^Los Angeles~90263^Los Angeles~90264^Los Angeles~90265^Los Angeles~90266^Los Angeles~90267^Los Angeles~90270^Los Angeles~90272^Los Angeles~90274^Los Angeles~90275^Los Angeles~90277^Los Angeles~90278^Los Angeles~90280^Los Angeles~90290^Los Angeles~90291^Los Angeles~90292^Los Angeles~90293^Los Angeles~90294^Los Angeles~90295^Los Angeles~90296^Los Angeles~90301^Los Angeles~90302^Los Angeles~90303^Los Angeles~90304^Los Angeles~90305^Los Angeles~90306^Los Angeles~90307^Los Angeles~90308^Los Angeles~90309^Los Angeles~90310^Los Angeles~90311^Los Angeles~90312^Los Angeles~90313^Los Angeles~90397^Los Angeles~90398^Los Angeles~90401^Los Angeles~90402^Los Angeles~90403^Los Angeles~90404^Los Angeles~90405^Los Angeles~90406^Los Angeles~90407^Los Angeles~90408^Los Angeles~90409^Los Angeles~90410^Los Angeles~90411^Los Angeles~90501^Los Angeles~90502^Los Angeles~90503^Los Angeles~90504^Los Angeles~90505^Los Angeles~90506^Los Angeles~90507^Los Angeles~90508^Los Angeles~90509^Los Angeles~90510^Los Angeles~90601^Los Angeles~90602^Los Angeles~90603^Los Angeles~90604^Los Angeles~90605^Los Angeles~90606^Los Angeles~90607^Los Angeles~90608^Los Angeles~90609^Los Angeles~90610^Los Angeles~90612^Los Angeles~90620^Orange~90621^Orange~90622^Orange~90623^Orange~90624^Orange~90630^Orange~90631^Orange~90632^Orange~90633^Orange~90637^Los Angeles~90638^Los Angeles~90639^Los Angeles~90640^Los Angeles~90650^Los Angeles~90651^Los Angeles~90652^Los Angeles~90659^Los Angeles~90660^Los Angeles~90661^Los Angeles~90662^Los Angeles~90665^Los Angeles~90670^Los Angeles~90671^Los Angeles~90680^Orange~90701^Los Angeles~90702^Los Angeles~90703^Los Angeles~90704^Los Angeles~90706^Los Angeles~90707^Los Angeles~90710^Los Angeles~90711^Los Angeles~90712^Los Angeles~90713^Los Angeles~90714^Los Angeles~90715^Los Angeles~90716^Los Angeles~90717^Los Angeles~90720^Orange~90721^Orange~90723^Los Angeles~90731^Los Angeles~90732^Los Angeles~90733^Los Angeles~90734^Los Angeles~90740^Orange~90742^Orange~90743^Orange~90744^Los Angeles~90745^Los Angeles~90746^Los Angeles~90747^Los Angeles~90748^Los Angeles~90749^Los Angeles~90755^Los Angeles~90801^Los Angeles~90802^Los Angeles~90803^Los Angeles~90804^Los Angeles~90805^Los Angeles~90806^Los Angeles~90807^Los Angeles~90808^Los Angeles~90809^Los Angeles~90810^Los Angeles~90813^Los Angeles~90814^Los Angeles~90815^Los Angeles~90822^Los Angeles~90831^Los Angeles~90832^Los Angeles~90833^Los Angeles~90834^Los Angeles~90835^Los Angeles~90840^Los Angeles~90842^Los Angeles~90844^Los Angeles~90845^Los Angeles~90846^Los Angeles~90847^Los Angeles~90848^Los Angeles~90853^Los Angeles~90888^Los Angeles~90895^Los Angeles~90899^Los Angeles~91001^Los Angeles~91003^Los Angeles~91006^Los Angeles~91007^Los Angeles~91009^Los Angeles~91010^Los Angeles~91011^Los Angeles~91012^Los Angeles~91016^Los Angeles~91017^Los Angeles~91020^Los Angeles~91021^Los Angeles~91023^Los Angeles~91024^Los Angeles~91025^Los Angeles~91030^Los Angeles~91031^Los Angeles~91040^Los Angeles~91041^Los Angeles~91042^Los Angeles~91043^Los Angeles~91046^Los Angeles~91066^Los Angeles~91077^Los Angeles~91101^Los Angeles~91102^Los Angeles~91103^Los Angeles~91104^Los Angeles~91105^Los Angeles~91106^Los Angeles~91107^Los Angeles~91108^Los Angeles~91109^Los Angeles~91110^Los Angeles~91114^Los Angeles~91115^Los Angeles~91116^Los Angeles~91117^Los Angeles~91118^Los Angeles~91121^Los Angeles~91123^Los Angeles~91124^Los Angeles~91125^Los Angeles~91126^Los Angeles~91129^Los Angeles~91131^Los Angeles~91175^Los Angeles~91182^Los Angeles~91184^Los Angeles~91185^Los Angeles~91186^Los Angeles~91187^Los Angeles~91188^Los Angeles~91189^Los Angeles~91191^Los Angeles~91199^Los Angeles~91201^Los Angeles~91202^Los Angeles~91203^Los Angeles~91204^Los Angeles~91205^Los Angeles~91206^Los Angeles~91207^Los Angeles~91208^Los Angeles~91209^Los Angeles~91210^Los Angeles~91214^Los Angeles~91221^Los Angeles~91222^Los Angeles~91224^Los Angeles~91225^Los Angeles~91226^Los Angeles~91301^Los Angeles~91302^Los Angeles~91303^Los Angeles~91304^Los Angeles~91305^Los Angeles~91306^Los Angeles~91307^Los Angeles~91308^Los Angeles~91309^Los Angeles~91310^Los Angeles~91311^Los Angeles~91312^Los Angeles~91313^Los Angeles~91316^Los Angeles~91319^Ventura~91320^Ventura~91321^Los Angeles~91322^Los Angeles~91324^Los Angeles~91325^Los Angeles~91326^Los Angeles~91327^Los Angeles~91328^Los Angeles~91329^Los Angeles~91330^Los Angeles~91331^Los Angeles~91333^Los Angeles~91334^Los Angeles~91335^Los Angeles~91337^Los Angeles~91340^Los Angeles~91341^Los Angeles~91342^Los Angeles~91343^Los Angeles~91344^Los Angeles~91345^Los Angeles~91346^Los Angeles~91350^Los Angeles~91351^Los Angeles~91352^Los Angeles~91353^Los Angeles~91354^Los Angeles~91355^Los Angeles~91356^Los Angeles~91357^Los Angeles~91358^Ventura~91359^Ventura~91360^Ventura~91361^Ventura~91362^Ventura~91363^Los Angeles~91364^Los Angeles~91365^Los Angeles~91367^Los Angeles~91371^Los Angeles~91372^Los Angeles~91376^Los Angeles~91377^Ventura~91380^Los Angeles~91381^Los Angeles~91382^Los Angeles~91383^Los Angeles~91384^Los Angeles~91385^Los Angeles~91386^Los Angeles~91387^Los Angeles~91388^Los Angeles~91390^Los Angeles~91392^Los Angeles~91393^Los Angeles~91394^Los Angeles~91395^Los Angeles~91396^Los Angeles~91399^Los Angeles~91401^Los Angeles~91402^Los Angeles~91403^Los Angeles~91404^Los Angeles~91405^Los Angeles~91406^Los Angeles~91407^Los Angeles~91408^Los Angeles~91409^Los Angeles~91410^Los Angeles~91411^Los Angeles~91412^Los Angeles~91413^Los Angeles~91416^Los Angeles~91423^Los Angeles~91426^Los Angeles~91436^Los Angeles~91470^Los Angeles~91482^Los Angeles~91495^Los Angeles~91496^Los Angeles~91497^Los Angeles~91499^Los Angeles~91501^Los Angeles~91502^Los Angeles~91503^Los Angeles~91504^Los Angeles~91505^Los Angeles~91506^Los Angeles~91507^Los Angeles~91508^Los Angeles~91510^Los Angeles~91521^Los Angeles~91522^Los Angeles~91523^Los Angeles~91526^Los Angeles~91601^Los Angeles~91602^Los Angeles~91603^Los Angeles~91604^Los Angeles~91605^Los Angeles~91606^Los Angeles~91607^Los Angeles~91608^Los Angeles~91609^Los Angeles~91610^Los Angeles~91611^Los Angeles~91612^Los Angeles~91614^Los Angeles~91615^Los Angeles~91616^Los Angeles~91617^Los Angeles~91618^Los Angeles~91701^San Bernardino~91702^Los Angeles~91706^Los Angeles~91708^San Bernardino~91709^San Bernardino~91710^San Bernardino~91711^Los Angeles~91714^Los Angeles~91715^Los Angeles~91716^Los Angeles~91722^Los Angeles~91723^Los Angeles~91724^Los Angeles~91729^San Bernardino~91730^San Bernardino~91731^Los Angeles~91732^Los Angeles~91733^Los Angeles~91734^Los Angeles~91735^Los Angeles~91737^San Bernardino~91739^San Bernardino~91740^Los Angeles~91741^Los Angeles~91743^San Bernardino~91744^Los Angeles~91745^Los Angeles~91746^Los Angeles~91747^Los Angeles~91748^Los Angeles~91749^Los Angeles~91750^Los Angeles~91752^Riverside~91754^Los Angeles~91755^Los Angeles~91756^Los Angeles~91758^San Bernardino~91759^Los Angeles~91761^San Bernardino~91762^San Bernardino~91763^San Bernardino~91764^San Bernardino~91765^Los Angeles~91766^Los Angeles~91767^Los Angeles~91768^Los Angeles~91769^Los Angeles~91770^Los Angeles~91771^Los Angeles~91772^Los Angeles~91773^Los Angeles~91775^Los Angeles~91776^Los Angeles~91778^Los Angeles~91780^Los Angeles~91784^San Bernardino~91785^San Bernardino~91786^San Bernardino~91788^Los Angeles~91789^Los Angeles~91790^Los Angeles~91791^Los Angeles~91792^Los Angeles~91793^Los Angeles~91795^Los Angeles~91797^Los Angeles~91798^San Bernardino~91799^Los Angeles~91801^Los Angeles~91802^Los Angeles~91803^Los Angeles~91804^Los Angeles~91841^Los Angeles~91896^Los Angeles~91899^Los Angeles~91901^San Diego~91902^San Diego~91903^San Diego~91905^San Diego~91906^San Diego~91908^San Diego~91909^San Diego~91910^San Diego~91911^San Diego~91912^San Diego~91913^San Diego~91914^San Diego~91915^San Diego~91916^San Diego~91917^San Diego~91921^San Diego~91931^San Diego~91932^San Diego~91933^San Diego~91934^San Diego~91935^San Diego~91941^San Diego~91942^San Diego~91943^San Diego~91944^San Diego~91945^San Diego~91946^San Diego~91947^San Diego~91948^San Diego~91950^San Diego~91951^San Diego~91962^San Diego~91963^San Diego~91976^San Diego~91977^San Diego~91978^San Diego~91979^San Diego~91980^San Diego~91987^San Diego~91990^San Diego~92003^San Diego~92004^San Diego~92007^San Diego~92008^San Diego~92009^San Diego~92010^San Diego~92011^San Diego~92013^San Diego~92014^San Diego~92018^San Diego~92019^San Diego~92020^San Diego~92021^San Diego~92022^San Diego~92023^San Diego~92024^San Diego~92025^San Diego~92026^San Diego~92027^San Diego~92028^San Diego~92029^San Diego~92030^San Diego~92033^San Diego~92036^San Diego~92037^San Diego~92038^San Diego~92039^San Diego~92040^San Diego~92046^San Diego~92049^San Diego~92051^San Diego~92052^San Diego~92054^San Diego~92055^San Diego~92056^San Diego~92057^San Diego~92058^San Diego~92059^San Diego~92060^San Diego~92061^San Diego~92064^San Diego~92065^San Diego~92066^San Diego~92067^San Diego~92068^San Diego~92069^San Diego~92070^San Diego~92071^San Diego~92072^San Diego~92074^San Diego~92075^San Diego~92078^San Diego~92079^San Diego~92081^San Diego~92082^San Diego~92083^San Diego~92084^San Diego~92085^San Diego~92086^San Diego~92088^San Diego~92090^San Diego~92091^San Diego~92092^San Diego~92093^San Diego~92096^San Diego~92101^San Diego~92102^San Diego~92103^San Diego~92104^San Diego~92105^San Diego~92106^San Diego~92107^San Diego~92108^San Diego~92109^San Diego~92110^San Diego~92111^San Diego~92112^San Diego~92113^San Diego~92114^San Diego~92115^San Diego~92116^San Diego~92117^San Diego~92118^San Diego~92119^San Diego~92120^San Diego~92121^San Diego~92122^San Diego~92123^San Diego~92124^San Diego~92126^San Diego~92127^San Diego~92128^San Diego~92129^San Diego~92130^San Diego~92131^San Diego~92132^San Diego~92133^San Diego~92134^San Diego~92135^San Diego~92136^San Diego~92137^San Diego~92138^San Diego~92139^San Diego~92140^San Diego~92142^San Diego~92143^San Diego~92145^San Diego~92147^San Diego~92149^San Diego~92150^San Diego~92152^San Diego~92153^San Diego~92154^San Diego~92155^San Diego~92158^San Diego~92159^San Diego~92160^San Diego~92161^San Diego~92162^San Diego~92163^San Diego~92164^San Diego~92165^San Diego~92166^San Diego~92167^San Diego~92168^San Diego~92169^San Diego~92170^San Diego~92171^San Diego~92172^San Diego~92173^San Diego~92174^San Diego~92175^San Diego~92176^San Diego~92177^San Diego~92178^San Diego~92179^San Diego~92182^San Diego~92184^San Diego~92186^San Diego~92187^San Diego~92190^San Diego~92191^San Diego~92192^San Diego~92193^San Diego~92194^San Diego~92195^San Diego~92196^San Diego~92197^San Diego~92198^San Diego~92199^San Diego~92201^Riverside~92202^Riverside~92203^Riverside~92210^Riverside~92211^Riverside~92220^Riverside~92222^Imperial~92223^Riverside~92225^Riverside~92226^Riverside~92227^Imperial~92230^Riverside~92231^Imperial~92232^Imperial~92233^Imperial~92234^Riverside~92235^Riverside~92236^Riverside~92239^Riverside~92240^Riverside~92241^Riverside~92242^San Bernardino~92243^Imperial~92244^Imperial~92247^Riverside~92248^Riverside~92249^Imperial~92250^Imperial~92251^Imperial~92252^San Bernardino~92253^Riverside~92254^Riverside~92255^Riverside~92256^San Bernardino~92257^Imperial~92258^Riverside~92259^Imperial~92260^Riverside~92261^Riverside~92262^Riverside~92263^Riverside~92264^Riverside~92266^Imperial~92267^San Bernardino~92268^San Bernardino~92270^Riverside~92273^Imperial~92274^Riverside~92275^Imperial~92276^Riverside~92277^San Bernardino~92278^San Bernardino~92280^San Bernardino~92281^Imperial~92282^Riverside~92283^Imperial~92284^San Bernardino~92285^San Bernardino~92286^San Bernardino~92292^Riverside~92301^San Bernardino~92304^San Bernardino~92305^San Bernardino~92307^San Bernardino~92308^San Bernardino~92309^San Bernardino~92310^San Bernardino~92311^San Bernardino~92312^San Bernardino~92313^San Bernardino~92314^San Bernardino~92315^San Bernardino~92316^San Bernardino~92317^San Bernardino~92318^San Bernardino~92320^Riverside~92321^San Bernardino~92322^San Bernardino~92323^San Bernardino~92324^San Bernardino~92325^San Bernardino~92326^San Bernardino~92327^San Bernardino~92328^Inyo~92329^San Bernardino~92332^San Bernardino~92333^San Bernardino~92334^San Bernardino~92335^San Bernardino~92336^San Bernardino~92337^San Bernardino~92338^San Bernardino~92339^San Bernardino~92340^San Bernardino~92341^San Bernardino~92342^San Bernardino~92344^San Bernardino~92345^San Bernardino~92346^San Bernardino~92347^San Bernardino~92350^San Bernardino~92352^San Bernardino~92354^San Bernardino~92356^San Bernardino~92357^San Bernardino~92358^San Bernardino~92359^San Bernardino~92363^San Bernardino~92364^San Bernardino~92365^San Bernardino~92366^San Bernardino~92368^San Bernardino~92369^San Bernardino~92371^San Bernardino~92372^San Bernardino~92373^San Bernardino~92374^San Bernardino~92375^San Bernardino~92376^San Bernardino~92377^San Bernardino~92378^San Bernardino~92382^San Bernardino~92384^Inyo~92385^San Bernardino~92386^San Bernardino~92389^Inyo~92391^San Bernardino~92392^San Bernardino~92393^San Bernardino~92394^San Bernardino~92395^San Bernardino~92397^San Bernardino~92398^San Bernardino~92399^San Bernardino~92401^San Bernardino~92402^San Bernardino~92403^San Bernardino~92404^San Bernardino~92405^San Bernardino~92406^San Bernardino~92407^San Bernardino~92408^San Bernardino~92410^San Bernardino~92411^San Bernardino~92412^San Bernardino~92413^San Bernardino~92414^San Bernardino~92415^San Bernardino~92418^San Bernardino~92423^San Bernardino~92424^San Bernardino~92427^San Bernardino~92501^Riverside~92502^Riverside~92503^Riverside~92504^Riverside~92505^Riverside~92506^Riverside~92507^Riverside~92508^Riverside~92509^Riverside~92513^Riverside~92514^Riverside~92515^Riverside~92516^Riverside~92517^Riverside~92518^Riverside~92519^Riverside~92521^Riverside~92522^Riverside~92530^Riverside~92531^Riverside~92532^Riverside~92536^Riverside~92539^Riverside~92543^Riverside~92544^Riverside~92545^Riverside~92546^Riverside~92548^Riverside~92549^Riverside~92551^Riverside~92552^Riverside~92553^Riverside~92554^Riverside~92555^Riverside~92556^Riverside~92557^Riverside~92561^Riverside~92562^Riverside~92563^Riverside~92564^Riverside~92567^Riverside~92570^Riverside~92571^Riverside~92572^Riverside~92581^Riverside~92582^Riverside~92583^Riverside~92584^Riverside~92585^Riverside~92586^Riverside~92587^Riverside~92589^Riverside~92590^Riverside~92591^Riverside~92592^Riverside~92593^Riverside~92595^Riverside~92596^Riverside~92599^Riverside~92602^Orange~92603^Orange~92604^Orange~92605^Orange~92606^Orange~92607^Orange~92609^Orange~92610^Orange~92612^Orange~92614^Orange~92615^Orange~92616^Orange~92617^Orange~92618^Orange~92619^Orange~92620^Orange~92623^Orange~92624^Orange~92625^Orange~92626^Orange~92627^Orange~92628^Orange~92629^Orange~92630^Orange~92637^Orange~92646^Orange~92647^Orange~92648^Orange~92649^Orange~92650^Orange~92651^Orange~92652^Orange~92653^Orange~92654^Orange~92655^Orange~92656^Orange~92657^Orange~92658^Orange~92659^Orange~92660^Orange~92661^Orange~92662^Orange~92663^Orange~92672^Orange~92673^Orange~92674^Orange~92675^Orange~92676^Orange~92677^Orange~92678^Orange~92679^Orange~92683^Orange~92684^Orange~92685^Orange~92688^Orange~92690^Orange~92691^Orange~92692^Orange~92693^Orange~92694^Orange~92697^Orange~92698^Orange~92701^Orange~92702^Orange~92703^Orange~92704^Orange~92705^Orange~92706^Orange~92707^Orange~92708^Orange~92709^Orange~92710^Orange~92711^Orange~92712^Orange~92725^Orange~92728^Orange~92735^Orange~92780^Orange~92781^Orange~92782^Orange~92799^Orange~92801^Orange~92802^Orange~92803^Orange~92804^Orange~92805^Orange~92806^Orange~92807^Orange~92808^Orange~92809^Orange~92811^Orange~92812^Orange~92814^Orange~92815^Orange~92816^Orange~92817^Orange~92821^Orange~92822^Orange~92823^Orange~92825^Orange~92831^Orange~92832^Orange~92833^Orange~92834^Orange~92835^Orange~92836^Orange~92837^Orange~92838^Orange~92840^Orange~92841^Orange~92842^Orange~92843^Orange~92844^Orange~92845^Orange~92846^Orange~92850^Orange~92856^Orange~92857^Orange~92859^Orange~92860^Riverside~92861^Orange~92862^Orange~92863^Orange~92864^Orange~92865^Orange~92866^Orange~92867^Orange~92868^Orange~92869^Orange~92870^Orange~92871^Orange~92877^Riverside~92878^Riverside~92879^Riverside~92880^Riverside~92881^Riverside~92882^Riverside~92883^Riverside~92885^Orange~92886^Orange~92887^Orange~92899^Orange~93001^Ventura~93002^Ventura~93003^Ventura~93004^Ventura~93005^Ventura~93006^Ventura~93007^Ventura~93009^Ventura~93010^Ventura~93011^Ventura~93012^Ventura~93013^Santa Barbara~93014^Santa Barbara~93015^Ventura~93016^Ventura~93020^Ventura~93021^Ventura~93022^Ventura~93023^Ventura~93024^Ventura~93030^Ventura~93031^Ventura~93032^Ventura~93033^Ventura~93034^Ventura~93035^Ventura~93036^Ventura~93040^Ventura~93041^Ventura~93042^Ventura~93043^Ventura~93044^Ventura~93060^Ventura~93061^Ventura~93062^Ventura~93063^Ventura~93064^Ventura~93065^Ventura~93066^Ventura~93067^Santa Barbara~93093^Ventura~93094^Ventura~93099^Ventura~93101^Santa Barbara~93102^Santa Barbara~93103^Santa Barbara~93105^Santa Barbara~93106^Santa Barbara~93107^Santa Barbara~93108^Santa Barbara~93109^Santa Barbara~93110^Santa Barbara~93111^Santa Barbara~93116^Santa Barbara~93117^Santa Barbara~93118^Santa Barbara~93120^Santa Barbara~93121^Santa Barbara~93130^Santa Barbara~93140^Santa Barbara~93150^Santa Barbara~93160^Santa Barbara~93190^Santa Barbara~93199^Santa Barbara~93201^Tulare~93202^Kings~93203^Kern~93204^Kings~93205^Kern~93206^Kern~93207^Tulare~93208^Tulare~93210^Fresno~93212^Kings~93215^Kern~93216^Kern~93218^Tulare~93219^Tulare~93220^Kern~93221^Tulare~93222^Kern~93223^Tulare~93224^Kern~93225^Kern~93226^Kern~93227^Tulare~93230^Kings~93232^Kings~93234^Fresno~93235^Tulare~93237^Tulare~93238^Kern~93239^Kings~93240^Kern~93241^Kern~93242^Fresno~93243^Kern~93244^Tulare~93245^Kings~93246^Kings~93247^Tulare~93249^Kern~93250^Kern~93251^Kern~93252^Kern~93254^Santa Barbara~93255^Kern~93256^Tulare~93257^Tulare~93258^Tulare~93260^Tulare~93261^Tulare~93262^Tulare~93263^Kern~93265^Tulare~93266^Kings~93267^Tulare~93268^Kern~93270^Tulare~93271^Tulare~93272^Tulare~93274^Tulare~93275^Tulare~93276^Kern~93277^Tulare~93278^Tulare~93279^Tulare~93280^Kern~93282^Tulare~93283^Kern~93285^Kern~93286^Tulare~93287^Kern~93290^Tulare~93291^Tulare~93292^Tulare~93301^Kern~93302^Kern~93303^Kern~93304^Kern~93305^Kern~93306^Kern~93307^Kern~93308^Kern~93309^Kern~93311^Kern~93312^Kern~93313^Kern~93314^Kern~93380^Kern~93381^Kern~93382^Kern~93383^Kern~93384^Kern~93385^Kern~93386^Kern~93387^Kern~93388^Kern~93389^Kern~93390^Kern~93401^San Luis Obispo~93402^San Luis Obispo~93403^San Luis Obispo~93405^San Luis Obispo~93406^San Luis Obispo~93407^San Luis Obispo~93408^San Luis Obispo~93409^San Luis Obispo~93410^San Luis Obispo~93412^San Luis Obispo~93420^San Luis Obispo~93421^San Luis Obispo~93422^San Luis Obispo~93423^San Luis Obispo~93424^San Luis Obispo~93426^Monterey~93427^Santa Barbara~93428^San Luis Obispo~93429^Santa Barbara~93430^San Luis Obispo~93432^San Luis Obispo~93433^San Luis Obispo~93434^Santa Barbara~93435^San Luis Obispo~93436^Santa Barbara~93437^Santa Barbara~93438^Santa Barbara~93440^Santa Barbara~93441^Santa Barbara~93442^San Luis Obispo~93443^San Luis Obispo~93444^San Luis Obispo~93445^San Luis Obispo~93446^San Luis Obispo~93447^San Luis Obispo~93448^San Luis Obispo~93449^San Luis Obispo~93450^Monterey~93451^San Luis Obispo~93452^San Luis Obispo~93453^San Luis Obispo~93454^Santa Barbara~93455^Santa Barbara~93456^Santa Barbara~93457^Santa Barbara~93458^Santa Barbara~93460^Santa Barbara~93461^San Luis Obispo~93463^Santa Barbara~93464^Santa Barbara~93465^San Luis Obispo~93475^San Luis Obispo~93483^San Luis Obispo~93501^Kern~93502^Kern~93504^Kern~93505^Kern~93510^Los Angeles~93512^Mono~93513^Inyo~93514^Inyo~93515^Inyo~93516^Kern~93517^Mono~93518^Kern~93519^Kern~93522^Inyo~93523^Kern~93524^Kern~93526^Inyo~93527^Kern~93528^Kern~93529^Mono~93530^Inyo~93531^Kern~93532^Los Angeles~93534^Los Angeles~93535^Los Angeles~93536^Los Angeles~93539^Los Angeles~93541^Mono~93542^Inyo~93543^Los Angeles~93544^Los Angeles~93545^Inyo~93546^Mono~93549^Inyo~93550^Los Angeles~93551^Los Angeles~93552^Los Angeles~93553^Los Angeles~93554^Kern~93555^Kern~93556^Kern~93558^San Bernardino~93560^Kern~93561^Kern~93562^San Bernardino~93563^Los Angeles~93581^Kern~93584^Los Angeles~93586^Los Angeles~93590^Los Angeles~93591^Los Angeles~93592^San Bernardino~93596^Kern~93599^Los Angeles~93601^Madera~93602^Fresno~93603^Tulare~93604^Madera~93605^Fresno~93606^Fresno~93607^Fresno~93608^Fresno~93609^Fresno~93610^Madera~93611^Fresno~93612^Fresno~93613^Fresno~93614^Madera~93615^Tulare~93616^Fresno~93618^Tulare~93619^Fresno~93620^Merced~93621^Fresno~93622^Fresno~93623^Mariposa~93624^Fresno~93625^Fresno~93626^Fresno~93627^Fresno~93628^Fresno~93630^Fresno~93631^Fresno~93633^Tulare~93634^Fresno~93635^Merced~93636^Madera~93637^Madera~93638^Madera~93639^Madera~93640^Fresno~93641^Fresno~93642^Fresno~93643^Madera~93644^Madera~93645^Madera~93646^Fresno~93647^Tulare~93648^Fresno~93649^Fresno~93650^Fresno~93651^Fresno~93652^Fresno~93653^Madera~93654^Fresno~93656^Fresno~93657^Fresno~93660^Fresno~93661^Merced~93662^Fresno~93664^Fresno~93665^Merced~93666^Tulare~93667^Fresno~93668^Fresno~93669^Madera~93670^Tulare~93673^Tulare~93675^Fresno~93701^Fresno~93702^Fresno~93703^Fresno~93704^Fresno~93705^Fresno~93706^Fresno~93707^Fresno~93708^Fresno~93709^Fresno~93710^Fresno~93711^Fresno~93712^Fresno~93714^Fresno~93715^Fresno~93716^Fresno~93717^Fresno~93718^Fresno~93720^Fresno~93721^Fresno~93722^Fresno~93724^Fresno~93725^Fresno~93726^Fresno~93727^Fresno~93728^Fresno~93729^Fresno~93740^Fresno~93741^Fresno~93744^Fresno~93745^Fresno~93747^Fresno~93750^Fresno~93755^Fresno~93760^Fresno~93761^Fresno~93764^Fresno~93765^Fresno~93771^Fresno~93772^Fresno~93773^Fresno~93774^Fresno~93775^Fresno~93776^Fresno~93777^Fresno~93778^Fresno~93779^Fresno~93780^Fresno~93784^Fresno~93786^Fresno~93790^Fresno~93791^Fresno~93792^Fresno~93793^Fresno~93794^Fresno~93844^Fresno~93888^Fresno~93901^Monterey~93902^Monterey~93905^Monterey~93906^Monterey~93907^Monterey~93908^Monterey~93912^Monterey~93915^Monterey~93920^Monterey~93921^Monterey~93922^Monterey~93923^Monterey~93924^Monterey~93925^Monterey~93926^Monterey~93927^Monterey~93928^Monterey~93930^Monterey~93932^Monterey~93933^Monterey~93940^Monterey~93942^Monterey~93943^Monterey~93944^Monterey~93950^Monterey~93953^Monterey~93954^Monterey~93955^Monterey~93960^Monterey~93962^Monterey~94002^San Mateo~94005^San Mateo~94010^San Mateo~94011^San Mateo~94013^San Mateo~94014^San Mateo~94015^San Mateo~94016^San Mateo~94017^San Mateo~94018^San Mateo~94019^San Mateo~94020^San Mateo~94021^San Mateo~94022^Santa Clara~94023^Santa Clara~94024^Santa Clara~94025^San Mateo~94026^San Mateo~94027^San Mateo~94028^San Mateo~94030^San Mateo~94035^Santa Clara~94037^San Mateo~94038^San Mateo~94039^Santa Clara~94040^Santa Clara~94041^Santa Clara~94042^Santa Clara~94043^Santa Clara~94044^San Mateo~94060^San Mateo~94061^San Mateo~94062^San Mateo~94063^San Mateo~94064^San Mateo~94065^San Mateo~94066^San Mateo~94070^San Mateo~94074^San Mateo~94080^San Mateo~94083^San Mateo~94085^Santa Clara~94086^Santa Clara~94087^Santa Clara~94088^Santa Clara~94089^Santa Clara~94096^San Mateo~94098^San Mateo~94099^San Mateo~94101^San Francisco~94102^San Francisco~94103^San Francisco~94104^San Francisco~94105^San Francisco~94106^San Francisco~94107^San Francisco~94108^San Francisco~94109^San Francisco~94110^San Francisco~94111^San Francisco~94112^San Francisco~94114^San Francisco~94115^San Francisco~94116^San Francisco~94117^San Francisco~94118^San Francisco~94119^San Francisco~94120^San Francisco~94121^San Francisco~94122^San Francisco~94123^San Francisco~94124^San Francisco~94125^San Francisco~94126^San Francisco~94127^San Francisco~94128^San Mateo~94129^San Francisco~94130^San Francisco~94131^San Francisco~94132^San Francisco~94133^San Francisco~94134^San Francisco~94135^San Francisco~94136^San Francisco~94137^San Francisco~94138^San Francisco~94139^San Francisco~94140^San Francisco~94141^San Francisco~94142^San Francisco~94143^San Francisco~94144^San Francisco~94145^San Francisco~94146^San Francisco~94147^San Francisco~94150^San Francisco~94151^San Francisco~94152^San Francisco~94153^San Francisco~94154^San Francisco~94155^San Francisco~94156^San Francisco~94157^San Francisco~94158^San Francisco~94159^San Francisco~94160^San Francisco~94161^San Francisco~94162^San Francisco~94163^San Francisco~94164^San Francisco~94165^San Francisco~94166^San Francisco~94167^San Francisco~94168^San Francisco~94169^San Francisco~94170^San Francisco~94171^San Francisco~94172^San Francisco~94175^San Francisco~94177^San Francisco~94188^San Francisco~94199^San Francisco~94203^Sacramento~94204^Sacramento~94205^Sacramento~94206^Sacramento~94207^Sacramento~94208^Sacramento~94209^Sacramento~94211^Sacramento~94229^Sacramento~94230^Sacramento~94232^Sacramento~94234^Sacramento~94235^Sacramento~94236^Sacramento~94237^Sacramento~94239^Sacramento~94240^Sacramento~94243^Sacramento~94244^Sacramento~94245^Sacramento~94246^Sacramento~94247^Sacramento~94248^Sacramento~94249^Sacramento~94250^Sacramento~94252^Sacramento~94253^Sacramento~94254^Sacramento~94256^Sacramento~94257^Sacramento~94258^Sacramento~94259^Sacramento~94261^Sacramento~94262^Sacramento~94263^Sacramento~94267^Sacramento~94268^Sacramento~94269^Sacramento~94271^Sacramento~94273^Sacramento~94274^Sacramento~94277^Sacramento~94278^Sacramento~94279^Sacramento~94280^Sacramento~94282^Sacramento~94283^Sacramento~94284^Sacramento~94285^Sacramento~94286^Sacramento~94287^Sacramento~94288^Sacramento~94289^Sacramento~94290^Sacramento~94291^Sacramento~94293^Sacramento~94294^Sacramento~94295^Sacramento~94296^Sacramento~94297^Sacramento~94298^Sacramento~94299^Sacramento~94301^Santa Clara~94302^Santa Clara~94303^Santa Clara~94304^Santa Clara~94305^Santa Clara~94306^Santa Clara~94309^Santa Clara~94401^San Mateo~94402^San Mateo~94403^San Mateo~94404^San Mateo~94497^San Mateo~94501^Alameda~94502^Alameda~94503^Napa~94506^Contra Costa~94507^Contra Costa~94508^Napa~94509^Contra Costa~94510^Solano~94511^Contra Costa~94512^Solano~94513^Contra Costa~94514^Contra Costa~94515^Napa~94516^Contra Costa~94517^Contra Costa~94518^Contra Costa~94519^Contra Costa~94520^Contra Costa~94521^Contra Costa~94522^Contra Costa~94523^Contra Costa~94524^Contra Costa~94525^Contra Costa~94526^Contra Costa~94527^Contra Costa~94528^Contra Costa~94529^Contra Costa~94530^Contra Costa~94531^Contra Costa~94533^Solano~94534^Solano~94535^Solano~94536^Alameda~94537^Alameda~94538^Alameda~94539^Alameda~94540^Alameda~94541^Alameda~94542^Alameda~94543^Alameda~94544^Alameda~94545^Alameda~94546^Alameda~94547^Contra Costa~94548^Contra Costa~94549^Contra Costa~94550^Alameda~94551^Alameda~94552^Alameda~94553^Contra Costa~94555^Alameda~94556^Contra Costa~94557^Alameda~94558^Napa~94559^Napa~94560^Alameda~94561^Contra Costa~94562^Napa~94563^Contra Costa~94564^Contra Costa~94565^Contra Costa~94566^Alameda~94567^Napa~94568^Alameda~94569^Contra Costa~94570^Contra Costa~94571^Solano~94572^Contra Costa~94573^Napa~94574^Napa~94575^Contra Costa~94576^Napa~94577^Alameda~94578^Alameda~94579^Alameda~94580^Alameda~94581^Napa~94582^Contra Costa~94583^Contra Costa~94585^Solano~94586^Alameda~94587^Alameda~94588^Alameda~94589^Solano~94590^Solano~94591^Solano~94592^Solano~94595^Contra Costa~94596^Contra Costa~94597^Contra Costa~94598^Contra Costa~94599^Napa~94601^Alameda~94602^Alameda~94603^Alameda~94604^Alameda~94605^Alameda~94606^Alameda~94607^Alameda~94608^Alameda~94609^Alameda~94610^Alameda~94611^Alameda~94612^Alameda~94613^Alameda~94614^Alameda~94615^Alameda~94617^Alameda~94618^Alameda~94619^Alameda~94620^Alameda~94621^Alameda~94622^Alameda~94623^Alameda~94624^Alameda~94625^Alameda~94627^Alameda~94643^Alameda~94649^Alameda~94659^Alameda~94660^Alameda~94661^Alameda~94662^Alameda~94666^Alameda~94701^Alameda~94702^Alameda~94703^Alameda~94704^Alameda~94705^Alameda~94706^Alameda~94707^Alameda~94708^Alameda~94709^Alameda~94710^Alameda~94712^Alameda~94720^Alameda~94801^Contra Costa~94802^Contra Costa~94803^Contra Costa~94804^Contra Costa~94805^Contra Costa~94806^Contra Costa~94807^Contra Costa~94808^Contra Costa~94820^Contra Costa~94850^Contra Costa~94875^Contra Costa~94901^Marin~94903^Marin~94904^Marin~94912^Marin~94913^Marin~94914^Marin~94915^Marin~94920^Marin~94922^Sonoma~94923^Sonoma~94924^Marin~94925^Marin~94926^Sonoma~94927^Sonoma~94928^Sonoma~94929^Marin~94930^Marin~94931^Sonoma~94933^Marin~94937^Marin~94938^Marin~94939^Marin~94940^Marin~94941^Marin~94942^Marin~94945^Marin~94946^Marin~94947^Marin~94948^Marin~94949^Marin~94950^Marin~94951^Sonoma~94952^Sonoma~94953^Sonoma~94954^Sonoma~94955^Sonoma~94956^Marin~94957^Marin~94960^Marin~94963^Marin~94964^Marin~94965^Marin~94966^Marin~94970^Marin~94971^Marin~94972^Sonoma~94973^Marin~94974^Marin~94975^Sonoma~94976^Marin~94977^Marin~94978^Marin~94979^Marin~94998^Marin~94999^Sonoma~95001^Santa Cruz~95002^Santa Clara~95003^Santa Cruz~95004^Monterey~95005^Santa Cruz~95006^Santa Cruz~95007^Santa Cruz~95008^Santa Clara~95009^Santa Clara~95010^Santa Cruz~95011^Santa Clara~95012^Monterey~95013^Santa Clara~95014^Santa Clara~95015^Santa Clara~95017^Santa Cruz~95018^Santa Cruz~95019^Santa Cruz~95020^Santa Clara~95021^Santa Clara~95023^San Benito~95024^San Benito~95026^Santa Clara~95030^Santa Clara~95031^Santa Clara~95032^Santa Clara~95033^Santa Cruz~95035^Santa Clara~95036^Santa Clara~95037^Santa Clara~95038^Santa Clara~95039^Monterey~95041^Santa Cruz~95042^Santa Clara~95043^San Benito~95044^Santa Clara~95045^San Benito~95046^Santa Clara~95050^Santa Clara~95051^Santa Clara~95052^Santa Clara~95053^Santa Clara~95054^Santa Clara~95055^Santa Clara~95056^Santa Clara~95060^Santa Cruz~95061^Santa Cruz~95062^Santa Cruz~95063^Santa Cruz~95064^Santa Cruz~95065^Santa Cruz~95066^Santa Cruz~95067^Santa Cruz~95070^Santa Clara~95071^Santa Clara~95073^Santa Cruz~95075^San Benito~95076^Santa Cruz~95077^Santa Cruz~95101^Santa Clara~95102^Santa Clara~95103^Santa Clara~95106^Santa Clara~95108^Santa Clara~95109^Santa Clara~95110^Santa Clara~95111^Santa Clara~95112^Santa Clara~95113^Santa Clara~95114^Santa Clara~95115^Santa Clara~95116^Santa Clara~95117^Santa Clara~95118^Santa Clara~95119^Santa Clara~95120^Santa Clara~95121^Santa Clara~95122^Santa Clara~95123^Santa Clara~95124^Santa Clara~95125^Santa Clara~95126^Santa Clara~95127^Santa Clara~95128^Santa Clara~95129^Santa Clara~95130^Santa Clara~95131^Santa Clara~95132^Santa Clara~95133^Santa Clara~95134^Santa Clara~95135^Santa Clara~95136^Santa Clara~95137^Santa Clara~95138^Santa Clara~95139^Santa Clara~95140^Santa Clara~95141^Santa Clara~95142^Santa Clara~95148^Santa Clara~95150^Santa Clara~95151^Santa Clara~95152^Santa Clara~95153^Santa Clara~95154^Santa Clara~95155^Santa Clara~95156^Santa Clara~95157^Santa Clara~95158^Santa Clara~95159^Santa Clara~95160^Santa Clara~95161^Santa Clara~95164^Santa Clara~95170^Santa Clara~95171^Santa Clara~95172^Santa Clara~95173^Santa Clara~95190^Santa Clara~95191^Santa Clara~95192^Santa Clara~95193^Santa Clara~95194^Santa Clara~95196^Santa Clara~95201^San Joaquin~95202^San Joaquin~95203^San Joaquin~95204^San Joaquin~95205^San Joaquin~95206^San Joaquin~95207^San Joaquin~95208^San Joaquin~95209^San Joaquin~95210^San Joaquin~95211^San Joaquin~95212^San Joaquin~95213^San Joaquin~95215^San Joaquin~95219^San Joaquin~95220^San Joaquin~95221^Calaveras~95222^Calaveras~95223^Calaveras~95224^Calaveras~95225^Calaveras~95226^Calaveras~95227^San Joaquin~95228^Calaveras~95229^Calaveras~95230^San Joaquin~95231^San Joaquin~95232^Calaveras~95233^Calaveras~95234^San Joaquin~95236^San Joaquin~95237^San Joaquin~95240^San Joaquin~95241^San Joaquin~95242^San Joaquin~95245^Calaveras~95246^Calaveras~95247^Calaveras~95248^Calaveras~95249^Calaveras~95250^Calaveras~95251^Calaveras~95252^Calaveras~95253^San Joaquin~95254^Calaveras~95255^Calaveras~95257^Calaveras~95258^San Joaquin~95267^San Joaquin~95269^San Joaquin~95296^San Joaquin~95297^San Joaquin~95301^Merced~95303^Merced~95304^San Joaquin~95305^Tuolumne~95306^Mariposa~95307^Stanislaus~95309^Tuolumne~95310^Tuolumne~95311^Mariposa~95312^Merced~95313^Stanislaus~95314^Tuolumne~95315^Merced~95316^Stanislaus~95317^Merced~95318^Mariposa~95319^Stanislaus~95320^San Joaquin~95321^Tuolumne~95322^Merced~95323^Stanislaus~95324^Merced~95325^Mariposa~95326^Stanislaus~95327^Tuolumne~95328^Stanislaus~95329^Stanislaus~95330^San Joaquin~95333^Merced~95334^Merced~95335^Tuolumne~95336^San Joaquin~95337^San Joaquin~95338^Mariposa~95340^Merced~95341^Merced~95342^Merced~95343^Merced~95344^Merced~95345^Mariposa~95346^Tuolumne~95347^Tuolumne~95348^Merced~95350^Stanislaus~95351^Stanislaus~95352^Stanislaus~95353^Stanislaus~95354^Stanislaus~95355^Stanislaus~95356^Stanislaus~95357^Stanislaus~95358^Stanislaus~95360^Stanislaus~95361^Stanislaus~95363^Stanislaus~95364^Tuolumne~95365^Merced~95366^San Joaquin~95367^Stanislaus~95368^Stanislaus~95369^Merced~95370^Tuolumne~95372^Tuolumne~95373^Tuolumne~95374^Merced~95375^Tuolumne~95376^San Joaquin~95377^San Joaquin~95378^San Joaquin~95379^Tuolumne~95380^Stanislaus~95381^Stanislaus~95382^Stanislaus~95383^Tuolumne~95385^San Joaquin~95386^Stanislaus~95387^Stanislaus~95388^Merced~95389^Mariposa~95391^San Joaquin~95397^Stanislaus~95401^Sonoma~95402^Sonoma~95403^Sonoma~95404^Sonoma~95405^Sonoma~95406^Sonoma~95407^Sonoma~95408^Sonoma~95409^Sonoma~95410^Mendocino~95412^Sonoma~95415^Mendocino~95416^Sonoma~95417^Mendocino~95418^Mendocino~95419^Sonoma~95420^Mendocino~95421^Sonoma~95422^Lake~95423^Lake~95424^Lake~95425^Sonoma~95426^Lake~95427^Mendocino~95428^Mendocino~95429^Mendocino~95430^Sonoma~95431^Sonoma~95432^Mendocino~95433^Sonoma~95435^Lake~95436^Sonoma~95437^Mendocino~95439^Sonoma~95441^Sonoma~95442^Sonoma~95443^Lake~95444^Sonoma~95445^Mendocino~95446^Sonoma~95448^Sonoma~95449^Mendocino~95450^Sonoma~95451^Lake~95452^Sonoma~95453^Lake~95454^Mendocino~95456^Mendocino~95457^Lake~95458^Lake~95459^Mendocino~95460^Mendocino~95461^Lake~95462^Sonoma~95463^Mendocino~95464^Lake~95465^Sonoma~95466^Mendocino~95467^Lake~95468^Mendocino~95469^Mendocino~95470^Mendocino~95471^Sonoma~95472^Sonoma~95473^Sonoma~95476^Sonoma~95480^Sonoma~95481^Mendocino~95482^Mendocino~95485^Lake~95486^Sonoma~95487^Sonoma~95488^Mendocino~95490^Mendocino~95492^Sonoma~95493^Lake~95494^Mendocino~95497^Sonoma~95501^Humboldt~95502^Humboldt~95503^Humboldt~95511^Humboldt~95514^Humboldt~95518^Humboldt~95519^Humboldt~95521^Humboldt~95524^Humboldt~95525^Humboldt~95526^Humboldt~95527^Trinity~95528^Humboldt~95531^Del Norte~95532^Del Norte~95534^Humboldt~95536^Humboldt~95537^Humboldt~95538^Del Norte~95540^Humboldt~95542^Humboldt~95543^Del Norte~95545^Humboldt~95546^Humboldt~95547^Humboldt~95548^Del Norte~95549^Humboldt~95550^Humboldt~95551^Humboldt~95552^Trinity~95553^Humboldt~95554^Humboldt~95555^Humboldt~95556^Humboldt~95558^Humboldt~95559^Humboldt~95560^Humboldt~95562^Humboldt~95563^Trinity~95564^Humboldt~95565^Humboldt~95567^Del Norte~95568^Siskiyou~95569^Humboldt~95570^Humboldt~95571^Humboldt~95573^Humboldt~95585^Mendocino~95587^Mendocino~95589^Humboldt~95595^Trinity~95601^Amador~95602^Placer~95603^Placer~95604^Placer~95605^Yolo~95606^Yolo~95607^Yolo~95608^Sacramento~95609^Sacramento~95610^Sacramento~95611^Sacramento~95612^Yolo~95613^El Dorado~95614^El Dorado~95615^Sacramento~95616^Yolo~95617^Yolo~95618^Yolo~95619^El Dorado~95620^Solano~95621^Sacramento~95623^El Dorado~95624^Sacramento~95625^Solano~95626^Sacramento~95627^Yolo~95628^Sacramento~95629^Amador~95630^Sacramento~95631^Placer~95632^Sacramento~95633^El Dorado~95634^El Dorado~95635^El Dorado~95636^El Dorado~95637^Yolo~95638^Sacramento~95639^Sacramento~95640^Amador~95641^Sacramento~95642^Amador~95644^Amador~95645^Yolo~95646^Alpine~95648^Placer~95650^Placer~95651^El Dorado~95652^Sacramento~95653^Yolo~95654^Amador~95655^Sacramento~95656^El Dorado~95658^Placer~95659^Sutter~95660^Sacramento~95661^Placer~95662^Sacramento~95663^Placer~95664^El Dorado~95665^Amador~95666^Amador~95667^El Dorado~95668^Sutter~95669^Amador~95670^Sacramento~95671^Sacramento~95672^El Dorado~95673^Sacramento~95674^Sutter~95675^Amador~95676^Sutter~95677^Placer~95678^Placer~95679^Yolo~95680^Sacramento~95681^Placer~95682^El Dorado~95683^Sacramento~95684^El Dorado~95685^Amador~95686^San Joaquin~95687^Solano~95688^Solano~95689^Amador~95690^Sacramento~95691^Yolo~95692^Yuba~95693^Sacramento~95694^Yolo~95695^Yolo~95696^Solano~95697^Yolo~95698^Yolo~95699^Amador~95701^Placer~95703^Placer~95709^El Dorado~95712^Nevada~95713^Placer~95714^Placer~95715^Placer~95717^Placer~95720^El Dorado~95721^El Dorado~95722^Placer~95724^Nevada~95726^El Dorado~95728^Nevada~95735^El Dorado~95736^Placer~95741^Sacramento~95742^Sacramento~95743^Sacramento~95746^Placer~95747^Placer~95757^Sacramento~95758^Sacramento~95759^Sacramento~95762^El Dorado~95763^Sacramento~95765^Placer~95776^Yolo~95798^Yolo~95799^Yolo~95811^Sacramento~95812^Sacramento~95813^Sacramento~95814^Sacramento~95815^Sacramento~95816^Sacramento~95817^Sacramento~95818^Sacramento~95819^Sacramento~95820^Sacramento~95821^Sacramento~95822^Sacramento~95823^Sacramento~95824^Sacramento~95825^Sacramento~95826^Sacramento~95827^Sacramento~95828^Sacramento~95829^Sacramento~95830^Sacramento~95831^Sacramento~95832^Sacramento~95833^Sacramento~95834^Sacramento~95835^Sacramento~95836^Sacramento~95837^Sacramento~95838^Sacramento~95840^Sacramento~95841^Sacramento~95842^Sacramento~95843^Sacramento~95851^Sacramento~95852^Sacramento~95853^Sacramento~95857^Sacramento~95860^Sacramento~95864^Sacramento~95865^Sacramento~95866^Sacramento~95867^Sacramento~95887^Sacramento~95894^Sacramento~95899^Sacramento~95901^Yuba~95903^Yuba~95910^Sierra~95912^Colusa~95913^Glenn~95914^Butte~95915^Plumas~95916^Butte~95917^Butte~95918^Yuba~95919^Yuba~95920^Glenn~95922^Yuba~95923^Plumas~95924^Nevada~95925^Yuba~95926^Butte~95927^Butte~95928^Butte~95929^Butte~95930^Butte~95932^Colusa~95934^Plumas~95935^Yuba~95936^Sierra~95937^Yolo~95938^Butte~95939^Glenn~95940^Butte~95941^Butte~95942^Butte~95943^Glenn~95944^Sierra~95945^Nevada~95946^Nevada~95947^Plumas~95948^Butte~95949^Nevada~95950^Colusa~95951^Glenn~95953^Sutter~95954^Butte~95955^Colusa~95956^Plumas~95957^Sutter~95958^Butte~95959^Nevada~95960^Nevada~95961^Yuba~95962^Yuba~95963^Glenn~95965^Butte~95966^Butte~95967^Butte~95968^Butte~95969^Butte~95970^Colusa~95971^Plumas~95972^Yuba~95973^Butte~95974^Butte~95975^Nevada~95976^Butte~95977^Nevada~95978^Butte~95979^Colusa~95980^Plumas~95981^Yuba~95982^Sutter~95983^Plumas~95984^Plumas~95986^Nevada~95987^Colusa~95988^Glenn~95991^Sutter~95992^Sutter~95993^Sutter~96001^Shasta~96002^Shasta~96003^Shasta~96006^Modoc~96007^Shasta~96008^Shasta~96009^Lassen~96010^Trinity~96011^Shasta~96013^Shasta~96014^Siskiyou~96015^Modoc~96016^Shasta~96017^Shasta~96019^Shasta~96020^Plumas~96021^Tehama~96022^Shasta~96023^Siskiyou~96024^Trinity~96025^Siskiyou~96027^Siskiyou~96028^Shasta~96029^Tehama~96031^Siskiyou~96032^Siskiyou~96033^Shasta~96034^Siskiyou~96035^Tehama~96037^Siskiyou~96038^Siskiyou~96039^Siskiyou~96040^Shasta~96041^Trinity~96044^Siskiyou~96046^Trinity~96047^Shasta~96048^Trinity~96049^Shasta~96050^Siskiyou~96051^Shasta~96052^Trinity~96054^Modoc~96055^Tehama~96056^Lassen~96057^Siskiyou~96058^Siskiyou~96059^Tehama~96061^Tehama~96062^Shasta~96063^Tehama~96064^Siskiyou~96065^Shasta~96067^Siskiyou~96068^Lassen~96069^Shasta~96070^Shasta~96071^Shasta~96073^Shasta~96074^Tehama~96075^Tehama~96076^Shasta~96078^Tehama~96079^Shasta~96080^Tehama~96084^Shasta~96085^Siskiyou~96086^Siskiyou~96087^Shasta~96088^Shasta~96089^Shasta~96090^Tehama~96091^Trinity~96092^Tehama~96093^Trinity~96094^Siskiyou~96095^Shasta~96096^Shasta~96097^Siskiyou~96099^Shasta~96101^Modoc~96103^Plumas~96104^Modoc~96105^Plumas~96106^Plumas~96107^Mono~96108^Modoc~96109^Lassen~96110^Modoc~96111^Nevada~96112^Modoc~96113^Lassen~96114^Lassen~96115^Modoc~96116^Modoc~96117^Lassen~96118^Sierra~96119^Lassen~96120^Alpine~96121^Lassen~96122^Plumas~96123^Lassen~96124^Sierra~96125^Sierra~96126^Sierra~96127^Lassen~96128^Lassen~96129^Plumas~96130^Lassen~96132^Lassen~96133^Mono~96134^Siskiyou~96135^Plumas~96136^Lassen~96137^Plumas~96140^Placer~96141^Placer~96142^El Dorado~96143^Placer~96145^Placer~96146^Placer~96148^Placer~96150^El Dorado~96151^El Dorado~96152^El Dorado~96154^El Dorado~96155^El Dorado~96156^El Dorado~96157^El Dorado~96158^El Dorado~96160^Nevada~96161^Nevada~96162^Nevada";
    $pairlist = explode('~',$pairs);
    for ($i=0;$i<count($pairlist);$i++) {
        $pair = $pairlist[$i];
        $pair = explode('^',$pair);  
        if ($pair[0] === $emplrzip) {
            return($pair[1]);
        }
    }
}

function getarea($emplrzip,$emplrcounty) {
      if ($emplrcounty === "Los Angeles") {

          

         $tzip = substr($emplrzip,0,3);

         if ($tzip==="900"||$tzip==="901"||$tzip==="902"||$tzip==="903"||$tzip==="904"||$tzip==="905"||$tzip==="913"||$tzip==="914"||$tzip==="916") {
             return '16';
         } else {
             return '15';
         }
      }    
    if ($emplrcounty !== 'Los Angeles') {
      $area1 = array("Alpine","Del Norte","Siskiyou","Modoc","Lassen","Shasta","Trinity","Humboldt","Tehama","Plumas","Nevada","Sierra","Mendocino","Lake","Butte","Glenn","Sutter","Alpine","Yuba","Colusa","Amador","Calaveras","Tuolumne");  //put area 1 counties in this array
      if (in_array($emplrcounty,$area1)) {
          return "1";
      }
      if ($emplrcounty === "Napa"||$emplrcounty === "Sonoma"||$emplrcounty === "Solano"||$emplrcounty === "Marin") {
          return "2";
      }
      if ($emplrcounty === "Sacramento"||$emplrcounty === "Placer"||$emplrcounty === "El Dorado"||$emplrcounty === "Yolo") {
          return "3";
      }      
      if ($emplrcounty === "San Francisco") {
          return "4";
      }
      if ($emplrcounty === "Contra Costa") {
          return "5";
      } 
      if ($emplrcounty === "Alameda") {
          return "6";
      }  
      if ($emplrcounty === "Santa Clara") {
          return "7";
      } 
      if ($emplrcounty === "San Mateo") {
          return "8";
      } 
      if ($emplrcounty === "Santa Cruz"||$emplrcounty === "Monterey"||$emplrcounty === "San Benito") {
          return "9";
      } 
      if ($emplrcounty === "San Joaquin"||$emplrcounty === "Stanislaus"||$emplrcounty === "Merced"||$emplrcounty === "Mariposa"||$emplrcounty === "Tulare") {
          return "10";
      } 
      if ($emplrcounty === "Fresno"||$emplrcounty === "Kings"||$emplrcounty === "Madera") {
          return "11";
      } 
      if ($emplrcounty === "San Luis Obispo"||$emplrcounty === "Ventura"||$emplrcounty === "Santa Barbara") {
          return "12";
      }  
      if ($emplrcounty === "Mono"||$emplrcounty === "Inyo"||$emplrcounty === "Imperial") {
          return "13";
      } 
      if ($emplrcounty === "Kern") {
          return "14";
      }

      
      
      
     if ($emplrcounty === "Riverside"||$emplrcounty === "San Bernardino") {
          return "17";
      }
      if ($emplrcounty === "Orange") {
          return "18";
      }
      if ($emplrcounty === "San Diego") {
          return "19";
      } 
  }
}
function savecensusmeta($agentpath,$emplrname,$emplrzip,$effmonth,$effyear) {
    $emplrcounty = getemplrcounty($emplrzip);
    $emplrarea = getarea($emplrzip,$emplrcounty);
    //$servername = "localhost";
    //$username = "zapquot1_frank";
    //$password = "gardner521";
    //$dbname = "zapquot1_census";
    $servername = "localhost";
    $username = "root";
    $password = "gardner521";
    $dbname = "census";
    if (file_exists ("/xampp/runningLocal/runningLocal")) {   
    $servername = "localhost";
    $username = "root";
    $password = "Hos^zap521soH";
    $dbname = "census";
    }
    
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    //echo "Connected successfully";
    $sql = "INSERT INTO censi(agentpath,emplrname,emplrzip,emplrarea,effmonth,effyear) VALUES ('$agentpath','$emplrname','$emplrzip','$emplrarea','$effmonth','$effyear')";
if ($conn->query($sql) !== TRUE) {
    echo "Error: ".$sql.'<br>'.$conn->error;
} 
  $quotenum = mysqli_insert_id($conn);
  $conn->close;
  return($quotenum);
}



function mkcenform($agentpath,$emplrname,$emplrzip,$effmonth,$effyear,$eecount,$quotenum) {
    //echo '-----------------------------------'.$quotenum.'----------------------------';
    $emplrcounty = getemplrcounty($emplrzip);
    $emplrarea = getarea($emplrzip,$emplrcounty);
    $eecount = (int)$eecount;
    
    echo '<form method="post">';
    echo '<table>'.chr(10);
    echo '<tr><td>Employee Name</td><td>DOB or Age</td><td>Spouse</td><td>Child Dobs/ages (separate with commas)</td></tr>'.chr(10);
    for ($i=0;$i<$eecount;$i++) {
        $j = $i + 1;
        echo '<tr><td>'.$j.'<input type="text" name="eename'.$j.'" id="eename'.$j.'" value=""></td>'.chr(10);
        echo '<td><input type="text" name="eedob'.$j.'" id="eedob'.$j.'" value="" size="8"></td>'.chr(10);
        echo '<td><input type="text" name="spdob'.$j.'" id="spdob'.$j.'" value="" size="8"></td>'.chr(10);
        echo '<td><input type="text" name="chdob'.$j.'" id="chdob'.$j.'" value="" size="45"></td></tr>'.chr(10);

    }
    
    echo '</table>'.chr(10);
    echo '<input type="hidden" name="agentpath" value="'.$agentpath.'">';
    echo '<input type="hidden" name="emplrname" value="'.$emplrname.'">';    
    echo '<input type="hidden" name="emplrzip" value="'.$emplrzip.'">';    
    echo '<input type="hidden" name="effmonth" value="'.$effmonth.'">';
    echo '<input type="hidden" name="effyear" value="'.$effyear.'">';
    echo '<input type="hidden" name="eecount" value="'.$eecount.'">';    
    echo '<input type="hidden" name="emplrarea" value="'.$emplrarea.'">';  
    echo '<input type="hidden" name="quotenum" value="'.$quotenum.'">';
    echo '<input type="submit" name="submit" value="Submit">'.chr(10);
    //echo '<br>'.$quotenum;
    echo '</form>'.chr(10);
    //echo '<script>';
    //echo 'sessionStorage.setItem("quotenum",'.$quotenum.')'.chr(10);
    //echo '</script>'.chr(10);
}

function mkcensusdir($agentpath,$quotenum) {
    if (!is_dir('../homepage/group/'.$agentpath)) {
        mkdir('../homepage/group/'.$agentpath);
    } 
    mkdir('../homepage/group/'.$agentpath.'/'.$quotenum);
}

function mkcenrequest($agentpath) {
    if (file_exists ("/xampp/runningLocal/runningLocal")) {   
        $thisdomain = 'localhost';
    } else {
        $thisdomain = 'zapquotes.com';
    }
  if (!isset($_POST['emplrzip'])) {
      //echo 'agentpat '.$agentpath;
echo '<div id="newcenform">';
    echo '<form method="post">'.chr(10);
    echo '<input type="hidden" name="hidquotenum" id="hidquotenum">'.chr(10);
    echo '<h1>Select an Option</h1><hr><h2>Add Census</h2>Business name<input type="text" name="emplrname" id="emplrname" onblur="setemplrname(this.value)"><br>'.chr(10);
    echo 'Effective date<select name="effmonth" onchange="seteffmonth(this.value)"><option value="#"></option><option value="1">January</option><option value="2">February</option><option value="3">March</option><option value="4">April</option><option value="5">May</option><option value="6">June</option><option value="7">July</option><option value="8">August</option><option value="9">September</option><option value="10">October</option><option value="11">November</option><option value="12">December</option>'.chr(10);
    //echo '</select><select name="effyear" id="effyear" onchange="seteffyear(this.value)"><option value="#"></option><option value="2020">2020</option><option value="2021">2021</option><option value="2022">2022</option></select><br>'.chr(10);
    echo '</select><select name="effyear" id="effyear" onchange="seteffyear(this.value)"><option value="#"></option><option value="2024">2024</option><option value="2025">2025</option><option value="2026">2026</option><option value="2027">2027</option></select><br>'.chr(10);
   
    echo 'Employer zip code<input type="text" name="emplrzip" id="emplrzip" onblur="setemplrzip(this.value)" size="5"><br>'.chr(10);
    echo 'Employee count<input type="text" id="eecount" name="eecount" onblur="seteecount(this.value)" size="2">'.chr(10);
    echo '<input type="hidden" name="agentpath" value="'.$agentpath.'"><p>'.chr(10);
    echo '<input type="hidden" name="mkcenform" value="yes"><p>'.chr(10);
    echo '<input type="submit" name="submit" value="submit"><p>'.chr(10);
    //include "setagentinf.php";    //===================================================================================================================include setagentinf.php================
    echo '</form>';
echo '</div>';
    //close form after javascript adds more hidden fields

echo '<div id="recallcen">';
    echo '<a href="https://'.$thisdomain.'/group/recall.php/?agentpath='.$agentpath.'">Recall Census</a>';
echo '</div>';

echo '<div id="deletecen" style="margin-top:8px;">';
    echo '<a href="https://'.$thisdomain.'/group/deletecen.php/?agentpath='.$agentpath.'&delform=mkdelform">Delete Census</a>';
echo '</div>';



  } 
}

if (isset($_POST['newcen'])) {
    $agentpath = $_POST['agentpath'];
    echo '<div id="cenreqleft">';
    mkcenrequest($agentpath);
    echo '</div>';
    //echo '<div id="cenreqright" style="border:3px solid orange;float:left;">';
    //echo 'group1<br>'; echo 'group2<br>'; echo 'group3<br>'; echo 'group4<br>';
    //include "recall.php";
    
    
    
    //echo '</div>';
}





//launched by hidden variable (mkcenform) from 2nd screen when 3rd screem opens
if (isset($_POST['mkcenform'])) {      //meta data for census already entered so now make a census form
    $agentpath = $_POST['agentpath'];
    $emplrname = $_POST['emplrname'];
    $emplrzip = $_POST['emplrzip'];
    $effmonth = $_POST['effmonth'];
    $effyear = $_POST['effyear'];
    $eecount = $_POST['eecount'];
    $quotenum = savecensusmeta($agentpath,$emplrname,$emplrzip,$effmonth,$effyear);
    mkcensusdir($agentpath,$quotenum);
    mkcenform($agentpath,$emplrname,$emplrzip,$effmonth,$effyear,$eecount,$quotenum);
}

echo '<script src="https://'.$thisdomain.'/group/grpcensus.js"></script>';

//if (isset($_POST['quotenum'])) {
//    echo 'post quotenum is set';
//}

//-----------------------------------------------------------------------------
function savecensus($agentpath,$quotenum,$emplrname) {
    $agentpath = $_POST['agentpath'];
    $quotenum = $_POST['quotenum'];
    $eecount = $_POST['eecount'];
    $eecount = (int)$eecount;
    //$servername = "localhost";
    //$username = "zapquot1_frank";
    //$password = "gardner521";
    //$dbname = "zapquot1_census";
    
    $servername = "localhost";
    $username = "root";
    $password = "gardner521";
    $dbname = "census";
    if (file_exists ("/xampp/runningLocal/runningLocal")) {   
    $servername = "localhost";
    $username = "root";
    $password = "Hos^zap521soH";
    $dbname = "census";
    }    
    
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
 
for ($i=1;$i<=$eecount;$i++) {
    $tkey = 'eename'.$i;
    $eename = $_POST[$tkey];
    $tkey = 'eedob'.$i;
    $dob = $_POST[$tkey];
    $tkey = 'spdob'.$i;
    $spdob = $_POST[$tkey];
    $tkey = 'chdob'.$i;
    $chdob = $_POST[$tkey];   
    
    
    $sql = "INSERT INTO ees(agentpath,quotenum,emplrname,eename,dob,spdob,chdob) VALUES ('$agentpath','$quotenum','$emplrname','$eename','$dob','$spdob','$chdob')";

    if ($conn->query($sql) !== TRUE) {
    echo "Error: ".$sql.'<br>'.$conn->error;
    }
  mysqli_insert_id($conn);
} 
  $conn->close;   
}


if (isset($_POST['quotenum'])) {
    include "setrates.php";
    savecensus($agentpath,$quotenum,$emplrname);
    mkratedict($agentpath,$emplrarea,$effmonth,$effyear);
    //setcenrates($agentpath,$quotenum);
    
    
    
}

echo '</body></html>';
