/** Function to handle module specific operations when saving a entity */ function save_module($module) { if ($this->column_fields['accountname'] != "") { //ALTER TABLE `ec_account` CHANGE `prefix` `prefix` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL $prefixa = getEveryWordFirstSpell($this->column_fields['accountname']); $query = "update ec_account set prefix='" . $prefixa . "' where accountid='" . $this->id . "'"; $this->db->query($query); } }
//街道 $bill_street = $receiver_street; //邮编 $bill_code = $receiver_code; //描述 $description_account = ''; //创建时间 $createdtime_account = $accountinfo['created']; if ($createdtime_account == '') { $createdtime_account = date("Y-m-d H:i:s"); } //修改时间 $modifiedtime_account = date("Y-m-d H:i:s"); $prefixa = ''; if ($accountname != '') { $prefixa = getEveryWordFirstSpell($accountname); } $insertaccountsql = "insert into ec_account(accountid,accountname,prefix,belongshop,tao_user_id,tao_uid,membername,account_buyer_credit,account_type,alipay_account,contact_date,contacttimes,vipinfo,lastorderdate,phone,tel,email,ordernum,ordertotal,buy_pro_num,last_logintime,bill_state,bill_city,bill_district,bill_street,bill_code,description,smcreatorid,smownerid,modifiedby,createdtime,modifiedtime,deleted) values(" . $accountid . ",'" . $accountname . "','" . $prefixa . "','" . $belongshop . "','" . $tao_user_id . "','" . $tao_uid . "','" . $membername . "','" . $account_buyer_credit . "','" . $account_type . "','" . $alipay_account . "','0000-00-00',0,'" . $vipinfo . "','" . $lastorderdate . "','" . $phone . "','" . $tel . "','" . $email . "','1','" . $ordertotal . "','" . $buy_pro_num . "','" . $last_logintime . "','" . $bill_state . "','" . $bill_city . "','" . $bill_district . "','" . $bill_street . "','" . $bill_code . "','" . $description_account . "'," . $current_user->id . "," . $current_user->id . ",0,'" . $createdtime_account . "','" . $modifiedtime_account . "',0)"; $rs0 = $adb->query($insertaccountsql); if (!$rs0) { $errormess .= '客户插入未成功!' . $membername . "\r\n"; } //插入ec_crmentity $insertcrmentityaccountsql = "insert into ec_crmentity(crmid,smcreatorid,smownerid,setype,description,createdtime,modifiedtime) " . "values(" . $accountid . "," . $current_user->id . "," . $current_user->id . ",'Accounts','" . $description_account . "','" . $createdtime_account . "','" . $modifiedtime_account . "')"; $rn0 = $adb->query($insertcrmentityaccountsql); if (!$rn0) { $errormess .= '客户关联插入未成功!\\r\\n'; } } } else { $accountid = $accountid_tmp;
<?php //require_once('include/database/PearDatabase.php'); global $adb; $fld_module = $_REQUEST['fld_module']; $parenttab = $_REQUEST['parenttab']; $templatename = $_REQUEST['templatename']; $tabid = getTabid($fld_module); //checking if the user is trying to create a custom ec_field which already exists if (!empty($templatename)) { $query = "select * from ec_modulelist where filememo='" . $templatename . "'"; $result = $adb->query($query); $rownum = $adb->num_rows($result); if ($rownum == 0) { $filename = $fld_module . "HtmlTemplate" . getEveryWordFirstSpell($templatename); $query = "insert into ec_modulelist(tabid,type,filename,filememo) values (" . $tabid . ",'template','" . $filename . "','" . $templatename . "')"; $adb->query($query); $query_temp = "select filename from ec_modulelist where type='template' and tabid='" . $tabid . "' and filememo is NULL"; $result_temp = $adb->query($query_temp); $num_rows = $adb->num_rows($result_temp); if ($num_rows > 0) { $defaultFilename = $adb->query_result($result_temp, 0, 'filename'); $defaultTemp = $root_directory . "modules/" . $fld_module . "/" . $defaultFilename . "Def.html"; $newTemp = $root_directory . "modules/" . $fld_module . "/" . $filename . ".html"; $filedata = file_get_contents($defaultTemp); $error = file_put_contents($newTemp, $filedata); } else { $defaultTemp = $root_directory . "modules/" . $fld_module . "/" . $fld_module . "HtmlTemplateDef.html"; $newTemp = $root_directory . "modules/" . $fld_module . "/" . $filename . ".html"; $filedata = file_get_contents($defaultTemp); $error = file_put_contents($newTemp, $filedata);