<?php
session_start();

//var_dump($_SESSION['username']);
if($_SESSION['username']==""){echo "<script language='javascript'>;alert('请登录账户后操作');location.href='login/login.php'</script>";}
else if($_SESSION['class']=="0"){echo "<script language='javascript'>;alert('请使用管理员身份登录');location.href='login/login.php'</script>";}


include("capital.php");
include("firstCharacter.php");
include("chartConvNum.php");
include("db.php");
include("input_class.php");
$b=new input();
$company=$b->post('company');

$sql="SELECT * from company WHERE company='{$company}'";
$mysqli_result=$mysqli->query($sql);

if($row=$mysqli_result->fetch_array()){
	echo "<script language='javascript'>;alert('{$company}已存在');location.href='admin_user.php'</script>";
}
else{
	
	 $gFC=getFirstCharter($company);		//获取company的首字母 
	 
	 if(capital($gFC)){						//如果首字母是大写字母，大写字母转化为十进制数字id
		 $charter_id=gettv($gFC);
		// var_dump(gettv($gFC));
//var_dump($charter_id);		 
		$add="INSERT INTO company (`company`,`comFirstCharter`,`Charter_id`) values ('{$company}','{$gFC}','{$charter_id}')";
//var_dump($add);		
	 }
	 else{									//防万一  首字母有数字的情况
	 $add="INSERT INTO company (`company`,`comFirstCharter`,`Charter_id`) values ('{$company}','{$gFC}','27')";//数据表中数字情况id为27
//var_dump($add);
	 }
//var_dump($add);	 
	 
	 $is=$mysqli->query($add);
	 if($is){
		 echo "<script language='javascript'>;alert('{$company}添加成功');location.href='admin_user.php'</script>";
	 }else{
	 echo "<script language='javascript'>;alert('{$company}添加失败');location.href='admin_add_company.php'</script>";
	 }
}

?>