PDO::ERRMODE_EXCEPTION]);
$pdo->exec("CREATE DATABASE IF NOT EXISTS `".str_replace('`','',$name)."` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
$pdo->exec("USE `".str_replace('`','',$name)."`");
$sql=file_get_contents(__DIR__.'/database/schema.sql');
foreach(array_filter(array_map('trim',preg_split('/;\s*(?:\r?\n|$)/',$sql))) as $stmt){ if($stmt!=='') $pdo->exec($stmt); }
$company=trim($_POST['company_name']);$code=strtoupper(trim($_POST['company_code']));$admin=trim($_POST['admin_name']);$email=trim($_POST['admin_email']);$pw=$_POST['admin_password'];
$pdo->prepare("INSERT INTO companies(name,code) VALUES(?,?)")->execute([$company,$code]);$cid=(int)$pdo->lastInsertId();
$pdo->prepare("INSERT INTO branches(company_id,name,code) VALUES(?,?,?)")->execute([$cid,'Head Office','HO']);$bid=(int)$pdo->lastInsertId();
$roleId=(int)$pdo->query("SELECT id FROM roles WHERE name='Super Admin' ORDER BY id LIMIT 1")->fetchColumn();
$pdo->prepare("INSERT INTO users(company_id,branch_id,role_id,name,email,password_hash,is_super_admin) VALUES(?,?,?,?,?,?,1)")->execute([$cid,$bid,$roleId,$admin,$email,password_hash($pw,PASSWORD_DEFAULT)]);
$config="'SecurityERP Enterprise','base_url'=>'','timezone'=>'Asia/Karachi','db'=>['host'=>$host,'port'=>$port,'name'=>$name,'user'=>$user,'pass'=>$pass,'charset'=>'utf8mb4'],'security'=>['session_name'=>'securityerp_session','secure_cookie'=>true,'same_site'=>'Lax']],true).";\n";
file_put_contents($configFile,$config);
echo "Installation complete.
Delete or rename install.php, then open public/login.php.
";exit;
}
?>SecurityERP InstallerSecurityERP Enterprise Installer