<?php
$ck='not';
include("../include/checkLogin.php");
include("../include/class.php");
include("../include/table_name.php");
$date_year = date("Y");
$date_month = date("m");
require_once("../class/coreClass.php");
$core_db = new coreClass;
/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
echo "<pre>";
print_r($_GET);
echo "</pre>";
echo "<pre>";
print_r($_REQUEST);
echo "</pre>";
echo "<pre>";
print_r($_FILES);
echo "</pre>";
exit();
$data = $_POST;
echo json_encode($data, JSON_UNESCAPED_UNICODE);
echo "<pre>";
print_r($row);
echo "</pre>";

*/
$sql = array('table'=>$name_table61,'where'=>"UserName = '".@$_POST['UserName']."' AND IsDeleted=0");
$view_sql = $view_db->view($sql);
$result = $view_db->q_re($view_sql);
$result_count = $view_db->q_nr($result);
$row = $view_db->q($view_sql);


if(@$result_count>0){
  $_SESSION['Error'] = 'UserName is duplicated';
  echo "<script>window.location.href='Edit.php?Id=".@$row['Id']."&Type=Edit'</script>";

}else{

  $StatusActive=1;
  $IsDeleted=0;
  $l= "iLAW";
  $pass= addslashes(trim($l.$_POST['Password']));
  $pass_md5 = $User_db->cus_pass($pass);

  $list = array(
    'table'=>$name_table61,
    'UserName'=>"'".@$_POST['UserName']."'",
    'Password'=>"'".@$pass_md5."'",
    'Title'=>"'".@$_POST["Title"]."'",
    'Name'=>"'".@$_POST["Name"]."'",
    'MiddleName'=>"'".@$_POST["MiddleName"]."'",
    'Surname'=>"'".@$_POST["Surname"]."'",
    'StatusActive'=>"'".@$StatusActive."'",
    'IsDeleted'=>"'".@$IsDeleted."'",
    'EmailAddress'=>"'".@$_POST["EmailAddress"]."'",
    'LastUpdateBy'=>"'".@$_SESSION["UserInfo"][0]['UserId']."'",
    'LastUpdateDateTime'=>"'".@$date."'",
    'CreationTime'=>"'".@$date."'",
    'CreatorUserId'=>"'".@$_SESSION["UserInfo"][0]['UserId']."'",
  );
  $add = $actiondata_db->add_db($list);

  if($add['suc']==1){
    $sql = array('table'=>$name_table61,'count'=>'MAX(Id) AS max_id','where'=>"");
    $view_sql = $view_db->view($sql);
    $row = $view_db->q($view_sql);
    $Id = $row['max_id'];


    $role = $_POST['RoleId'];
    $s=0;
    for ($i=0; $i < count($role); $i++) {
      $list_r = array(
        'table'=>$name_table25,
        'UserId'=>"'".$Id."'",
        'RoleId'=>"'".@$role[$i]."'"
      );
      $add = $actiondata_db->add_db($list_r);
      if($add['suc']==1){
        $s=1;
      }else{
        $s=0;
      }
    }
    if($s==1){
      $_SESSION['Success']='Create Successful';
      echo "<script>window.location.href='Edit.php?Id=".$Id."&Type=Edit'</script>";
    }
  }else{
    $_SESSION['Error']='false';
    echo "<script>window.location.href='Edit.php?Id=".$Id."&Type=Edit'</script>";
  }
}



?>