/** 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);
