<%
include "tools/database.php";
include "tools/tools6.php";
session_start();
if (! isset($_SESSION["NI"]))
  {
  if (isset($_POST["nationalId"]))
    {
    $check_ni=check_national_code($_POST["nationalId"]);
    if ($check_ni==1)
      {
      $cert=get_row("SELECT Id, result FROM CertRequest WHERE nationalId='{$_POST["nationalId"]}'","Id");
      $id=$cert["Id"];
      if ($id)
        {
        $_SESSION["NI"]=$_POST["nationalId"];
        $_SESSION["FOUND"]=true;
        if ($cert["result"]==0)
          {
          header("Location: certificate-register.php");
          exit();
          }
        else if ($cert["result"]==1)
          {
          unset($_SESSION["NI"]);
          unset($_SESSION["FOUND"]);
          $step=41;
          $error=0;
          }
        else if ($cert["result"]==2)
          {
          unset($_SESSION["NI"]);
          unset($_SESSION["FOUND"]);
          $step=42;
          $error=0;
          }
        }
      else
        {
        $_SESSION["NI"]=$_POST["nationalId"];
        $_SESSION["FOUND"]=false;
        header("Location: certificate-register.php");
        exit();
        }
      }
    else if ($check_ni==-1)
      {
      $step=1;
      $error=1;
      $message="خطا: لطفا کد ملی خود را فقط با اعداد انگلیسی وارد نمایید.";
      }
    else
      {
      $step=1;
      $error=1;
      $message="خطا: کد ملی معتبر نیست.";
      }
    }
  else
    {
    $step=1;
    $error=0;
    }
  }
else
  {
  if ($_POST["_submitted_"])
    {
    $check=check_post_validity($_POST);
    if ($check)
      {
      if ($_SESSION["FOUND"])
        {
        update($_POST);
        $step=32;
        $error=0;
        unset($_SESSION["NI"]);
        unset($_SESSION["FOUND"]);
        }
      else
        {
        insert($_POST);
        $step=31;
        $error=0;
        unset($_SESSION["NI"]);
        unset($_SESSION["FOUND"]);
        }
      }
    else
      {
      if ($_SESSION["FOUND"])
        {
        $step=23;
        $error=1;
        }
      else
        {
        $step=21;
        $error=1;
        }
      }
    }
  else
    {
    if ($_SESSION["FOUND"])
      {
      $step=22;
      $error=0;
      }
    else
      {
      $step=21;
      $error=0;
      }
    }
  }
function check_post_validity($post)
  {
  global $message;
  $message="";
  if (trim($post["ffname"])=='')
    $message="خطا: لطفا نام خود را به فارسی وارد کنید.";
  else if (trim($post["efname"])=='')
    $message="خطا: لطفا نام خود را به انگلیسی وارد کنید.";
  else if (trim($post["flname"])=='')
    $message="خطا: لطفا نام خانوادگی خود را به فارسی وارد کنید.";
  else if (trim($post["elname"])=='')
    $message="خطا: لطفا نام خانوادگی خود را به انگلیسی وارد کنید.";
  else if (trim($post["gender"])=='')
    $message="خطا: لطفا جنسیت خود را وارد کنید.";
  else if (! eregi('^09[0-9]{9}$',$post["mobile"]))
    $message="خطا: لطفا  شماره‌ی موبایل خود را به طور صحیح وارد کنید.";
  else if (trim($post["telegram"])=='')
    $message="خطا: لطفا شماره‌ی تلفن تلگرام خود را وارد کنید.";
  else if (trim($post["email"])!='' && !eregi("^[a-zA-Z0-9_\-]+(\.[a-zA-Z0-9_\-]+)*@[a-zA-Z0-9_\-]+(\.[a-zA-Z0-9_\-]+)+$",trim($post["email"])))
    $message="خطا: لطفا نشانی پست الکترونیکی  خود را به طور صحیح وارد کنید.";
  if ($message=="")
    return(true);
  else
    return(false);
  }
function update($post)
  {
  if ($post["gender"]=='') $post["gender"]='NULL'; 
  $sql="
    UPDATE CertRequest SET
    ffname='{$post["ffname"]}',
    flname='{$post["flname"]}',
    efname='{$post["efname"]}',
    elname='{$post["elname"]}',
    mobile='{$post["mobile"]}',
    telegram='{$post["telegram"]}',
    email='{$post["email"]}',
    gender={$post["gender"]},
    educationalCertificate='{$post["educationalCertificate"]}',
    field='{$post["field"]}',
    job='{$post["job"]}',
    workPlace='{$post["workPlace"]}',
    educationResume='{$post["educationResume"]}',
    jobResume='{$post["jobResume"]}',
    blockchainSpecialty='{$post["blockchainSpecialty"]}',
    blockchainProgram='{$post["blockchainProgram"]}',
    lastTime=GETDATE()
    WHERE nationalId='{$_SESSION["NI"]}'
  ";
  mssql_query($sql);
  if (trim($post["email"])!='')
    send_email("{$post["ffname"]} {$post["flname"]}","{$post["efname"]} {$post["elname"]}", $post["gender"], trim($post["email"]),'update');
  }

function insert($post)
  {
  if ($post["gender"]=='')
    $post["gender"]='NULL'; 
  $sql="
    INSERT INTO CertRequest
    (
    nationalId,
    ffname,
    flname,
    efname,
    elname,
    mobile,
    telegram,
    email,
    gender,
    educationalCertificate,
    field,
    job,
    workPlace,
    educationResume,
    jobResume,
    blockchainSpecialty,
    blockchainProgram,
    lastTime
    )
    VALUES
    (
    '{$_SESSION["NI"]}',
    '{$post["ffname"]}',
    '{$post["flname"]}',
    '{$post["efname"]}',
    '{$post["elname"]}',
    '{$post["mobile"]}',
    '{$post["telegram"]}',
    '{$post["email"]}',
    {$post["gender"]},
    '{$post["educationalCertificate"]}',
    '{$post["field"]}',
    '{$post["job"]}',
    '{$post["workPlace"]}',
    '{$post["educationResume"]}',
    '{$post["jobResume"]}',
    '{$post["blockchainSpecialty"]}',
    '{$post["blockchainProgram"]}',
    GETDATE()
    )
  ";
  mssql_query($sql);
  if (trim($post["email"])!='')
    send_email("{$post["ffname"]} {$post["flname"]}","{$post["efname"]} {$post["elname"]}", $post["gender"], trim($post["email"]),'insert');
//  echo "<pre>\n{$sql}</pre>";
//  echo mssql_get_last_message();
//  exit();
  }
function check_national_code($national_code)
  {
  if (!eregi("^[0-9]{10}$",$national_code))
    return(-1);
  $s=0;
  for ($i=0;$i<10;$i++)
    {
    $char=substr($national_code,$i,1);
    if ($i<9)
      $s+=(10-$i)*$char;
    else
      {
      $r=$s%11;
      if ($r<2)
        $cr=$r;
      else
        $cr=11-$r;
      if ($cr==$char)
        return(1);
      else
        return(0);
      } 
    }
  }
function send_email($fname, $ename, $gender, $email, $command)
  {
  include "tools/phpmailer/class.phpmailer.php";
  $mail = new PHPMailer();
  $mail->IsSMTP();
  $mail->CharSet="utf-8";
  $mail->Host=$smtp_host;
  $mail->SMTPAuth=true;
  $mail->Username=$smtp_user_name;
  $mail->Password=$smtp_user_password;
  $mail->From="no-reply@cryptoclass.center";
  $mail->FromName="CryptoClass No-Reply";
  $mail->IsHTML(true);
  $mail->AddAddress($email,$ename);
  $mail->AddBCC("contact@CryptoClass.center","Contact");
  $mail->AddBCC("zojaji@gmail.com","Contact");
  $mail->AddBCC("amir_zojaji@yahoo.com","Contact");
  if ($gender==2)
    $name="سرکار خانم ";
  else if ($gender==1)
    $name="جناب آقای ";
  $name.=$fname;
  if ($command=="insert")
    {
    $mail->Subject="کریپتوکلاس: ثبت اطلاعات شما جهت درج گواهی پایان دوره در بستر بلاکچین اتریوم";
    $mail_body=file_get_contents("email-templates/301.htm");
    }
  else if ($command=="update")
    {
    $mail->Subject="کریپتوکلاس: ثبت تغییرات اطلاعات شما جهت درج گواهی پایان دوره در بستر بلاکچین اتریوم";
    $mail_body=file_get_contents("email-templates/302.htm");
    } 
  $mail->Body=str_replace("%s",$name,$mail_body);
  $mail->Send();
  }

include "template/_header.php";
%>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div class="page">
<section id="section-content" class="content page-1 moto-section" data-widget="section" data-container="section">
<div class="moto-widget moto-widget-block moto-bg-color3_5 moto-spacing-top-auto moto-spacing-right-auto moto-spacing-bottom-auto moto-spacing-left-auto" data-widget="block" data-spacing="aaaa">
<div class="container-fluid">
<div class="row">
<div class="moto-cell col-sm-12" data-container="container">

<div class="moto-widget moto-widget-container moto-container_content_57f511bb6" data-widget="container" data-container="container" data-css-name="moto-container_content_57f511bb6">
<div class="moto-widget moto-widget-spacer moto-preset-default moto-spacing-top-medium moto-spacing-right-auto moto-spacing-bottom-auto moto-spacing-left-auto" data-widget="spacer" data-preset="default" data-spacing="maaa" data-visible-on="mobile-v">
<div class="moto-widget-spacer-block" style="height:0px">
</div>

<div class="moto-widget moto-widget-row row-fixed" data-widget="row">
<div class="container-fluid">
<%
include "template/_logo.php";

include "template/_menu.php";
%>
<div class="moto-cell col-sm-3" data-container="container">
</div></div></div></div>
<%
//include "template/_front_text.php";
%>

</div></div></div></div></div>
<%
switch ($step)
  {
  case 1:
    include "template/certificate-register-1.php";
    break;
  case 21:
    include "template/certificate-register-21.php";
    break;
  case 22:
    include "template/certificate-register-22.php";
    break;
  case 23:
    include "template/certificate-register-23.php";
    break;
  case 31:
    include "template/certificate-register-31.php";
    break;
  case 32:
    include "template/certificate-register-32.php";
    break;
  case 41:
    include "template/certificate-register-41.php";
    break;
  case 42:
    include "template/certificate-register-42.php";
    break;
  }
//include "template/register-for-certificate.php";

include "template/_footer.php";
%>
</section>
</div>
<div data-moto-back-to-top-button class="moto-back-to-top-button"></div>
<script src="js/js1.js" type="text/javascript" data-cfasync="false"></script>
<script type="text/javascript" data-cfasync="false">
 var websiteConfig = websiteConfig || {};
<%
// websiteConfig.address = 'https://template59198.motopreview.com/';
%>
 websiteConfig.address = 'http://cryptoclass.center/';
 websiteConfig.apiUrl = '/api.php';
 websiteConfig.preferredLocale = 'fa_IR';
 websiteConfig.preferredLanguage = websiteConfig.preferredLocale.substring(0, 2);
 websiteConfig.back_to_top_button = {"enabled":true,"topOffset":300,"animationTime":500};
 websiteConfig.lazy_loading = {"enabled":true};
 angular.module('website.plugins', []);
</script>
<script src="js/js2.js" type="text/javascript" data-cfasync="false"></script>
</body>
</html>