PHP tform_actions::onAfterInsert方法代码示例

 function onAfterInsert()
 {
     global $app, $conf;
     // Create the group for the client
     $groupid = $app->db->datalogInsert('sys_group', "(name,description,client_id) VALUES ('" . $app->db->quote($this->dataRecord["username"]) . "',''," . $this->id . ")", 'groupid');
     $groups = $groupid;
     $username = $app->db->quote($this->dataRecord["username"]);
     $password = $app->db->quote($this->dataRecord["password"]);
     $modules = $conf['interface_modules_enabled'];
     if (isset($this->dataRecord["limit_client"]) && $this->dataRecord["limit_client"] > 0) {
         $modules .= ',client';
     }
     $startmodule = stristr($modules, 'dashboard') ? 'dashboard' : 'client';
     $usertheme = $app->db->quote($this->dataRecord["usertheme"]);
     $type = 'user';
     $active = 1;
     $language = $app->db->quote($this->dataRecord["language"]);
     $password = $app->auth->crypt_password($password);
     // Create the controlpaneluser for the client
     //Generate ssh-rsa-keys
     exec('ssh-keygen -t rsa -C ' . $username . '-rsa-key-' . time() . ' -f /tmp/id_rsa -N ""');
     $app->db->query("UPDATE client SET created_at = " . time() . ", id_rsa = '" . $app->db->quote(@file_get_contents('/tmp/id_rsa')) . "', ssh_rsa = '" . $app->db->quote(@file_get_contents('/tmp/id_rsa.pub')) . "' WHERE client_id = " . $this->id);
     exec('rm -f /tmp/id_rsa /tmp/id_rsa.pub');
     // Create the controlpaneluser for the client
     $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)\n\t\tVALUES ('{$username}','{$password}','{$modules}','{$startmodule}','{$usertheme}','{$type}','{$active}','{$language}',{$groups},{$groupid}," . $this->id . ")";
     $app->db->query($sql);
     //* If the user who inserted the client is a reseller (not admin), we will have to add this new client group
     //* to his groups, so he can administrate the records of this client.
     if ($_SESSION['s']['user']['typ'] == 'user') {
         $app->auth->add_group_to_user($_SESSION['s']['user']['userid'], $groupid);
         $app->db->query("UPDATE client SET parent_client_id = " . $app->functions->intval($_SESSION['s']['user']['client_id']) . " WHERE client_id = " . $this->id);
     } else {
         if ($this->dataRecord['parent_client_id'] > 0) {
             //* get userid of the reseller and add it to the group of the client
             $tmp = $app->db->queryOneRecord("SELECT sys_user.userid FROM sys_user,sys_group WHERE sys_user.default_group = sys_group.groupid AND sys_group.client_id = " . $app->functions->intval($this->dataRecord['parent_client_id']));
             $app->auth->add_group_to_user($tmp['userid'], $groupid);
             $app->db->query("UPDATE client SET parent_client_id = " . $app->functions->intval($this->dataRecord['parent_client_id']) . " WHERE client_id = " . $this->id);
             unset($tmp);
         }
     }
     //* Set the default servers
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE mail_server = 1 AND mirror_server_id = 0 LIMIT 0,1');
     $default_mailserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE web_server = 1 AND mirror_server_id = 0 LIMIT 0,1');
     $default_webserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE dns_server = 1 AND mirror_server_id = 0 LIMIT 0,1');
     $default_dnsserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE db_server = 1 AND mirror_server_id = 0 LIMIT 0,1');
     $default_dbserver = $app->functions->intval($tmp['server_id']);
     $sql = "UPDATE client SET default_mailserver = {$default_mailserver}, default_webserver = {$default_webserver}, default_dnsserver = {$default_dnsserver}, default_slave_dnsserver = {$default_dnsserver}, default_dbserver = {$default_dbserver} WHERE client_id = " . $this->id;
     $app->db->query($sql);
     if (isset($this->dataRecord['template_master'])) {
         $app->uses('client_templates');
         $app->client_templates->update_client_templates($this->id, $this->_template_additional);
     }
     if ($this->dataRecord['customer_no'] == $this->dataRecord['customer_no_org']) {
         if ($app->auth->is_admin()) {
             //* Logged in User is admin
             //* get the system config
             $app->uses('getconf');
             $system_config = $app->getconf->get_global_config();
             if ($system_config['misc']['customer_no_template'] != '') {
                 //* save new counter value
                 $system_config['misc']['customer_no_counter']++;
                 $system_config_str = $app->ini_parser->get_ini_string($system_config);
                 $app->db->datalogUpdate('sys_ini', "config = '" . $app->db->quote($system_config_str) . "'", 'sysini_id', 1);
             }
         } else {
             //* Logged in user must be a reseller
             //* get the record of the reseller
             $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
             $reseller = $app->db->queryOneRecord("SELECT client.client_id, client.customer_no_template, client.customer_no_counter, client.customer_no_start FROM sys_group,client WHERE client.client_id = sys_group.client_id and sys_group.groupid = " . $client_group_id);
             if ($reseller['customer_no_template'] != '') {
                 //* save new counter value
                 $customer_no_counter = $app->functions->intval($reseller['customer_no_counter'] + 1);
                 $app->db->query("UPDATE client SET customer_no_counter = {$customer_no_counter} WHERE client_id = " . $app->functions->intval($reseller['client_id']));
             }
         }
     }
     //* Send welcome email
     $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
     $sql = "SELECT * FROM client_message_template WHERE template_type = 'welcome' AND sys_groupid = " . $client_group_id;
     $email_template = $app->db->queryOneRecord($sql);
     $client = $app->tform->getDataRecord($this->id);
     if (is_array($email_template) && $client['email'] != '') {
         //* Parse client details into message
         $message = $email_template['message'];
         $subject = $email_template['subject'];
         foreach ($client as $key => $val) {
             switch ($key) {
                 case 'password':
                     $message = str_replace('{password}', $this->dataRecord['password'], $message);
                     $subject = str_replace('{password}', $this->dataRecord['password'], $subject);
                     break;
                 case 'gender':
                     $message = str_replace('{salutation}', $app->tform->lng('gender_' . $val . '_txt'), $message);
                     $subject = str_replace('{salutation}', $app->tform->lng('gender_' . $val . '_txt'), $subject);
                     break;
                 default:
                     $message = str_replace('{' . $key . '}', $val, $message);
//.........这里部分代码省略.........

 function onAfterInsert()
 {
     global $app, $conf;
     // Create the group for the client
     $groupid = $app->db->datalogInsert('sys_group', "(name,description,client_id) VALUES ('" . mysql_real_escape_string($this->dataRecord["username"]) . "',''," . $this->id . ")", 'groupid');
     $groups = $groupid;
     $username = $app->db->quote($this->dataRecord["username"]);
     $password = $app->db->quote($this->dataRecord["password"]);
     $modules = $conf['interface_modules_enabled'];
     if ($this->dataRecord["limit_client"] > 0) {
         $modules .= ',client';
     }
     $startmodule = stristr($modules, 'dashboard') ? 'dashboard' : 'client';
     $usertheme = $app->db->quote($this->dataRecord["usertheme"]);
     $type = 'user';
     $active = 1;
     $language = $app->db->quote($this->dataRecord["language"]);
     $password = $app->auth->crypt_password($password);
     // Create the controlpaneluser for the client
     //Generate ssh-rsa-keys
     exec('ssh-keygen -t rsa -C ' . $username . '-rsa-key-' . time() . ' -f /tmp/id_rsa -N ""');
     $app->db->query("UPDATE client SET created_at = " . time() . ", id_rsa = '" . $app->db->quote(@file_get_contents('/tmp/id_rsa')) . "', ssh_rsa = '" . $app->db->quote(@file_get_contents('/tmp/id_rsa.pub')) . "' WHERE client_id = " . $this->id);
     exec('rm -f /tmp/id_rsa /tmp/id_rsa.pub');
     // Create the controlpaneluser for the client
     $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)\n\t\tVALUES ('{$username}','{$password}','{$modules}','{$startmodule}','{$usertheme}','{$type}','{$active}','{$language}',{$groups},{$groupid}," . $this->id . ")";
     $app->db->query($sql);
     //* If the user who inserted the client is a reseller (not admin), we will have to add this new client group
     //* to his groups, so he can administrate the records of this client.
     if ($_SESSION['s']['user']['typ'] == 'user') {
         $app->auth->add_group_to_user($_SESSION['s']['user']['userid'], $groupid);
         $app->db->query("UPDATE client SET parent_client_id = " . intval($_SESSION['s']['user']['client_id']) . " WHERE client_id = " . $this->id);
     }
     /* If there is a client-template, process it */
     applyClientTemplates($this->id);
     parent::onAfterInsert();
 }

 function onAfterInsert()
 {
     global $app, $conf;
     // Create the group for the reseller
     $groupid = $app->db->datalogInsert('sys_group', "(name,description,client_id) VALUES ('" . $app->db->quote($this->dataRecord["username"]) . "',''," . $this->id . ")", 'groupid');
     $groups = $groupid;
     $username = $app->db->quote($this->dataRecord["username"]);
     $password = $app->db->quote($this->dataRecord["password"]);
     $modules = $conf['interface_modules_enabled'] . ',client';
     $startmodule = stristr($modules, 'dashboard') ? 'dashboard' : 'client';
     $usertheme = $app->db->quote($this->dataRecord["usertheme"]);
     $type = 'user';
     $active = 1;
     $language = $app->db->quote($this->dataRecord["language"]);
     $salt = "\$1\$";
     $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
     for ($n = 0; $n < 8; $n++) {
         $salt .= $base64_alphabet[mt_rand(0, 63)];
     }
     $salt .= "\$";
     $password = crypt(stripslashes($password), $salt);
     // Create the controlpaneluser for the reseller
     $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)\n\t\tVALUES ('{$username}','{$password}','{$modules}','{$startmodule}','{$usertheme}','{$type}','{$active}','{$language}',{$groups},{$groupid}," . $this->id . ")";
     $app->db->query($sql);
     //* set the number of clients to 1
     $app->db->query("UPDATE client SET limit_client = 1 WHERE client_id = " . $this->id);
     //* Set the default servers
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE mail_server = 1 LIMIT 0,1');
     $default_mailserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE web_server = 1 LIMIT 0,1');
     $default_webserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE dns_server = 1 LIMIT 0,1');
     $default_dnsserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE db_server = 1 LIMIT 0,1');
     $default_dbserver = $app->functions->intval($tmp['server_id']);
     $sql = "UPDATE client SET default_mailserver = {$default_mailserver}, default_webserver = {$default_webserver}, default_dnsserver = {$default_dnsserver}, default_dbserver = {$default_dbserver} WHERE client_id = " . $this->id;
     $app->db->query($sql);
     parent::onAfterInsert();
 }

 function onAfterInsert()
 {
     global $app, $conf;
     // Create the group for the reseller
     $groupid = $app->db->datalogInsert('sys_group', "(name,description,client_id) VALUES ('" . $app->db->quote($this->dataRecord["username"]) . "',''," . $this->id . ")", 'groupid');
     $groups = $groupid;
     $username = $app->db->quote($this->dataRecord["username"]);
     $password = $app->db->quote($this->dataRecord["password"]);
     $modules = $app->db->quote($conf['interface_modules_enabled'] . ',client');
     $startmodule = stristr($modules, 'dashboard') ? 'dashboard' : 'client';
     $usertheme = $app->db->quote($this->dataRecord["usertheme"]);
     $type = 'user';
     $active = 1;
     $language = $app->db->quote($this->dataRecord["language"]);
     $salt = "\$1\$";
     $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
     for ($n = 0; $n < 8; $n++) {
         $salt .= $base64_alphabet[mt_rand(0, 63)];
     }
     $salt .= "\$";
     $password = crypt(stripslashes($password), $salt);
     // Create the controlpaneluser for the reseller
     $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)\n\t\tVALUES ('{$username}','{$password}','{$modules}','{$startmodule}','{$usertheme}','{$type}','{$active}','{$language}',{$groups},{$groupid}," . $this->id . ")";
     $app->db->query($sql);
     //* set the number of clients to 1
     $app->db->query("UPDATE client SET limit_client = 1 WHERE client_id = " . $this->id);
     //* Set the default servers
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE mail_server = 1 LIMIT 0,1');
     $default_mailserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE web_server = 1 LIMIT 0,1');
     $default_webserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE dns_server = 1 LIMIT 0,1');
     $default_dnsserver = $app->functions->intval($tmp['server_id']);
     $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE db_server = 1 LIMIT 0,1');
     $default_dbserver = $app->functions->intval($tmp['server_id']);
     $sql = "UPDATE client SET default_mailserver = {$default_mailserver}, default_webserver = {$default_webserver}, default_dnsserver = {$default_dnsserver}, default_slave_dnsserver = {$default_dnsserver}, default_dbserver = {$default_dbserver} WHERE client_id = " . $this->id;
     $app->db->query($sql);
     if (isset($this->dataRecord['template_master'])) {
         $app->uses('client_templates');
         $app->client_templates->update_client_templates($this->id, $this->_template_additional);
     }
     if ($this->dataRecord['customer_no'] == $this->dataRecord['customer_no_org']) {
         //* get the system config
         $app->uses('getconf');
         $system_config = $app->getconf->get_global_config();
         if ($system_config['misc']['customer_no_template'] != '') {
             //* save new counter value
             $system_config['misc']['customer_no_counter']++;
             $system_config_str = $app->ini_parser->get_ini_string($system_config);
             $app->db->datalogUpdate('sys_ini', "config = '" . $app->db->quote($system_config_str) . "'", 'sysini_id', 1);
         }
     }
     //* Send welcome email
     $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
     $sql = "SELECT * FROM client_message_template WHERE template_type = 'welcome' AND sys_groupid = " . $client_group_id;
     $email_template = $app->db->queryOneRecord($sql);
     $client = $app->tform->getDataRecord($this->id);
     if (is_array($email_template) && $client['email'] != '') {
         //* Parse client details into message
         $message = $email_template['message'];
         $subject = $email_template['subject'];
         foreach ($client as $key => $val) {
             switch ($key) {
                 case 'password':
                     $message = str_replace('{password}', $this->dataRecord['password'], $message);
                     $subject = str_replace('{password}', $this->dataRecord['password'], $subject);
                     break;
                 case 'gender':
                     $message = str_replace('{salutation}', $wb['gender_' . $val . '_txt'], $message);
                     $subject = str_replace('{salutation}', $wb['gender_' . $val . '_txt'], $subject);
                     break;
                 default:
                     $message = str_replace('{' . $key . '}', $val, $message);
                     $subject = str_replace('{' . $key . '}', $val, $subject);
             }
         }
         //* Get sender address
         if ($app->auth->is_admin()) {
             $app->uses('getconf');
             $system_config = $app->getconf->get_global_config();
             $from = $system_config['admin_mail'];
         } else {
             $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
             $reseller = $app->db->queryOneRecord("SELECT client.email FROM sys_group,client WHERE client.client_id = sys_group.client_id and sys_group.groupid = " . $client_group_id);
             $from = $reseller["email"];
         }
         //* Send the email
         $app->functions->mail($client['email'], $subject, $message, $from);
     }
     parent::onAfterInsert();
 }

 function onAfterInsert()
 {
     global $app, $conf;
     // Create the group for the reseller
     $groupid = $app->db->datalogInsert('sys_group', "(name,description,client_id) VALUES ('" . mysql_real_escape_string($this->dataRecord["username"]) . "',''," . $this->id . ")", 'groupid');
     $groups = $groupid;
     $username = $app->db->quote($this->dataRecord["username"]);
     $password = $app->db->quote($this->dataRecord["password"]);
     $modules = $conf['interface_modules_enabled'] . ',client';
     $startmodule = stristr($modules, 'dashboard') ? 'dashboard' : 'client';
     $usertheme = $app->db->quote($this->dataRecord["usertheme"]);
     $type = 'user';
     $active = 1;
     $language = $app->db->quote($this->dataRecord["language"]);
     $salt = "\$1\$";
     $base64_alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
     for ($n = 0; $n < 8; $n++) {
         $salt .= $base64_alphabet[mt_rand(0, 63)];
     }
     $salt .= "\$";
     $password = crypt(stripslashes($password), $salt);
     // Create the controlpaneluser for the reseller
     $sql = "INSERT INTO sys_user (username,passwort,modules,startmodule,app_theme,typ,active,language,groups,default_group,client_id)\n\t\tVALUES ('{$username}','{$password}','{$modules}','{$startmodule}','{$usertheme}','{$type}','{$active}','{$language}',{$groups},{$groupid}," . $this->id . ")";
     $app->db->query($sql);
     //* set the number of clients to 1
     $app->db->query("UPDATE client SET limit_client = 1 WHERE client_id = " . $this->id);
     /* If there is a client-template, process it */
     applyClientTemplates($this->id);
     parent::onAfterInsert();
 }