toroku.php
2.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php
//*****************************************************************************
//*
//* プログラム名：e-gru
//* プログラムID：toroku.php
//* 機能 ：DB作成、登録
//* 作成者 ：K.Yoshimura(MTC)
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("../include/dbcon_e-gruPro_admin.inc");
include("../include/jcode.phps");
include("../include/mime.php");
if($sex==0){
$sex = "true";
}else{
$sex = "false";
}
$strDate= date("YmdHi",mktime(date("H"),date("i"),0,(date("m")),date("d")+14,date("Y")));
$strSql = "SELECT group_id FROM mst_group Where group_id = '".$group_id."'";
$rsResult = pg_exec($pg_con,$strSql);
if(pg_numrows($rsResult)!=0){
}else{
$strSql = "INSERT INTO maxuser_tbl VALUES(";
$strSql = $strSql."'$group_id',7,20)";
$rsResult = pg_exec($pg_con,$strSql);
if($rsResult==false){
echo("SQL失敗(INSERT)");
exit;
}
$db_name="e-gru_pro_".$group_id;
$strSql = "INSERT INTO mst_group VALUES(";
$strSql = $strSql."'$group_id','$group_pass','$db_name','$group_id','$company_name',0)";
$rsResult = pg_exec($pg_con,$strSql);
if($rsResult==false){
echo("SQL失敗(INSERT)");
exit;
}
}
//include("../include/dbcon3.inc");
//テンプレートからDBコピー
$strMKDB = "CREATE DATABASE \"e-gru_pro_".$group_id."\" WITH OWNER = pgsqladmin TEMPLATE =\"org_e-gru_pro_master\" ENCODING ='EUC_JP' ";
$objRec = pg_exec($strMKDB);
if($objRec==false){
echo("DB作成失敗");
exit;
}
//シェルからtempコピー
$res = exec("./e_gru_makeFile.sh \"".$group_id."\"");
$hostname="localhost";
$database="e-gru_pro_".$group_id;
if( !$pg_con=pg_connect("host=$hostname dbname=$database user=pgsqladmin password=pgsqladmin") ) {
print "Error : connect to ${hostname}<br>";
exit;
}
$strSql = "INSERT INTO syain_tbl (syain_cd,syain_id,password,name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei,sex,birthday,del_flg) VALUES(";
$strSql = $strSql."1,'1','admin','$user_name_sei','$user_name_mei','','',$sex,'',true)";
$rsResult = pg_exec($pg_con,$strSql);
if($rsResult==false){
echo("SQL失敗(INSERT)");
exit;
}
$strSql = "INSERT INTO mst_company (company_name) VALUES(";
$strSql = $strSql."'".$company_name."')";
$rsResult = pg_exec($pg_con,$strSql);
if($rsResult==false){
echo("SQL失敗(INSERT)");
exit;
}
header("Location: comp.php");
?>