//
//====================================================================================================
/// <summary>
/// set property
/// </summary>
/// <param name="propertyName"></param>
/// <param name="propertyValue"></param>
/// <param name="keyId">keyId is like vistiId, vistorId, userId</param>
public void setProperty(string propertyName, string propertyValue, int keyId)
{
try {
if (!propertyCacheLoaded)
{
loadFromDb(keyId);
}
int Ptr = -1;
if (propertyCacheCnt > 0)
{
Ptr = propertyCache_nameIndex.getPtr(propertyName);
}
if (Ptr < 0)
{
Ptr = propertyCacheCnt;
propertyCacheCnt += 1;
string[,] tempVar = new string[3, Ptr + 1];
if (propertyCache != null)
{
for (int Dimension0 = 0; Dimension0 < propertyCache.GetLength(0); Dimension0++)
{
int CopyLength = Math.Min(propertyCache.GetLength(1), tempVar.GetLength(1));
for (int Dimension1 = 0; Dimension1 < CopyLength; Dimension1++)
{
tempVar[Dimension0, Dimension1] = propertyCache[Dimension0, Dimension1];
}
}
}
propertyCache = tempVar;
propertyCache[0, Ptr] = propertyName;
propertyCache[1, Ptr] = propertyValue;
propertyCache_nameIndex.setPtr(propertyName, Ptr);
//
// insert a new property record, get the ID back and save it in cache
//
using (var csData = new CsModel(core)) {
if (csData.insert("Properties"))
{
propertyCache[2, Ptr] = csData.getText("ID");
csData.set("name", propertyName);
csData.set("FieldValue", propertyValue);
csData.set("TypeID", (int)propertyType);
csData.set("KeyID", keyId.ToString());
}
}
}
else if (propertyCache[1, Ptr] != propertyValue)
{
propertyCache[1, Ptr] = propertyValue;
int RecordId = GenericController.encodeInteger(propertyCache[2, Ptr]);
string SQLNow = DbController.encodeSQLDate(core.dateTimeNowMockable);
//
// save the value in the property that was found
//
core.db.executeNonQuery("update ccProperties set FieldValue=" + DbController.encodeSQLText(propertyValue) + ",ModifiedDate=" + SQLNow + " where id=" + RecordId);
}
} catch (Exception ex) {
LogController.logError(core, ex);
}
}
//
//=====================================================================================================
/// <summary>
/// add activity about a user to the site's activity log for content managers to review
/// </summary>
/// <param name="core"></param>
/// <param name="Message"></param>
/// <param name="ByMemberID"></param>
/// <param name="SubjectMemberID"></param>
/// <param name="SubjectOrganizationID"></param>
/// <param name="Link"></param>
/// <param name="VisitorID"></param>
/// <param name="VisitID"></param>
public static void addSiteActivity(CoreController core, string Message, int ByMemberID, int SubjectMemberID, int SubjectOrganizationID, string Link = "", int VisitorId = 0, int VisitId = 0)
{
try {
//
if (Message.Length > 255)
{
Message = Message.Substring(0, 255);
}
if (Link.Length > 255)
{
Message = Link.Substring(0, 255);
}
using (var csData = new CsModel(core)) {
if (csData.insert("Activity Log"))
{
csData.set("MemberID", SubjectMemberID);
csData.set("OrganizationID", SubjectOrganizationID);
csData.set("Message", Message);
csData.set("Link", Link);
csData.set("VisitorID", VisitorId);
csData.set("VisitID", VisitId);
}
}
//
return;
//
} catch (Exception ex) {
LogController.logError(core, ex);
}
}
//
//
//
//
public static string main_GetRemoteQueryKey(CoreController core, string SQL, string dataSourceName = "default", int maxRows = 1000)
{
string remoteKey = "";
if (maxRows == 0)
{
maxRows = 1000;
}
using (var cs = new CsModel(core)) {
cs.insert("Remote Queries");
if (cs.ok())
{
remoteKey = getGUIDNaked();
cs.set("remotekey", remoteKey);
cs.set("datasourceid", MetadataController.getRecordIdByUniqueName(core, "Data Sources", dataSourceName));
cs.set("sqlquery", SQL);
cs.set("maxRows", maxRows);
cs.set("dateexpires", DbController.encodeSQLDate(core.doc.profileStartTime.AddDays(1)));
cs.set("QueryTypeID", QueryTypeSQL);
cs.set("VisitId", core.session.visit.id);
}
cs.close();
}
//
return(remoteKey);
}
//
//====================================================================================================
/// <summary>
/// Insert a record, leaving the dataset open in this object. Call cs.close() to close the data
/// </summary>
/// <param name="contentName"></param>
/// <returns></returns>
public override bool Insert(string contentName)
{
try {
return(cs.insert(contentName));
} catch (Exception ex) {
LogController.logError(cp.core, ex);
throw;
}
}
//
//====================================================================================================
//
public override int AddRecord(string contentName)
{
int result = 0;
try {
CsModel cs = new CsModel(cp.core);
if (cs.insert(contentName))
{
result = cs.getInteger("id");
}
cs.close();
} catch (Exception ex) {
LogController.logError(cp.core, ex);
throw;
}
return(result);
}
//
//================================================================================================
/// <summary>
/// Add a site Warning: for content managers to make content changes with the site
/// Report Warning
/// A warning is logged in the site warnings log
/// name - a generic description of the warning
/// "bad link found on page"
/// issueCategory - a generic string that describes the warning. the warning report
/// will display one line for each generalKey (name matches guid)
/// like "bad link"
/// location - the URL, service or process that caused the problem
/// "http://goodpageThankHasBadLink.com"
/// pageid - the record id of the bad page.
/// "http://goodpageThankHasBadLink.com"
/// description - a specific description
/// "link to http://www.this.com/pagename was found on http://www.this.com/About-us"
/// count - the number of times the name and issueCategory matched. "This error was reported 100 times"
/// </summary>
/// <param name="core"></param>
/// <param name="Name">A generic description of the warning that describes the problem, but if the issue occurs again the name will match, like Page Not Found on /Home</param>
/// <param name="ignore">To be deprecated - same as name</param>
/// <param name="location">Where the issue occurred, like on a page, or in a background process.</param>
/// <param name="PageID"></param>
/// <param name="Description">Any detail the use will need to debug the problem.</param>
/// <param name="issueCategory">A general description of the issue that can be grouped in a report, like Page Not Found</param>
/// <param name="ignore2">to be deprecated, same a name.</param>
//
public static void addSiteWarning(CoreController core, string Name, string ignore, string location, int PageID, string Description, string issueCategory, string ignore2)
{
int warningId = 0;
//
warningId = 0;
string SQL = "select top 1 ID from ccSiteWarnings"
+ " where (name=" + DbController.encodeSQLText(Name) + ")"
+ " and(generalKey=" + DbController.encodeSQLText(issueCategory) + ")"
+ "";
DataTable dt = core.db.executeQuery(SQL);
if (dt.Rows.Count > 0)
{
warningId = GenericController.encodeInteger(dt.Rows[0]["id"]);
}
//
if (warningId != 0)
{
//
// increment count for matching warning
//
SQL = "update ccsitewarnings set count=count+1,DateLastReported=" + DbController.encodeSQLDate(core.dateTimeNowMockable) + " where id=" + warningId;
core.db.executeNonQuery(SQL);
}
else
{
//
// insert new record
//
using (var csData = new CsModel(core)) {
if (csData.insert("Site Warnings"))
{
csData.set("name", Name);
csData.set("description", Description);
csData.set("generalKey", issueCategory);
csData.set("count", 1);
csData.set("DateLastReported", core.dateTimeNowMockable);
csData.set("location", location);
csData.set("pageId", PageID);
}
}
}
//
}
//
//---------------------------------------------------------------------------
// Create the default landing page if it is missing
//---------------------------------------------------------------------------
//
public int createPageGetID(string PageName, string ContentName, int CreatedBy, string pageGuid)
{
int Id = 0;
using (var csData = new CsModel(core)) {
if (csData.insert(ContentName))
{
Id = csData.getInteger("ID");
csData.set("name", PageName);
csData.set("active", "1");
{
csData.set("ccGuid", pageGuid);
}
csData.save();
}
}
return(Id);
}
//
//=============================================================================
//
public void verifyRegistrationFormPage(CoreController core)
{
try {
MetadataController.deleteContentRecords(core, "Form Pages", "name=" + DbController.encodeSQLText("Registration Form"));
using (var csData = new CsModel(core)) {
if (!csData.open("Form Pages", "name=" + DbController.encodeSQLText("Registration Form")))
{
//
// create Version 1 template - just to main_Get it started
//
if (csData.insert("Form Pages"))
{
csData.set("name", "Registration Form");
string Copy = ""
+ Environment.NewLine + "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\">"
+ Environment.NewLine + "{{REPEATSTART}}<tr><td align=right style=\"height:22px;\">{{CAPTION}} </td><td align=left>{{FIELD}}</td></tr>{{REPEATEND}}"
+ Environment.NewLine + "<tr><td align=right><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=135 height=1></td><td width=\"100%\"> </td></tr>"
+ Environment.NewLine + "<tr><td colspan=2> <br>" + core.html.getPanelButtons(ButtonRegister) + "</td></tr>"
+ Environment.NewLine + "</table>";
csData.set("Body", Copy);
Copy = ""
+ "1"
+ Environment.NewLine + "Registered\r\ntrue"
+ Environment.NewLine + "1,First Name,true,FirstName"
+ Environment.NewLine + "1,Last Name,true,LastName"
+ Environment.NewLine + "1,Email Address,true,Email"
+ Environment.NewLine + "1,Phone,true,Phone"
+ Environment.NewLine + "2,Please keep me informed of news and events,false,Subscribers"
+ "";
csData.set("Instructions", Copy);
}
}
}
} catch (Exception ex) {
LogController.logError(core, ex);
}
}
//
//=========================================================================================
// Summarize the visits
// excludes non-cookie visits
// excludes administrator and developer visits
// excludes authenticated users with ExcludeFromReporting
//
// Average time on site
//
// Example data
// Pages TimeToLastHit
// 1 0 - hit 1 page, start time = last time
// 10 3510 - hit 10 pages, first hit time - last hit time = 3510
// 2 30 - hit 2 pages, first hit time - last hit time = 30
//
// AveReadTime is the average time spent reading pages
// this is calculated from the multi-page visits only
// = MultiPageTimeToLastHitSum / ( MultiPageHitCnt - MultiPageVisitCnt )
// = ( 3510 + 30 ) / ((10+2) - 2 )
// = 354
//
// TotalTimeOnSite is the total time people spent reading pages
// There are two parts:
// 1) the TimeToLastHit, which covers all but the last hit of each visit
// 2) assume the last hit of each visit is the AveReadTime
// = MultiPageTimeToLastHitSum + ( AveReadTime * VisitCnt )
// = ( 3510 + 30 ) + ( 354 * 3 )
// = 4602
//
// AveTimeOnSite
// = TotalTimeOnSite / TotalHits
// = 4602 / 3
// = 1534
//
//=========================================================================================
//
private static void summarizePeriod(CoreController core, HouseKeepEnvironmentModel env, DateTime StartTimeDate, DateTime EndTimeDate, int HourDuration, string BuildVersion, DateTime OldestVisitSummaryWeCareAbout)
{
try {
//
if (string.CompareOrdinal(BuildVersion, CoreController.codeVersion()) >= 0)
{
DateTime PeriodStart = default(DateTime);
PeriodStart = StartTimeDate;
if (PeriodStart < OldestVisitSummaryWeCareAbout)
{
PeriodStart = OldestVisitSummaryWeCareAbout;
}
double StartTimeHoursSinceMidnight = PeriodStart.TimeOfDay.TotalHours;
PeriodStart = PeriodStart.Date.AddHours(StartTimeHoursSinceMidnight);
DateTime PeriodDatePtr = default(DateTime);
PeriodDatePtr = PeriodStart;
while (PeriodDatePtr < EndTimeDate)
{
//
int DateNumber = encodeInteger(PeriodDatePtr.AddHours(HourDuration / 2.0).ToOADate());
int TimeNumber = encodeInteger(PeriodDatePtr.TimeOfDay.TotalHours);
DateTime DateStart = default(DateTime);
DateStart = PeriodDatePtr.Date;
DateTime DateEnd = default(DateTime);
DateEnd = PeriodDatePtr.AddHours(HourDuration).Date;
//
// No Cookie Visits
//
string SQL = "select count(v.id) as NoCookieVisits"
+ " from ccvisits v"
+ " where (v.CookieSupport<>1)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ "";
int NoCookieVisits = 0;
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
NoCookieVisits = csData.getInteger("NoCookieVisits");
}
}
//
// Total Visits
//
SQL = "select count(v.id) as VisitCnt ,Sum(v.PageVisits) as HitCnt ,sum(v.TimetoLastHit) as TimeOnSite"
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ "";
//
int VisitCnt = 0;
int HitCnt = 0;
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
VisitCnt = csData.getInteger("VisitCnt");
HitCnt = csData.getInteger("HitCnt");
double TimeOnSite = csData.getNumber("TimeOnSite");
}
}
//
// -- Visits by new visitors
int NewVisitorVisits = 0;
int SinglePageVisits = 0;
int AuthenticatedVisits = 0;
int MobileVisits = 0;
int BotVisits = 0;
double AveTimeOnSite = 0;
if (VisitCnt > 0)
{
SQL = "select count(v.id) as NewVisitorVisits"
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(v.VisitorNew<>0)"
+ "";
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
NewVisitorVisits = csData.getInteger("NewVisitorVisits");
}
}
//
// Single Page Visits
//
SQL = "select count(v.id) as SinglePageVisits"
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(v.PageVisits=1)"
+ "";
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
SinglePageVisits = csData.getInteger("SinglePageVisits");
}
}
//
// Multipage Visits
//
SQL = "select count(v.id) as VisitCnt ,sum(v.PageVisits) as HitCnt ,sum(v.TimetoLastHit) as TimetoLastHitSum "
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(PageVisits>1)"
+ "";
int MultiPageHitCnt = 0;
int MultiPageVisitCnt = 0;
double MultiPageTimetoLastHitSum = 0;
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
MultiPageVisitCnt = csData.getInteger("VisitCnt");
MultiPageHitCnt = csData.getInteger("HitCnt");
MultiPageTimetoLastHitSum = csData.getNumber("TimetoLastHitSum");
}
}
//
// Authenticated Visits
//
SQL = "select count(v.id) as AuthenticatedVisits "
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(VisitAuthenticated<>0)"
+ "";
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
AuthenticatedVisits = csData.getInteger("AuthenticatedVisits");
}
}
//
//
// Mobile Visits
//
SQL = "select count(v.id) as cnt "
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(Mobile<>0)"
+ "";
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
MobileVisits = csData.getInteger("cnt");
}
}
//
// Bot Visits
//
SQL = "select count(v.id) as cnt "
+ " from ccvisits v"
+ " where (v.CookieSupport<>0)"
+ " and(v.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (v.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and(Bot<>0)"
+ "";
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.openSql(SQL);
if (csData.ok())
{
BotVisits = csData.getInteger("cnt");
}
}
//
if ((MultiPageHitCnt > MultiPageVisitCnt) && (HitCnt > 0))
{
int AveReadTime = encodeInteger(MultiPageTimetoLastHitSum / (MultiPageHitCnt - MultiPageVisitCnt));
double TotalTimeOnSite = MultiPageTimetoLastHitSum + (AveReadTime * VisitCnt);
AveTimeOnSite = TotalTimeOnSite / VisitCnt;
}
}
//
// Add or update the Visit Summary Record
//
using (var csData = new CsModel(core)) {
core.db.sqlCommandTimeout = 180;
csData.open("Visit Summary", "(timeduration=" + HourDuration + ")and(DateNumber=" + DateNumber + ")and(TimeNumber=" + TimeNumber + ")");
if (!csData.ok())
{
csData.close();
csData.insert("Visit Summary");
}
//
if (csData.ok())
{
csData.set("name", HourDuration + " hr summary for " + DateTime.FromOADate(DateNumber).ToShortDateString() + " " + TimeNumber + ":00");
csData.set("DateNumber", DateNumber);
csData.set("TimeNumber", TimeNumber);
csData.set("Visits", VisitCnt);
csData.set("PagesViewed", HitCnt);
csData.set("TimeDuration", HourDuration);
csData.set("NewVisitorVisits", NewVisitorVisits);
csData.set("SinglePageVisits", SinglePageVisits);
csData.set("AuthenticatedVisits", AuthenticatedVisits);
csData.set("NoCookieVisits", NoCookieVisits);
csData.set("AveTimeOnSite", AveTimeOnSite);
{
csData.set("MobileVisits", MobileVisits);
csData.set("BotVisits", BotVisits);
}
}
}
PeriodDatePtr = PeriodDatePtr.AddHours(HourDuration);
}
{
//
// Delete any daily visit summary duplicates during this period(keep the first)
//
string SQL = "delete from ccvisitsummary"
+ " where id in ("
+ " select d.id from ccvisitsummary d,ccvisitsummary f"
+ " where f.datenumber=d.datenumber"
+ " and f.datenumber>" + env.oldestVisitSummaryWeCareAbout.ToOADate() + " and f.datenumber<" + env.yesterday.ToOADate() + " and f.TimeDuration=24"
+ " and d.TimeDuration=24"
+ " and f.id<d.id"
+ ")";
core.db.sqlCommandTimeout = 180;
core.db.executeNonQuery(SQL);
//
// Find missing daily summaries, summarize that date
//
SQL = core.db.getSQLSelect("ccVisitSummary", "DateNumber", "TimeDuration=24 and DateNumber>=" + env.oldestVisitSummaryWeCareAbout.Date.ToOADate(), "DateNumber,TimeNumber");
using (var csData = new CsModel(core)) {
csData.openSql(SQL);
DateTime datePtr = env.oldestVisitSummaryWeCareAbout;
while (datePtr <= env.yesterday)
{
if (!csData.ok())
{
//
// Out of data, start with this DatePtr
//
VisitSummaryClass.summarizePeriod(core, env, datePtr, datePtr, 24, core.siteProperties.dataBuildVersion, env.oldestVisitSummaryWeCareAbout);
}
else
{
DateTime workingDate = DateTime.MinValue.AddDays(csData.getInteger("DateNumber"));
if (datePtr < workingDate)
{
//
// There are missing dates, update them
//
VisitSummaryClass.summarizePeriod(core, env, datePtr, workingDate.AddDays(-1), 24, core.siteProperties.dataBuildVersion, env.oldestVisitSummaryWeCareAbout);
}
}
if (csData.ok())
{
//
// if there is more data, go to the next record
//
csData.goNext();
}
datePtr = datePtr.AddDays(1).Date;
}
csData.close();
}
}
}
//
return;
} catch (Exception ex) {
LogController.logError(core, ex);
}
}
//
//====================================================================================================
/// <summary>
/// Get the Configure Edit
/// </summary>
/// <param name="cp"></param>
/// <returns></returns>
public static string get(CPClass cp)
{
CoreController core = cp.core;
try {
KeyPtrController Index = new KeyPtrController();
int ContentId = cp.Doc.GetInteger(RequestNameToolContentId);
var contentMetadata = ContentMetadataModel.create(core, ContentId, true, true);
int RecordCount = 0;
int formFieldId = 0;
string StatusMessage = "";
string ErrorMessage = "";
bool ReloadCDef = cp.Doc.GetBoolean("ReloadCDef");
if (contentMetadata != null)
{
string ToolButton = cp.Doc.GetText("Button");
//
if (!string.IsNullOrEmpty(ToolButton))
{
bool AllowContentAutoLoad = false;
if (ToolButton != ButtonCancel)
{
//
// Save the form changes
//
AllowContentAutoLoad = cp.Site.GetBoolean("AllowContentAutoLoad", true);
cp.Site.SetProperty("AllowContentAutoLoad", "false");
//
// ----- Save the input
//
RecordCount = GenericController.encodeInteger(cp.Doc.GetInteger("dtfaRecordCount"));
if (RecordCount > 0)
{
int RecordPointer = 0;
for (RecordPointer = 0; RecordPointer < RecordCount; RecordPointer++)
{
//
string formFieldName = cp.Doc.GetText("dtfaName." + RecordPointer);
CPContentBaseClass.FieldTypeIdEnum formFieldTypeId = (CPContentBaseClass.FieldTypeIdEnum)cp.Doc.GetInteger("dtfaType." + RecordPointer);
formFieldId = GenericController.encodeInteger(cp.Doc.GetInteger("dtfaID." + RecordPointer));
bool formFieldInherited = cp.Doc.GetBoolean("dtfaInherited." + RecordPointer);
//
// problem - looking for the name in the Db using the form's name, but it could have changed.
// have to look field up by id
//
foreach (KeyValuePair <string, Processor.Models.Domain.ContentFieldMetadataModel> cdefFieldKvp in contentMetadata.fields)
{
if (cdefFieldKvp.Value.id == formFieldId)
{
//
// Field was found in CDef
//
if (cdefFieldKvp.Value.inherited && (!formFieldInherited))
{
//
// Was inherited, but make a copy of the field
//
using (var CSTarget = new CsModel(core)) {
if (CSTarget.insert("Content Fields"))
{
using (var CSSource = new CsModel(core)) {
if (CSSource.openRecord("Content Fields", formFieldId))
{
CSSource.copyRecord(CSTarget);
}
}
formFieldId = CSTarget.getInteger("ID");
CSTarget.set("ContentID", ContentId);
}
CSTarget.close();
}
ReloadCDef = true;
}
else if ((!cdefFieldKvp.Value.inherited) && (formFieldInherited))
{
//
// Was a field, make it inherit from it's parent
MetadataController.deleteContentRecord(core, "Content Fields", formFieldId);
ReloadCDef = true;
}
else if ((!cdefFieldKvp.Value.inherited) && (!formFieldInherited))
{
//
// not inherited, save the field values and mark for a reload
//
{
if (formFieldName.IndexOf(" ") != -1)
{
//
// remoave spaces from new name
//
StatusMessage = StatusMessage + "<LI>Field [" + formFieldName + "] was renamed [" + GenericController.strReplace(formFieldName, " ", "") + "] because the field name can not include spaces.</LI>";
formFieldName = GenericController.strReplace(formFieldName, " ", "");
}
//
string SQL = null;
//
if ((!string.IsNullOrEmpty(formFieldName)) && ((int)formFieldTypeId != 0) && ((cdefFieldKvp.Value.nameLc == "") || (cdefFieldKvp.Value.fieldTypeId == 0)))
{
//
// Create Db field, Field is good but was not before
//
core.db.createSQLTableField(contentMetadata.tableName, formFieldName, formFieldTypeId);
StatusMessage = StatusMessage + "<LI>Field [" + formFieldName + "] was saved to this content definition and a database field was created in [" + contentMetadata.tableName + "].</LI>";
}
else if ((string.IsNullOrEmpty(formFieldName)) || ((int)formFieldTypeId == 0))
{
//
// name blank or type=0 - do nothing but tell them
//
if (string.IsNullOrEmpty(formFieldName) && ((int)formFieldTypeId == 0))
{
ErrorMessage += "<LI>Field number " + (RecordPointer + 1) + " was saved to this content definition but no database field was created because a name and field type are required.</LI>";
}
else if (formFieldName == "unnamedfield" + formFieldId.ToString())
{
ErrorMessage += "<LI>Field number " + (RecordPointer + 1) + " was saved to this content definition but no database field was created because a field name is required.</LI>";
}
else
{
ErrorMessage += "<LI>Field [" + formFieldName + "] was saved to this content definition but no database field was created because a field type are required.</LI>";
}
}
else if ((formFieldName == cdefFieldKvp.Value.nameLc) && (formFieldTypeId != cdefFieldKvp.Value.fieldTypeId))
{
//
// Field Type changed, must be done manually
//
ErrorMessage += "<LI>Field [" + formFieldName + "] changed type from [" + DbBaseModel.getRecordName <ContentFieldTypeModel>(core.cpParent, (int)cdefFieldKvp.Value.fieldTypeId) + "] to [" + DbBaseModel.getRecordName <ContentFieldTypeModel>(core.cpParent, (int)formFieldTypeId) + "]. This may have caused a problem converting content.</LI>";
int DataSourceTypeId = core.db.getDataSourceType();
switch (DataSourceTypeId)
{
case DataSourceTypeODBCMySQL:
SQL = "alter table " + contentMetadata.tableName + " change " + cdefFieldKvp.Value.nameLc + " " + cdefFieldKvp.Value.nameLc + " " + core.db.getSQLAlterColumnType(formFieldTypeId) + ";";
break;
default:
SQL = "alter table " + contentMetadata.tableName + " alter column " + cdefFieldKvp.Value.nameLc + " " + core.db.getSQLAlterColumnType(formFieldTypeId) + ";";
break;
}
core.db.executeNonQuery(SQL);
}
SQL = "Update ccFields"
+ " Set name=" + DbController.encodeSQLText(formFieldName)
+ ",type=" + (int)formFieldTypeId
+ ",caption=" + DbController.encodeSQLText(cp.Doc.GetText("dtfaCaption." + RecordPointer))
+ ",DefaultValue=" + DbController.encodeSQLText(cp.Doc.GetText("dtfaDefaultValue." + RecordPointer))
+ ",EditSortPriority=" + DbController.encodeSQLText(GenericController.encodeText(cp.Doc.GetInteger("dtfaEditSortPriority." + RecordPointer)))
+ ",Active=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaActive." + RecordPointer))
+ ",ReadOnly=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaReadOnly." + RecordPointer))
+ ",Authorable=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaAuthorable." + RecordPointer))
+ ",Required=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaRequired." + RecordPointer))
+ ",UniqueName=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaUniqueName." + RecordPointer))
+ ",TextBuffered=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaTextBuffered." + RecordPointer))
+ ",Password="******"dtfaPassword." + RecordPointer))
+ ",HTMLContent=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaHTMLContent." + RecordPointer))
+ ",EditTab=" + DbController.encodeSQLText(cp.Doc.GetText("dtfaEditTab." + RecordPointer))
+ ",Scramble=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaScramble." + RecordPointer)) + "";
if (core.session.isAuthenticatedAdmin())
{
SQL += ",adminonly=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaAdminOnly." + RecordPointer));
}
if (core.session.isAuthenticatedDeveloper())
{
SQL += ",DeveloperOnly=" + DbController.encodeSQLBoolean(cp.Doc.GetBoolean("dtfaDeveloperOnly." + RecordPointer));
}
SQL += " where ID=" + formFieldId;
core.db.executeNonQuery(SQL);
ReloadCDef = true;
}
}
break;
}
}
}
}
core.cache.invalidateAll();
core.clearMetaData();
}
if (ToolButton == ButtonAdd)
{
//
// ----- Insert a blank Field
var defaultValues = ContentMetadataModel.getDefaultValueDict(core, ContentFieldModel.tableMetadata.contentName);
var field = ContentFieldModel.addDefault <ContentFieldModel>(core.cpParent, defaultValues);
field.name = "unnamedField" + field.id.ToString();
field.contentId = ContentId;
field.editSortPriority = 0;
field.save(core.cpParent);
ReloadCDef = true;
}
//
// ----- Button Reload CDef
if (ToolButton == ButtonSaveandInvalidateCache)
{
core.cache.invalidateAll();
core.clearMetaData();
}
//
// ----- Restore Content Autoload site property
//
if (AllowContentAutoLoad)
{
cp.Site.SetProperty("AllowContentAutoLoad", AllowContentAutoLoad.ToString());
}
//
// ----- Cancel or Save, reload CDef and go
//
if ((ToolButton == ButtonCancel) || (ToolButton == ButtonOK))
{
//
// ----- Exit back to menu
//
return(core.webServer.redirect(core.appConfig.adminRoute, "Tool-ConfigureContentEdit, ok or cancel button, go to root."));
}
}
}
//
// Print Output
string description = ""
+ HtmlController.p("Use this tool to add or modify content definition fields and the underlying sql table fields.")
+ ((ContentId.Equals(0)) ? "" : ""
+ HtmlController.ul(""
+ HtmlController.li(HtmlController.a("Edit Content", "?aa=0&cid=3&id=" + ContentId + "&tx=&ad=0&asf=1&af=4", "nav-link btn btn-primary"), "nav-item mr-1")
+ HtmlController.li(HtmlController.a("Edit Records", "?cid=" + ContentId, "nav-link btn btn-primary"), "nav-item mr-1")
+ HtmlController.li(HtmlController.a("Select Different Fields", "?af=105", "nav-link btn btn-primary"), "nav-item mr-1")
, "nav")
);
StringBuilderLegacyController Stream = new StringBuilderLegacyController();
Stream.add(AdminUIController.getHeaderTitleDescription("Manage Admin Edit Fields", description));
//
// -- status of last operation
if (!string.IsNullOrEmpty(StatusMessage))
{
Stream.add(AdminUIController.getToolFormRow(core, "<UL>" + StatusMessage + "</UL>"));
}
//
// -- errors with last operations
if (!string.IsNullOrEmpty(ErrorMessage))
{
Stream.add(HtmlController.div("There was a problem saving these changes" + "<UL>" + ErrorMessage + "</UL>", "ccError"));
}
if (ReloadCDef)
{
contentMetadata = Processor.Models.Domain.ContentMetadataModel.create(core, ContentId, true, true);
}
string ButtonList = ButtonCancel + "," + ButtonSelect;
if (ContentId == 0)
{
//
// content tables that have edit forms to Configure
bool isEmptyList = false;
Stream.add(AdminUIController.getToolFormInputRow(core, "Select a Content Definition to Configure", AdminUIEditorController.getLookupContentEditor(core, RequestNameToolContentId, ContentId, ContentMetadataModel.getContentId(core, "Content"), ref isEmptyList, false, "", "", false, "")));
}
else
{
//
// Configure edit form
Stream.add(HtmlController.inputHidden(RequestNameToolContentId, ContentId));
Stream.add(core.html.getPanelTop());
ButtonList = ButtonCancel + "," + ButtonSave + "," + ButtonOK + "," + ButtonAdd;
//
// Get a new copy of the content definition
//
Stream.add(SpanClassAdminNormal + "<P><B>" + contentMetadata.name + "</b></P>");
Stream.add("<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" width=\"100%\">");
//
int ParentContentId = contentMetadata.parentId;
bool AllowCDefInherit = false;
Processor.Models.Domain.ContentMetadataModel ParentCDef = null;
if (ParentContentId == -1)
{
AllowCDefInherit = false;
}
else
{
AllowCDefInherit = true;
string ParentContentName = MetadataController.getContentNameByID(core, ParentContentId);
ParentCDef = Processor.Models.Domain.ContentMetadataModel.create(core, ParentContentId, true, true);
}
bool NeedFootNote1 = false;
bool NeedFootNote2 = false;
if (contentMetadata.fields.Count > 0)
{
//
// -- header row
Stream.add("<tr>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\"></td>");
if (!AllowCDefInherit)
{
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Inherited*</b></span></td>");
NeedFootNote1 = true;
}
else
{
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Inherited</b></span></td>");
}
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>Field</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>Caption</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>Edit Tab</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"100\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>Default</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>Type</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b>Edit<br>Order</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Active</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b>Read<br>Only</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Auth</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Req</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Unique</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b>Text<br>Buffer</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b><br>Pass</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "<b>Text<br>Scrm</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b><br>HTML</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b>Admin<br>Only</b></span></td>");
Stream.add("<td valign=\"bottom\" width=\"50\" class=\"ccPanelInput\" align=\"left\">" + SpanClassAdminSmall + "<b>Dev<br>Only</b></span></td>");
Stream.add("</tr>");
RecordCount = 0;
//
// Build a select template for Type
//
string TypeSelectTemplate = core.html.selectFromContent("menuname", -1, "Content Field Types", "", "unknown");
//
// Index the sort order
//
List <FieldSortClass> fieldList = new List <FieldSortClass>();
int FieldCount = contentMetadata.fields.Count;
foreach (var keyValuePair in contentMetadata.fields)
{
FieldSortClass fieldSort = new FieldSortClass();
string sortOrder = "";
fieldSort.field = keyValuePair.Value;
sortOrder = "";
if (fieldSort.field.active)
{
sortOrder += "0";
}
else
{
sortOrder += "1";
}
if (fieldSort.field.authorable)
{
sortOrder += "0";
}
else
{
sortOrder += "1";
}
sortOrder += fieldSort.field.editTabName + getIntegerString(fieldSort.field.editSortPriority, 10) + getIntegerString(fieldSort.field.id, 10);
fieldSort.sort = sortOrder;
fieldList.Add(fieldSort);
}
fieldList.Sort((p1, p2) => p1.sort.CompareTo(p2.sort));
StringBuilderLegacyController StreamValidRows = new StringBuilderLegacyController();
var contentFieldsCdef = Processor.Models.Domain.ContentMetadataModel.createByUniqueName(core, "content fields");
foreach (FieldSortClass fieldsort in fieldList)
{
StringBuilderLegacyController streamRow = new StringBuilderLegacyController();
bool rowValid = true;
//
// If Field has name and type, it is locked and can not be changed
//
bool FieldLocked = (fieldsort.field.nameLc != "") && (fieldsort.field.fieldTypeId != 0);
//
// put the menu into the current menu format
//
formFieldId = fieldsort.field.id;
streamRow.add(HtmlController.inputHidden("dtfaID." + RecordCount, formFieldId));
streamRow.add("<tr>");
//
// edit button
//
streamRow.add("<td class=\"ccPanelInput\" align=\"left\">" + AdminUIController.getRecordEditAnchorTag(core, contentFieldsCdef, formFieldId) + "</td>");
//
// Inherited
//
if (!AllowCDefInherit)
{
//
// no parent
//
streamRow.add("<td class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "False</span></td>");
}
else if (fieldsort.field.inherited)
{
//
// inherited property
//
streamRow.add("<td class=\"ccPanelInput\" align=\"center\">" + HtmlController.checkbox("dtfaInherited." + RecordCount, fieldsort.field.inherited) + "</td>");
}
else
{
Processor.Models.Domain.ContentFieldMetadataModel parentField = null;
//
// CDef has a parent, but the field is non-inherited, test for a matching Parent Field
//
if (ParentCDef == null)
{
foreach (KeyValuePair <string, Processor.Models.Domain.ContentFieldMetadataModel> kvp in ParentCDef.fields)
{
if (kvp.Value.nameLc == fieldsort.field.nameLc)
{
parentField = kvp.Value;
break;
}
}
}
if (parentField == null)
{
streamRow.add("<td class=\"ccPanelInput\" align=\"center\">" + SpanClassAdminSmall + "False**</span></td>");
NeedFootNote2 = true;
}
else
{
streamRow.add("<td class=\"ccPanelInput\" align=\"center\">" + HtmlController.checkbox("dtfaInherited." + RecordCount, fieldsort.field.inherited) + "</td>");
}
}
//
// name
//
bool tmpValue = string.IsNullOrEmpty(fieldsort.field.nameLc);
rowValid = rowValid && !tmpValue;
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
streamRow.add(SpanClassAdminSmall + fieldsort.field.nameLc + " </SPAN>");
}
else if (FieldLocked)
{
streamRow.add(SpanClassAdminSmall + fieldsort.field.nameLc + " </SPAN><input type=hidden name=dtfaName." + RecordCount + " value=\"" + fieldsort.field.nameLc + "\">");
}
else
{
streamRow.add(HtmlController.inputText_Legacy(core, "dtfaName." + RecordCount, fieldsort.field.nameLc, 1, 10));
}
streamRow.add("</nobr></td>");
//
// caption
//
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
streamRow.add(SpanClassAdminSmall + fieldsort.field.caption + "</SPAN>");
}
else
{
streamRow.add(HtmlController.inputText_Legacy(core, "dtfaCaption." + RecordCount, fieldsort.field.caption, 1, 10));
}
streamRow.add("</nobr></td>");
//
// Edit Tab
//
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
streamRow.add(SpanClassAdminSmall + fieldsort.field.editTabName + "</SPAN>");
}
else
{
streamRow.add(HtmlController.inputText_Legacy(core, "dtfaEditTab." + RecordCount, fieldsort.field.editTabName, 1, 10));
}
streamRow.add("</nobr></td>");
//
// default
//
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
streamRow.add(SpanClassAdminSmall + GenericController.encodeText(fieldsort.field.defaultValue) + "</SPAN>");
}
else
{
streamRow.add(HtmlController.inputText_Legacy(core, "dtfaDefaultValue." + RecordCount, GenericController.encodeText(fieldsort.field.defaultValue), 1, 10));
}
streamRow.add("</nobr></td>");
//
// type
//
rowValid = rowValid && (fieldsort.field.fieldTypeId > 0);
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
using (var csData = new CsModel(core)) {
csData.openRecord("Content Field Types", (int)fieldsort.field.fieldTypeId);
if (!csData.ok())
{
streamRow.add(SpanClassAdminSmall + "Unknown[" + fieldsort.field.fieldTypeId + "]</SPAN>");
}
else
{
streamRow.add(SpanClassAdminSmall + csData.getText("Name") + "</SPAN>");
}
}
}
else if (FieldLocked)
{
streamRow.add(DbBaseModel.getRecordName <ContentFieldTypeModel>(core.cpParent, (int)fieldsort.field.fieldTypeId) + HtmlController.inputHidden("dtfaType." + RecordCount, (int)fieldsort.field.fieldTypeId));
}
else
{
string TypeSelect = TypeSelectTemplate;
TypeSelect = GenericController.strReplace(TypeSelect, "menuname", "dtfaType." + RecordCount, 1, 99, 1);
TypeSelect = GenericController.strReplace(TypeSelect, "=\"" + fieldsort.field.fieldTypeId + "\"", "=\"" + fieldsort.field.fieldTypeId + "\" selected", 1, 99, 1);
streamRow.add(TypeSelect);
}
streamRow.add("</nobr></td>");
//
// sort priority
//
streamRow.add("<td class=\"ccPanelInput\" align=\"left\"><nobr>");
if (fieldsort.field.inherited)
{
streamRow.add(SpanClassAdminSmall + fieldsort.field.editSortPriority + "</SPAN>");
}
else
{
streamRow.add(HtmlController.inputText_Legacy(core, "dtfaEditSortPriority." + RecordCount, fieldsort.field.editSortPriority.ToString(), 1, 10));
}
streamRow.add("</nobr></td>");
//
// active
//
streamRow.add(configureEdit_CheckBox("dtfaActive." + RecordCount, fieldsort.field.active, fieldsort.field.inherited));
//
// read only
//
streamRow.add(configureEdit_CheckBox("dtfaReadOnly." + RecordCount, fieldsort.field.readOnly, fieldsort.field.inherited));
//
// authorable
//
streamRow.add(configureEdit_CheckBox("dtfaAuthorable." + RecordCount, fieldsort.field.authorable, fieldsort.field.inherited));
//
// required
//
streamRow.add(configureEdit_CheckBox("dtfaRequired." + RecordCount, fieldsort.field.required, fieldsort.field.inherited));
//
// UniqueName
//
streamRow.add(configureEdit_CheckBox("dtfaUniqueName." + RecordCount, fieldsort.field.uniqueName, fieldsort.field.inherited));
//
// text buffered
//
streamRow.add(configureEdit_CheckBox("dtfaTextBuffered." + RecordCount, fieldsort.field.textBuffered, fieldsort.field.inherited));
//
// password
//
streamRow.add(configureEdit_CheckBox("dtfaPassword." + RecordCount, fieldsort.field.password, fieldsort.field.inherited));
//
// scramble
//
streamRow.add(configureEdit_CheckBox("dtfaScramble." + RecordCount, fieldsort.field.scramble, fieldsort.field.inherited));
//
// HTML Content
//
streamRow.add(configureEdit_CheckBox("dtfaHTMLContent." + RecordCount, fieldsort.field.htmlContent, fieldsort.field.inherited));
//
// Admin Only
//
if (core.session.isAuthenticatedAdmin())
{
streamRow.add(configureEdit_CheckBox("dtfaAdminOnly." + RecordCount, fieldsort.field.adminOnly, fieldsort.field.inherited));
}
//
// Developer Only
//
if (core.session.isAuthenticatedDeveloper())
{
streamRow.add(configureEdit_CheckBox("dtfaDeveloperOnly." + RecordCount, fieldsort.field.developerOnly, fieldsort.field.inherited));
}
//
streamRow.add("</tr>");
RecordCount = RecordCount + 1;
//
// rows are built - put the blank rows at the top
//
if (!rowValid)
{
Stream.add(streamRow.text);
}
else
{
StreamValidRows.add(streamRow.text);
}
}
Stream.add(StreamValidRows.text);
Stream.add(HtmlController.inputHidden("dtfaRecordCount", RecordCount));
}
Stream.add("</table>");
//
Stream.add(core.html.getPanelBottom());
if (NeedFootNote1)
{
Stream.add("<br>*Field Inheritance is not allowed because this Content Definition has no parent.");
}
if (NeedFootNote2)
{
Stream.add("<br>**This field can not be inherited because the Parent Content Definition does not have a field with the same name.");
}
}
Stream.add(HtmlController.inputHidden("ReloadCDef", ReloadCDef));
//
// -- assemble form
return(AdminUIController.getToolForm(core, Stream.text, ButtonList));
} catch (Exception ex) {
LogController.logError(core, ex);
return(toolExceptionMessage);
}
}
//====================================================================================================
/// <summary>
/// Summarize the page views, excludes non-cookie visits, excludes administrator and developer visits, excludes authenticated users with ExcludeFromReporting
/// </summary>
/// <param name="core"></param>
/// <param name="StartTimeDate"></param>
/// <param name="EndTimeDate"></param>
/// <param name="HourDuration"></param>
/// <param name="BuildVersion"></param>
/// <param name="OldestVisitSummaryWeCareAbout"></param>
//
public static void pageViewSummary(CoreController core, DateTime StartTimeDate, DateTime EndTimeDate, int HourDuration, string BuildVersion, DateTime OldestVisitSummaryWeCareAbout)
{
int hint = 0;
string hinttxt = "";
try {
XmlDocument LibraryCollections = new XmlDocument();
XmlDocument LocalCollections = new XmlDocument();
XmlDocument Doc = new XmlDocument();
{
hint = 1;
DateTime PeriodStart = default;
PeriodStart = StartTimeDate;
if (PeriodStart < OldestVisitSummaryWeCareAbout)
{
PeriodStart = OldestVisitSummaryWeCareAbout;
}
DateTime PeriodDatePtr = default;
PeriodDatePtr = PeriodStart.Date;
while (PeriodDatePtr < EndTimeDate)
{
hint = 2;
//
hinttxt = ", HourDuration [" + HourDuration + "], PeriodDatePtr [" + PeriodDatePtr + "], PeriodDatePtr.AddHours(HourDuration / 2.0) [" + PeriodDatePtr.AddHours(HourDuration / 2.0) + "]";
int DateNumber = encodeInteger((PeriodDatePtr - default(DateTime)).TotalDays);
// encodeInteger(PeriodDatePtr.AddHours(HourDuration / 2.0).ToOADate());
int TimeNumber = encodeInteger(PeriodDatePtr.TimeOfDay.TotalHours);
DateTime DateStart = default(DateTime);
DateStart = PeriodDatePtr.Date;
DateTime DateEnd = default(DateTime);
DateEnd = PeriodDatePtr.AddHours(HourDuration).Date;
string PageTitle = "";
int PageId = 0;
int PageViews = 0;
int AuthenticatedPageViews = 0;
int MobilePageViews = 0;
int BotPageViews = 0;
int NoCookiePageViews = 0;
//
// Loop through all the pages hit during this period
//
//
// for now ignore the problem caused by addons like Blogs creating multiple 'pages' within on pageid
// One way to handle this is to expect the addon to set something unquie in he page title
// then use the title to distinguish a page. The problem with this is the current system puts the
// visit number and page number in the name. if we select on district name, they will all be.
//
using (var csPages = new CsModel(core)) {
string sql = "select distinct recordid,pagetitle from ccviewings h"
+ " where (h.recordid<>0)"
+ " and(h.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and (h.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((h.ExcludeFromAnalytics is null)or(h.ExcludeFromAnalytics=0))"
+ "order by recordid";
hint = 3;
if (!csPages.openSql(sql))
{
//
// no hits found - add or update a single record for this day so we know it has been calculated
csPages.open("Page View Summary", "(timeduration=" + HourDuration + ")and(DateNumber=" + DateNumber + ")and(TimeNumber=" + TimeNumber + ")and(pageid=" + PageId + ")and(pagetitle=" + DbController.encodeSQLText(PageTitle) + ")");
if (!csPages.ok())
{
csPages.close();
csPages.insert("Page View Summary");
}
//
if (csPages.ok())
{
csPages.set("name", HourDuration + " hr summary for " + DateTime.MinValue.AddDays(DateNumber) + " " + TimeNumber + ":00, " + PageTitle);
csPages.set("DateNumber", DateNumber);
csPages.set("TimeNumber", TimeNumber);
csPages.set("TimeDuration", HourDuration);
csPages.set("PageViews", PageViews);
csPages.set("PageID", PageId);
csPages.set("PageTitle", PageTitle);
csPages.set("AuthenticatedPageViews", AuthenticatedPageViews);
csPages.set("NoCookiePageViews", NoCookiePageViews);
{
csPages.set("MobilePageViews", MobilePageViews);
csPages.set("BotPageViews", BotPageViews);
}
}
csPages.close();
hint = 4;
}
else
{
hint = 5;
//
// add an entry for each page hit on this day
//
while (csPages.ok())
{
PageId = csPages.getInteger("recordid");
PageTitle = csPages.getText("pagetitle");
string baseCriteria = ""
+ " (h.recordid=" + PageId + ")"
+ " "
+ " and(h.dateadded>=" + DbController.encodeSQLDate(DateStart) + ")"
+ " and(h.dateadded<" + DbController.encodeSQLDate(DateEnd) + ")"
+ " and((v.ExcludeFromAnalytics is null)or(v.ExcludeFromAnalytics=0))"
+ " and((h.ExcludeFromAnalytics is null)or(h.ExcludeFromAnalytics=0))"
+ "";
if (!string.IsNullOrEmpty(PageTitle))
{
baseCriteria = baseCriteria + "and(h.pagetitle=" + DbController.encodeSQLText(PageTitle) + ")";
}
hint = 6;
//
// Total Page Views
using (var csPageViews = new CsModel(core)) {
sql = "select count(h.id) as cnt"
+ " from ccviewings h left join ccvisits v on h.visitid=v.id"
+ " where " + baseCriteria + " and (v.CookieSupport<>0)"
+ "";
csPageViews.openSql(sql);
if (csPageViews.ok())
{
PageViews = csPageViews.getInteger("cnt");
}
}
//
// Authenticated Visits
//
using (var csAuthPages = new CsModel(core)) {
sql = "select count(h.id) as cnt"
+ " from ccviewings h left join ccvisits v on h.visitid=v.id"
+ " where " + baseCriteria + " and(v.CookieSupport<>0)"
+ " and(v.visitAuthenticated<>0)"
+ "";
csAuthPages.openSql(sql);
if (csAuthPages.ok())
{
AuthenticatedPageViews = csAuthPages.getInteger("cnt");
}
}
//
// No Cookie Page Views
//
using (var csNoCookie = new CsModel(core)) {
sql = "select count(h.id) as NoCookiePageViews"
+ " from ccviewings h left join ccvisits v on h.visitid=v.id"
+ " where " + baseCriteria + " and((v.CookieSupport=0)or(v.CookieSupport is null))"
+ "";
csNoCookie.openSql(sql);
if (csNoCookie.ok())
{
NoCookiePageViews = csNoCookie.getInteger("NoCookiePageViews");
}
}
//
//
// Mobile Visits
using (var csMobileVisits = new CsModel(core)) {
sql = "select count(h.id) as cnt"
+ " from ccviewings h left join ccvisits v on h.visitid=v.id"
+ " where " + baseCriteria + " and(v.CookieSupport<>0)"
+ " and(v.mobile<>0)"
+ "";
csMobileVisits.openSql(sql);
if (csMobileVisits.ok())
{
MobilePageViews = csMobileVisits.getInteger("cnt");
}
}
//
// Bot Visits
using (var csBotVisits = new CsModel(core)) {
sql = "select count(h.id) as cnt"
+ " from ccviewings h left join ccvisits v on h.visitid=v.id"
+ " where " + baseCriteria + " and(v.CookieSupport<>0)"
+ " and(v.bot<>0)"
+ "";
csBotVisits.openSql(sql);
if (csBotVisits.ok())
{
BotPageViews = csBotVisits.getInteger("cnt");
}
}
//
// Add or update the Visit Summary Record
//
using (var csPVS = new CsModel(core)) {
if (!csPVS.open("Page View Summary", "(timeduration=" + HourDuration + ")and(DateNumber=" + DateNumber + ")and(TimeNumber=" + TimeNumber + ")and(pageid=" + PageId + ")and(pagetitle=" + DbController.encodeSQLText(PageTitle) + ")"))
{
csPVS.insert("Page View Summary");
}
//
if (csPVS.ok())
{
hint = 11;
string PageName = "";
if (string.IsNullOrEmpty(PageTitle))
{
PageName = MetadataController.getRecordName(core, "page content", PageId);
csPVS.set("name", HourDuration + " hr summary for " + DateTime.MinValue.AddDays(DateNumber) + " " + TimeNumber + ":00, " + PageName);
csPVS.set("PageTitle", PageName);
}
else
{
csPVS.set("name", HourDuration + " hr summary for " + DateTime.MinValue.AddDays(DateNumber) + " " + TimeNumber + ":00, " + PageTitle);
csPVS.set("PageTitle", PageTitle);
}
csPVS.set("DateNumber", DateNumber);
csPVS.set("TimeNumber", TimeNumber);
csPVS.set("TimeDuration", HourDuration);
csPVS.set("PageViews", PageViews);
csPVS.set("PageID", PageId);
csPVS.set("AuthenticatedPageViews", AuthenticatedPageViews);
csPVS.set("NoCookiePageViews", NoCookiePageViews);
hint = 12;
{
csPVS.set("MobilePageViews", MobilePageViews);
csPVS.set("BotPageViews", BotPageViews);
}
}
}
csPages.goNext();
}
}
}
PeriodDatePtr = PeriodDatePtr.AddHours(HourDuration);
}
}
//
return;
} catch (Exception ex) {
LogController.logError(core, ex, "hint [" + hint + "]");
}
}
//
//=============================================================================
// Create a child content
//=============================================================================
//
public static string get(CPClass cp)
{
string result = "";
try {
//
bool IsEmptyList = false;
int ParentContentId = 0;
string ChildContentName = "";
int ChildContentId = 0;
bool AddAdminMenuEntry = false;
StringBuilderLegacyController Content = new StringBuilderLegacyController();
string FieldValue = null;
bool NewGroup = false;
int GroupId = 0;
string NewGroupName = "";
string Button = null;
string Caption = null;
string Description = "";
string ButtonList = "";
bool BlockForm = false;
//
Button = cp.core.docProperties.getText(RequestNameButton);
if (Button == ButtonCancel)
{
//
//
//
return(cp.core.webServer.redirect("/" + cp.core.appConfig.adminRoute, "GetContentChildTool, Cancel Button Pressed"));
}
else if (!cp.core.session.isAuthenticatedAdmin())
{
//
//
//
ButtonList = ButtonCancel;
Content.add(AdminUIController.getFormBodyAdminOnly());
}
else
{
//
if (Button != ButtonOK)
{
//
// Load defaults
//
ParentContentId = cp.core.docProperties.getInteger("ParentContentID");
if (ParentContentId == 0)
{
ParentContentId = ContentMetadataModel.getContentId(cp.core, "Page Content");
}
AddAdminMenuEntry = true;
GroupId = 0;
}
else
{
//
// Process input
//
ParentContentId = cp.core.docProperties.getInteger("ParentContentID");
var parentContentMetadata = ContentMetadataModel.create(cp.core, ParentContentId);
ChildContentName = cp.core.docProperties.getText("ChildContentName");
AddAdminMenuEntry = cp.core.docProperties.getBoolean("AddAdminMenuEntry");
GroupId = cp.core.docProperties.getInteger("GroupID");
NewGroup = cp.core.docProperties.getBoolean("NewGroup");
NewGroupName = cp.core.docProperties.getText("NewGroupName");
//
if ((parentContentMetadata == null) || (string.IsNullOrEmpty(ChildContentName)))
{
Processor.Controllers.ErrorController.addUserError(cp.core, "You must select a parent and provide a child name.");
}
else
{
//
// Create Definition
//
Description = Description + "<div> </div>"
+ "<div>Creating content [" + ChildContentName + "] from [" + parentContentMetadata.name + "]</div>";
var childContentMetadata = parentContentMetadata.createContentChild(cp.core, ChildContentName, cp.core.session.user.id);
ChildContentId = ContentMetadataModel.getContentId(cp.core, ChildContentName);
//
// Create Group and Rule
//
if (NewGroup && (!string.IsNullOrEmpty(NewGroupName)))
{
using (var csData = new CsModel(cp.core)) {
csData.open("Groups", "name=" + DbController.encodeSQLText(NewGroupName));
if (csData.ok())
{
Description = Description + "<div>Group [" + NewGroupName + "] already exists, using existing group.</div>";
GroupId = csData.getInteger("ID");
}
else
{
Description = Description + "<div>Creating new group [" + NewGroupName + "]</div>";
csData.close();
csData.insert("Groups");
if (csData.ok())
{
GroupId = csData.getInteger("ID");
csData.set("Name", NewGroupName);
csData.set("Caption", NewGroupName);
}
}
}
}
if (GroupId != 0)
{
using (var csData = new CsModel(cp.core)) {
csData.insert("Group Rules");
if (csData.ok())
{
Description = Description + "<div>Assigning group [" + MetadataController.getRecordName(cp.core, "Groups", GroupId) + "] to edit content [" + ChildContentName + "].</div>";
csData.set("GroupID", GroupId);
csData.set("ContentID", ChildContentId);
}
}
}
//
// Add Admin Menu Entry
//
if (AddAdminMenuEntry)
{
//
// Add Navigator entries
}
//
Description = Description + "<div> </div>"
+ "<div>Your new content is ready. <a href=\"?" + rnAdminForm + "=22\">Click here</a> to create another Content Definition, or hit [Cancel] to return to the main menu.</div>";
ButtonList = ButtonCancel;
BlockForm = true;
}
cp.core.clearMetaData();
cp.core.cache.invalidateAll();
}
//
// Get the form
//
if (!BlockForm)
{
string tableBody = "";
//
FieldValue = "<select size=\"1\" name=\"ParentContentID\" ID=\"\"><option value=\"\">Select One</option>";
FieldValue = FieldValue + GetContentChildTool_Options(cp, 0, ParentContentId);
FieldValue = FieldValue + "</select>";
tableBody += AdminUIController.getEditRowLegacy(cp.core, FieldValue, "Parent Content Name", "", false, false, "");
//
FieldValue = HtmlController.inputText_Legacy(cp.core, "ChildContentName", ChildContentName, 1, 40);
tableBody += AdminUIController.getEditRowLegacy(cp.core, FieldValue, "New Child Content Name", "", false, false, "");
//
FieldValue = ""
+ HtmlController.inputRadio("NewGroup", false.ToString(), NewGroup.ToString()) + cp.core.html.selectFromContent("GroupID", GroupId, "Groups", "", "", "", ref IsEmptyList) + "(Select a current group)"
+ "<br>" + HtmlController.inputRadio("NewGroup", true.ToString(), NewGroup.ToString()) + HtmlController.inputText_Legacy(cp.core, "NewGroupName", NewGroupName) + "(Create a new group)";
tableBody += AdminUIController.getEditRowLegacy(cp.core, FieldValue, "Content Manager Group", "", false, false, "");
//
Content.add(AdminUIController.editTable(tableBody));
Content.add("</td></tr>" + kmaEndTable);
//
ButtonList = ButtonOK + "," + ButtonCancel;
}
Content.add(HtmlController.inputHidden(rnAdminSourceForm, AdminFormContentChildTool));
}
//
Caption = "Create Content Definition";
Description = "<div>This tool is used to create content definitions that help segregate your content into authorable segments.</div>" + Description;
result = AdminUIController.getToolBody(cp.core, Caption, ButtonList, "", false, false, Description, "", 0, Content.text);
} catch (Exception ex) {
LogController.logError(cp.core, ex);
}
return(result);
}
//
//====================================================================================================
/// <summary>
/// add a link alias to a page as the primary
/// </summary>
public static void addLinkAlias(CoreController core, string linkAlias, int pageId, string queryStringSuffix, bool overRideDuplicate, bool dupCausesWarning, ref string return_WarningMessage)
{
string hint = "";
try {
//
LogController.logTrace(core, "addLinkAlias, enter, linkAlias [" + linkAlias + "], pageID [" + pageId + "], queryStringSuffix [" + queryStringSuffix + "], overRideDuplicate [" + overRideDuplicate + "], dupCausesWarning [" + dupCausesWarning + "]");
//
const string SafeStringLc = "0123456789abcdefghijklmnopqrstuvwxyz-_/.";
bool AllowLinkAlias = core.siteProperties.getBoolean("allowLinkAlias", true);
//
string normalizedLinkAlias = linkAlias;
if (!string.IsNullOrEmpty(normalizedLinkAlias))
{
//
// remove nonsafe URL characters
string Src = normalizedLinkAlias.Replace('\t', ' ');
normalizedLinkAlias = "";
for (int srcPtr = 0; srcPtr < Src.Length; srcPtr++)
{
string TestChr = Src.Substring(srcPtr, 1).ToLowerInvariant();
if (!SafeStringLc.Contains(TestChr))
{
TestChr = "\t";
}
normalizedLinkAlias += TestChr;
}
int Ptr = 0;
while (normalizedLinkAlias.Contains("\t\t") && (Ptr < 100))
{
normalizedLinkAlias = GenericController.strReplace(normalizedLinkAlias, "\t\t", "\t");
Ptr = Ptr + 1;
}
if (normalizedLinkAlias.Substring(normalizedLinkAlias.Length - 1) == "\t")
{
normalizedLinkAlias = normalizedLinkAlias.left(normalizedLinkAlias.Length - 1);
}
if (normalizedLinkAlias.left(1) == "\t")
{
normalizedLinkAlias = normalizedLinkAlias.Substring(1);
}
normalizedLinkAlias = GenericController.strReplace(normalizedLinkAlias, "\t", "-");
if (!string.IsNullOrEmpty(normalizedLinkAlias))
{
if (normalizedLinkAlias.left(1) != "/")
{
normalizedLinkAlias = "/" + normalizedLinkAlias;
}
//
LogController.logTrace(core, "addLinkAlias, normalized normalizedLinkAlias [" + normalizedLinkAlias + "]");
//
// Make sure there is not a folder or page in the wwwroot that matches this Alias
//
if (GenericController.toLCase(normalizedLinkAlias) == GenericController.toLCase("/" + core.appConfig.name))
{
//
// This alias points to the cclib folder
//
if (AllowLinkAlias)
{
return_WarningMessage = ""
+ "The Link Alias being created (" + normalizedLinkAlias + ") can not be used because there is a virtual directory in your website directory that already uses this name."
+ " Please change it to ensure the Link Alias is unique. To set or change the Link Alias, use the Link Alias tab and select a name not used by another page.";
}
}
else if (GenericController.toLCase(normalizedLinkAlias) == "/cclib")
{
//
// This alias points to the cclib folder
//
if (AllowLinkAlias)
{
return_WarningMessage = ""
+ "The Link Alias being created (" + normalizedLinkAlias + ") can not be used because there is a virtual directory in your website directory that already uses this name."
+ " Please change it to ensure the Link Alias is unique. To set or change the Link Alias, use the Link Alias tab and select a name not used by another page.";
}
}
else if (core.wwwFiles.pathExists(core.appConfig.localWwwPath + "\\" + normalizedLinkAlias.Substring(1)))
{
//
// This alias points to a different link, call it an error
//
if (AllowLinkAlias)
{
return_WarningMessage = ""
+ "The Link Alias being created (" + normalizedLinkAlias + ") can not be used because there is a folder in your website directory that already uses this name."
+ " Please change it to ensure the Link Alias is unique. To set or change the Link Alias, use the Link Alias tab and select a name not used by another page.";
}
}
else
{
//
// Make sure there is one here for this
//
bool flushLinkAliasCache = false;
int linkAliasId = 0;
using (var csData = new CsModel(core)) {
csData.open("Link Aliases", "name=" + DbController.encodeSQLText(normalizedLinkAlias), "", false, 0, "Name,PageID,QueryStringSuffix");
if (!csData.ok())
{
//
LogController.logTrace(core, "addLinkAlias, not found in Db, add");
//
// Alias not found, create a Link Aliases
//
csData.close();
csData.insert("Link Aliases");
if (csData.ok())
{
csData.set("Name", normalizedLinkAlias);
csData.set("Pageid", pageId);
csData.set("QueryStringSuffix", queryStringSuffix);
flushLinkAliasCache = true;
}
}
else
{
int recordPageId = csData.getInteger("pageID");
string recordQss = csData.getText("QueryStringSuffix").ToLowerInvariant();
//
LogController.logTrace(core, "addLinkAlias, linkalias record found by its name, record recordPageId [" + recordPageId + "], record QueryStringSuffix [" + recordQss + "]");
//
// Alias found, verify the pageid & QueryStringSuffix
//
int CurrentLinkAliasId = 0;
bool resaveLinkAlias = false;
if ((recordQss == queryStringSuffix.ToLowerInvariant()) && (pageId == recordPageId))
{
CurrentLinkAliasId = csData.getInteger("id");
//
LogController.logTrace(core, "addLinkAlias, linkalias matches name, pageid, and querystring of linkalias [" + CurrentLinkAliasId + "]");
//
// it maches a current entry for this link alias, if the current entry is not the highest number id,
// remove it and add this one
//
string sql = "select top 1 id from ccLinkAliases where (pageid=" + recordPageId + ")and(QueryStringSuffix=" + DbController.encodeSQLText(queryStringSuffix) + ") order by id desc";
using (var CS3 = new CsModel(core)) {
CS3.openSql(sql);
if (CS3.ok())
{
resaveLinkAlias = (CurrentLinkAliasId != CS3.getInteger("id"));
}
}
if (resaveLinkAlias)
{
//
LogController.logTrace(core, "addLinkAlias, another link alias matches this pageId and QS. Move this to the top position");
//
core.db.executeNonQuery("delete from ccLinkAliases where id=" + CurrentLinkAliasId);
using (var CS3 = new CsModel(core)) {
CS3.insert("Link Aliases");
if (CS3.ok())
{
CS3.set("Name", normalizedLinkAlias);
CS3.set("Pageid", pageId);
CS3.set("QueryStringSuffix", queryStringSuffix);
}
}
}
}
else
{
//
LogController.logTrace(core, "addLinkAlias, linkalias matches name, but pageid and querystring are different. Add this a newest linkalias");
//
// link alias matches, but id/qs does not -- this is either a change, or a duplicate that needs to be blocked
//
if (overRideDuplicate)
{
//
LogController.logTrace(core, "addLinkAlias, overRideDuplicate true, change the Link Alias to the new link");
//
// change the Link Alias to the new link
csData.set("Pageid", pageId);
csData.set("QueryStringSuffix", queryStringSuffix);
flushLinkAliasCache = true;
}
else if (dupCausesWarning)
{
//
LogController.logTrace(core, "addLinkAlias, overRideDuplicate false, dupCausesWarning true, just return user warning if this is from admin");
//
if (recordPageId == 0)
{
int PageContentCId = Models.Domain.ContentMetadataModel.getContentId(core, "Page Content");
return_WarningMessage = ""
+ "This page has been saved, but the Link Alias could not be created (" + normalizedLinkAlias + ") because it is already in use for another page."
+ " To use Link Aliasing (friendly page names) for this page, the Link Alias value must be unique on this site. To set or change the Link Alias, clicke the Link Alias tab and select a name not used by another page or a folder in your website.";
}
else
{
int PageContentCid = Models.Domain.ContentMetadataModel.getContentId(core, "Page Content");
return_WarningMessage = ""
+ "This page has been saved, but the Link Alias could not be created (" + normalizedLinkAlias + ") because it is already in use for another page (<a href=\"?af=4&cid=" + PageContentCid + "&id=" + recordPageId + "\">edit</a>)."
+ " To use Link Aliasing (friendly page names) for this page, the Link Alias value must be unique. To set or change the Link Alias, click the Link Alias tab and select a name not used by another page or a folder in your website.";
}
}
}
}
linkAliasId = csData.getInteger("id");
csData.close();
}
if (flushLinkAliasCache)
{
//
// -- invalidate all linkAlias
core.cache.invalidateDbRecord(linkAliasId, LinkAliasModel.tableMetadata.tableNameLower);
//
// -- invalidate routemap
Models.Domain.RouteMapModel.invalidateCache(core);
core.routeMapCacheClear();
}
}
}
}
//
LogController.logTrace(core, "addLinkAlias, exit");
//
} catch (Exception ex) {
LogController.logError(core, ex, "addLinkAlias exception, hint [" + hint + "]");
throw;
}
}
//
//====================================================================================================
/// <summary>
/// Send the Member his username and password
/// </summary>
/// <param name="Email"></param>
/// <returns></returns>
public static bool sendPassword(CoreController core, string Email, ref string returnUserMessage)
{
bool result = false;
returnUserMessage = "";
try {
const string passwordChrs = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ012345678999999";
const int passwordChrsLength = 62;
//
string workingEmail = GenericController.encodeText(Email);
//
string Message = "";
string FromAddress = "";
string subject = "";
if (string.IsNullOrEmpty(workingEmail))
{
ErrorController.addUserError(core, "Please enter your email address before requesting your username and password.");
}
else
{
int atPtr = GenericController.strInstr(1, workingEmail, "@");
if (atPtr < 2)
{
//
// email not valid
//
ErrorController.addUserError(core, "Please enter a valid email address before requesting your username and password.");
}
else
{
string EMailName = strMid(workingEmail, 1, atPtr - 1);
//
LogController.addSiteActivity(core, "password request for email " + workingEmail, core.session.user.id, core.session.user.organizationId);
//
bool allowEmailLogin = core.siteProperties.getBoolean("allowEmailLogin", false);
int recordCnt = 0;
using (var csData = new CsModel(core)) {
string sqlCriteria = "(email=" + DbController.encodeSQLText(workingEmail) + ")";
sqlCriteria = sqlCriteria + "and((dateExpires is null)or(dateExpires>" + DbController.encodeSQLDate(core.dateTimeNowMockable) + "))";
csData.open("People", sqlCriteria, "ID", true, core.session.user.id, "username,password", 1);
if (!csData.ok())
{
//
// valid login account for this email not found
//
if (encodeText(strMid(workingEmail, atPtr + 1)).ToLowerInvariant() == "contensive.com")
{
//
// look for expired account to renew
//
csData.close();
csData.open("People", "((email=" + DbController.encodeSQLText(workingEmail) + "))", "ID");
if (csData.ok())
{
//
// renew this old record
//
csData.set("developer", "1");
csData.set("admin", "1");
if (csData.getDate("dateExpires") > DateTime.MinValue)
{
csData.set("dateExpires", core.dateTimeNowMockable.AddDays(7).Date.ToString());
}
}
else
{
//
// inject support record
//
csData.close();
csData.insert("people");
csData.set("name", "Contensive Support");
csData.set("email", workingEmail);
csData.set("developer", "1");
csData.set("admin", "1");
csData.set("dateExpires", core.dateTimeNowMockable.AddDays(7).Date.ToString());
}
}
else
{
ErrorController.addUserError(core, "No current user was found matching this email address. Please try again. ");
}
}
if (csData.ok())
{
FromAddress = core.siteProperties.getText("EmailFromAddress", "info@" + core.webServer.requestDomain);
subject = "Password Request at " + core.webServer.requestDomain;
Message = "";
while (csData.ok())
{
bool updateUser = false;
if (string.IsNullOrEmpty(Message))
{
Message = "This email was sent in reply to a request at " + core.webServer.requestDomain + " for the username and password associated with this email address. ";
Message += "If this request was made by you, please return to the login screen and use the following:\r\n";
Message += Environment.NewLine;
}
else
{
Message += Environment.NewLine;
Message += "Additional user accounts with the same email address: \r\n";
}
//
// username
//
string Username = csData.getText("Username");
bool usernameOK = true;
int Ptr = 0;
if (!allowEmailLogin)
{
if (Username != Username.Trim())
{
Username = Username.Trim();
updateUser = true;
}
if (string.IsNullOrEmpty(Username))
{
usernameOK = false;
Ptr = 0;
while (!usernameOK && (Ptr < 100))
{
Username = EMailName + encodeInteger(Math.Floor(encodeNumber(Microsoft.VisualBasic.VBMath.Rnd() * 9999)));
usernameOK = !core.session.isLoginOK(Username, "test");
Ptr = Ptr + 1;
}
if (usernameOK)
{
updateUser = true;
}
}
Message += " username: "******"Password");
if (Password.Trim() != Password)
{
Password = Password.Trim();
updateUser = true;
}
if (string.IsNullOrEmpty(Password))
{
for (Ptr = 0; Ptr <= 8; Ptr++)
{
int Index = encodeInteger(Microsoft.VisualBasic.VBMath.Rnd() * passwordChrsLength);
Password = Password + strMid(passwordChrs, Index, 1);
}
updateUser = true;
}
Message += " password: "******"username", Username);
csData.set("password", Password);
}
recordCnt = recordCnt + 1;
}
csData.goNext();
}
}
}
}
}
if (result)
{
string sendStatus = "";
EmailController.queueAdHocEmail(core, "Password Email", core.session.user.id, workingEmail, FromAddress, subject, Message, "", "", "", true, false, 0, ref sendStatus);
}
} catch (Exception ex) {
LogController.logError(core, ex);
throw;
}
return(result);
}
//
//======================================================================================================
//
public static void installNode(CoreController core, XmlNode AddonNode, string AddonGuidFieldName, int CollectionID, ref bool return_UpgradeOK, ref string return_ErrorMessage, ref bool collectionIncludesDiagnosticAddons)
{
// todo - return bool
return_ErrorMessage = "";
return_UpgradeOK = true;
try {
string Basename = GenericController.toLCase(AddonNode.Name);
if ((Basename == "page") || (Basename == "process") || (Basename == "addon") || (Basename == "add-on"))
{
bool IsFound = false;
string addonName = XmlController.getXMLAttribute(core, ref IsFound, AddonNode, "name", "No Name");
if (string.IsNullOrEmpty(addonName))
{
addonName = "No Name";
}
string addonGuid = XmlController.getXMLAttribute(core, ref IsFound, AddonNode, "guid", addonName);
if (string.IsNullOrEmpty(addonGuid))
{
addonGuid = addonName;
}
string navTypeName = XmlController.getXMLAttribute(core, ref IsFound, AddonNode, "type", "");
int navTypeId = getListIndex(navTypeName, navTypeIDList);
if (navTypeId == 0)
{
navTypeId = NavTypeIDAddon;
}
using (var cs = new CsModel(core)) {
string Criteria = "(" + AddonGuidFieldName + "=" + DbController.encodeSQLText(addonGuid) + ")";
cs.open(AddonModel.tableMetadata.contentName, Criteria, "", false);
if (cs.ok())
{
//
// Update the Addon
//
LogController.logInfo(core, MethodInfo.GetCurrentMethod().Name + ", UpgradeAppFromLocalCollection, GUID match with existing Add-on, Updating Add-on [" + addonName + "], Guid [" + addonGuid + "]");
}
else
{
//
// not found by GUID - search name against name to update legacy Add-ons
//
cs.close();
Criteria = "(name=" + DbController.encodeSQLText(addonName) + ")and(" + AddonGuidFieldName + " is null)";
cs.open(AddonModel.tableMetadata.contentName, Criteria, "", false);
if (cs.ok())
{
LogController.logInfo(core, MethodInfo.GetCurrentMethod().Name + ", UpgradeAppFromLocalCollection, Add-on name matched an existing Add-on that has no GUID, Updating legacy Aggregate Function to Add-on [" + addonName + "], Guid [" + addonGuid + "]");
}
}
if (!cs.ok())
{
//
// not found by GUID or by name, Insert a new addon
//
cs.close();
cs.insert(AddonModel.tableMetadata.contentName);
if (cs.ok())
{
LogController.logInfo(core, MethodInfo.GetCurrentMethod().Name + ", UpgradeAppFromLocalCollection, Creating new Add-on [" + addonName + "], Guid [" + addonGuid + "]");
}
}
if (!cs.ok())
{
//
// Could not create new Add-on
//
LogController.logInfo(core, MethodInfo.GetCurrentMethod().Name + ", UpgradeAppFromLocalCollection, Add-on could not be created, skipping Add-on [" + addonName + "], Guid [" + addonGuid + "]");
}
else
{
int addonId = cs.getInteger("ID");
MetadataController.deleteContentRecords(core, "Add-on Include Rules", "addonid=" + addonId);
MetadataController.deleteContentRecords(core, "Add-on Content Trigger Rules", "addonid=" + addonId);
//
cs.set("collectionid", CollectionID);
cs.set(AddonGuidFieldName, addonGuid);
cs.set("name", addonName);
cs.set("navTypeId", navTypeId);
var ArgumentList = new StringBuilder();
var StyleSheet = new StringBuilder();
if (AddonNode.ChildNodes.Count > 0)
{
foreach (XmlNode Addonfield in AddonNode.ChildNodes)
{
if (!(Addonfield is XmlComment))
{
XmlNode PageInterface = Addonfield;
string fieldName = null;
string FieldValue = "";
switch (GenericController.toLCase(Addonfield.Name))
{
case "activexdll": {
//
// This is handled in BuildLocalCollectionFolder
//
break;
}
case "editors": {
//
// list of editors
//
foreach (XmlNode TriggerNode in Addonfield.ChildNodes)
{
//
int fieldTypeId = 0;
string fieldType = null;
switch (GenericController.toLCase(TriggerNode.Name))
{
case "type": {
fieldType = TriggerNode.InnerText;
fieldTypeId = MetadataController.getRecordIdByUniqueName(core, "Content Field Types", fieldType);
if (fieldTypeId > 0)
{
using (var CS2 = new CsModel(core)) {
Criteria = "(addonid=" + addonId + ")and(contentfieldTypeID=" + fieldTypeId + ")";
CS2.open("Add-on Content Field Type Rules", Criteria);
if (!CS2.ok())
{
CS2.insert("Add-on Content Field Type Rules");
}
if (CS2.ok())
{
CS2.set("addonid", addonId);
CS2.set("contentfieldTypeID", fieldTypeId);
}
}
}
break;
}
default: {
// do nothing
break;
}
}
}
break;
}
case "processtriggers": {
//
// list of events that trigger a process run for this addon
//
foreach (XmlNode TriggerNode in Addonfield.ChildNodes)
{
switch (GenericController.toLCase(TriggerNode.Name))
{
case "contentchange": {
int TriggerContentId = 0;
string ContentNameorGuid = TriggerNode.InnerText;
if (string.IsNullOrEmpty(ContentNameorGuid))
{
ContentNameorGuid = XmlController.getXMLAttribute(core, ref IsFound, TriggerNode, "guid", "");
if (string.IsNullOrEmpty(ContentNameorGuid))
{
ContentNameorGuid = XmlController.getXMLAttribute(core, ref IsFound, TriggerNode, "name", "");
}
}
using (var CS2 = new CsModel(core)) {
Criteria = "(ccguid=" + DbController.encodeSQLText(ContentNameorGuid) + ")";
CS2.open("Content", Criteria);
if (!CS2.ok())
{
Criteria = "(ccguid is null)and(name=" + DbController.encodeSQLText(ContentNameorGuid) + ")";
CS2.open("content", Criteria);
}
if (CS2.ok())
{
TriggerContentId = CS2.getInteger("ID");
}
}
if (TriggerContentId != 0)
{
using (var CS2 = new CsModel(core)) {
Criteria = "(addonid=" + addonId + ")and(contentid=" + TriggerContentId + ")";
CS2.open("Add-on Content Trigger Rules", Criteria);
if (!CS2.ok())
{
CS2.insert("Add-on Content Trigger Rules");
if (CS2.ok())
{
CS2.set("addonid", addonId);
CS2.set("contentid", TriggerContentId);
}
}
CS2.close();
}
}
break;
}
default: {
// do nothing
break;
}
}
}
break;
}
case "scripting": {
//
// include add-ons - NOTE - import collections must be run before interfaces
// when importing a collectin that will be used for an include
int scriptinglanguageid = (int)AddonController.ScriptLanguages.VBScript;
string ScriptingLanguage = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "language", "").ToLowerInvariant();
if (ScriptingLanguage.Equals("javascript") || ScriptingLanguage.Equals("jscript"))
{
scriptinglanguageid = (int)AddonController.ScriptLanguages.Javascript;
}
cs.set("scriptinglanguageid", scriptinglanguageid);
string ScriptingEntryPoint = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "entrypoint", "");
cs.set("ScriptingEntryPoint", ScriptingEntryPoint);
int ScriptingTimeout = GenericController.encodeInteger(XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "timeout", "5000"));
cs.set("ScriptingTimeout", ScriptingTimeout);
string ScriptingCode = "";
foreach (XmlNode ScriptingNode in Addonfield.ChildNodes)
{
switch (GenericController.toLCase(ScriptingNode.Name))
{
case "code": {
ScriptingCode += ScriptingNode.InnerText;
break;
}
default: {
// do nothing
break;
}
}
}
cs.set("ScriptingCode", ScriptingCode);
break;
}
case "activexprogramid": {
//
// save program id
//
FieldValue = Addonfield.InnerText;
cs.set("ObjectProgramID", FieldValue);
break;
}
case "navigator": {
//
// create a navigator entry with a parent set to this
//
cs.save();
string menuNameSpace = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "NameSpace", "");
if (!string.IsNullOrEmpty(menuNameSpace))
{
string NavIconTypeString = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "type", "");
if (string.IsNullOrEmpty(NavIconTypeString))
{
NavIconTypeString = "Addon";
}
BuildController.verifyNavigatorEntry(core, new MetadataMiniCollectionModel.MiniCollectionMenuModel {
menuNameSpace = menuNameSpace,
name = addonName,
adminOnly = false,
developerOnly = false,
newWindow = false,
active = true,
addonName = addonName,
navIconType = NavIconTypeString,
navIconTitle = addonName
}, CollectionID);
}
break;
}
case "argument":
case "argumentlist": {
//
// multiple argumentlist elements are concatinated with crlf
ArgumentList.Append(Addonfield.InnerText.Trim(' ') + Environment.NewLine);
break;
}
case "style": {
//
// import exclusive style
//
string NodeName = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "name", "");
string NewValue = encodeText(Addonfield.InnerText).Trim(' ');
if (NewValue.left(1) != "{")
{
NewValue = "{" + NewValue;
}
if (NewValue.Substring(NewValue.Length - 1) != "}")
{
NewValue += "}";
}
StyleSheet.Append(NodeName + " " + NewValue + Environment.NewLine);
break;
}
case "stylesheet":
case "styles": {
//
// import exclusive stylesheet if more then whitespace
//
string test = Addonfield.InnerText;
test = strReplace(test, " ", "");
test = strReplace(test, "\r", "");
test = strReplace(test, "\n", "");
test = strReplace(test, "\t", "");
if (!string.IsNullOrEmpty(test))
{
StyleSheet.Append(Addonfield.InnerText + Environment.NewLine);
}
break;
}
case "template":
case "content":
case "admin": {
//
// these add-ons will be "non-developer only" in navigation
//
fieldName = Addonfield.Name;
FieldValue = Addonfield.InnerText;
if (!cs.isFieldSupported(fieldName))
{
//
// Bad field name - need to report it somehow
//
}
else
{
cs.set(fieldName, FieldValue);
if (GenericController.encodeBoolean(Addonfield.InnerText))
{
//
// if template, admin or content - let non-developers have navigator entry
//
}
}
break;
}
case "icon": {
//
// icon
//
FieldValue = XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "link", "");
if (!string.IsNullOrEmpty(FieldValue))
{
//
// Icons can be either in the root of the website or in content files
//
FieldValue = GenericController.strReplace(FieldValue, "\\", "/"); // make it a link, not a file
if (GenericController.strInstr(1, FieldValue, "://") != 0)
{
//
// the link is an absolute URL, leave it link this
//
}
else
{
if (FieldValue.left(1) != "/")
{
//
// make sure it starts with a slash to be consistance
//
FieldValue = "/" + FieldValue;
}
if (FieldValue.left(17) == "/contensivefiles/")
{
//
// in content files, start link without the slash
//
FieldValue = FieldValue.Substring(17);
}
}
cs.set("IconFilename", FieldValue);
{
cs.set("IconWidth", GenericController.encodeInteger(XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "width", "0")));
cs.set("IconHeight", GenericController.encodeInteger(XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "height", "0")));
cs.set("IconSprites", GenericController.encodeInteger(XmlController.getXMLAttribute(core, ref IsFound, Addonfield, "sprites", "0")));
}
}
break;
}
case "includeaddon":
case "includeadd-on":
case "include addon":
case "include add-on": {
//
// processed in phase2 of this routine, after all the add-ons are installed
//
break;
}
case "form": {
//
// The value of this node is the xml instructions to create a form. Take then
// entire node, children and all, and save them in the formxml field.
// this replaces the settings add-on type, and soo to be report add-on types as well.
// this removes the ccsettingpages and settingcollectionrules, etc.
//
{
cs.set("formxml", Addonfield.InnerXml);
}
break;
}
case "javascript":
case "javascriptinhead": {
//
// these all translate to JSFilename
//
fieldName = "jsfilename";
cs.set(fieldName, Addonfield.InnerText);
break;
}
case "iniframe": {
//
// typo - field is inframe
//
fieldName = "inframe";
cs.set(fieldName, Addonfield.InnerText);
break;
}
case "diagnostic": {
bool fieldValue = encodeBoolean(Addonfield.InnerText);
cs.set("diagnostic", fieldValue);
collectionIncludesDiagnosticAddons = collectionIncludesDiagnosticAddons || fieldValue;
break;
}
case "category": {
if (!string.IsNullOrWhiteSpace(Addonfield.InnerText))
{
AddonCategoryModel category = DbBaseModel.createByUniqueName <AddonCategoryModel>(core.cpParent, Addonfield.InnerText);
if (category == null)
{
category = DbBaseModel.addDefault <AddonCategoryModel>(core.cpParent);
category.name = Addonfield.InnerText;
category.save(core.cpParent);
}
cs.set("addonCategoryId", category.id);
}
break;
}
case "instancesettingprimarycontentid": {
int lookupContentId = 0;
if (!string.IsNullOrWhiteSpace(Addonfield.InnerText))
{
ContentModel lookupContent = DbBaseModel.createByUniqueName <ContentModel>(core.cpParent, Addonfield.InnerText);
if (lookupContent != null)
{
lookupContentId = lookupContent.id;
}
}
cs.set("instancesettingprimarycontentid", lookupContentId);
break;
}
default: {
//
// All the other fields should match the Db fields
//
fieldName = Addonfield.Name;
FieldValue = Addonfield.InnerText;
if (!cs.isFieldSupported(fieldName))
{
//
// Bad field name - need to report it somehow
//
LogController.logError(core, new ApplicationException("bad field found [" + fieldName + "], in addon node [" + addonName + "], of collection [" + MetadataController.getRecordName(core, "add-on collections", CollectionID) + "]"));
}
else
{
cs.set(fieldName, FieldValue);
}
break;
}
}
}
}
}
cs.set("ArgumentList", ArgumentList.ToString());
cs.set("StylesFilename", StyleSheet.ToString());
}
cs.close();
}
}
} catch (Exception ex) {
LogController.logError(core, ex);
throw;
}
}
//
//====================================================================================================
//
public static string get(CoreController core)
{
string result = "";
try {
string Button = core.docProperties.getText("Button");
if (Button == ButtonCancelAll)
{
//
// Cancel to the admin site
return(core.webServer.redirect(core.appConfig.adminRoute, "Tools-List, cancel button"));
}
//
const string RequestNameAddField = "addfield";
const string RequestNameAddFieldId = "addfieldID";
StringBuilderLegacyController Stream = new StringBuilderLegacyController();
Stream.add(AdminUIController.getHeaderTitleDescription("Configure Admin Listing", "Configure the Administration Content Listing Page."));
//
// Load Request
int ToolsAction = core.docProperties.getInteger("dta");
int TargetFieldID = core.docProperties.getInteger("fi");
int ContentId = core.docProperties.getInteger(RequestNameToolContentId);
string FieldNameToAdd = GenericController.toUCase(core.docProperties.getText(RequestNameAddField));
int FieldIDToAdd = core.docProperties.getInteger(RequestNameAddFieldId);
string ButtonList = ButtonCancel + "," + ButtonSelect;
bool ReloadCDef = core.docProperties.getBoolean("ReloadCDef");
bool AllowContentAutoLoad = false;
//
//--------------------------------------------------------------------------------
// Process actions
//--------------------------------------------------------------------------------
//
if (ContentId != 0)
{
ButtonList = ButtonCancel + "," + ButtonSaveandInvalidateCache;
string ContentName = Local_GetContentNameByID(core, ContentId);
Processor.Models.Domain.ContentMetadataModel CDef = Processor.Models.Domain.ContentMetadataModel.create(core, ContentId, false, true);
string FieldName = null;
int ColumnWidthTotal = 0;
int fieldId = 0;
if (ToolsAction != 0)
{
//
// Block contentautoload, then force a load at the end
//
AllowContentAutoLoad = (core.siteProperties.getBoolean("AllowContentAutoLoad", true));
core.siteProperties.setProperty("AllowContentAutoLoad", false);
int SourceContentId = 0;
string SourceName = null;
//
// Make sure the FieldNameToAdd is not-inherited, if not, create new field
//
if (FieldIDToAdd != 0)
{
foreach (var keyValuePair in CDef.fields)
{
Processor.Models.Domain.ContentFieldMetadataModel field = keyValuePair.Value;
if (field.id == FieldIDToAdd)
{
if (field.inherited)
{
SourceContentId = field.contentId;
SourceName = field.nameLc;
using (var CSSource = new CsModel(core)) {
CSSource.open("Content Fields", "(ContentID=" + SourceContentId + ")and(Name=" + DbController.encodeSQLText(SourceName) + ")");
if (CSSource.ok())
{
using (var CSTarget = new CsModel(core)) {
CSTarget.insert("Content Fields");
if (CSTarget.ok())
{
CSSource.copyRecord(CSTarget);
CSTarget.set("ContentID", ContentId);
ReloadCDef = true;
}
}
}
}
}
break;
}
}
}
//
// Make sure all fields are not-inherited, if not, create new fields
//
int ColumnNumberMax = 0;
foreach (var keyValuePair in CDef.adminColumns)
{
Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass adminColumn = keyValuePair.Value;
Processor.Models.Domain.ContentFieldMetadataModel field = CDef.fields[adminColumn.Name];
if (field.inherited)
{
SourceContentId = field.contentId;
SourceName = field.nameLc;
using (var CSSource = new CsModel(core)) {
if (CSSource.open("Content Fields", "(ContentID=" + SourceContentId + ")and(Name=" + DbController.encodeSQLText(SourceName) + ")"))
{
using (var CSTarget = new CsModel(core)) {
if (CSTarget.insert("Content Fields"))
{
CSSource.copyRecord(CSTarget);
CSTarget.set("ContentID", ContentId);
ReloadCDef = true;
}
}
}
}
}
if (ColumnNumberMax < field.indexColumn)
{
ColumnNumberMax = field.indexColumn;
}
ColumnWidthTotal += adminColumn.Width;
}
//
// ----- Perform any actions first
//
int columnPtr = 0;
bool MoveNextColumn = false;
switch (ToolsAction)
{
case ToolsActionAddField: {
//
// Add a field to the Listing Page
//
if (FieldIDToAdd != 0)
{
columnPtr = 0;
if (CDef.adminColumns.Count > 1)
{
foreach (var keyValuePair in CDef.adminColumns)
{
Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass adminColumn = keyValuePair.Value;
Processor.Models.Domain.ContentFieldMetadataModel field = CDef.fields[adminColumn.Name];
using (var csData = new CsModel(core)) {
csData.openRecord("Content Fields", field.id);
csData.set("IndexColumn", (columnPtr) * 10);
csData.set("IndexWidth", Math.Floor((adminColumn.Width * 80) / (double)ColumnWidthTotal));
}
columnPtr += 1;
}
}
using (var csData = new CsModel(core)) {
if (csData.openRecord("Content Fields", FieldIDToAdd))
{
csData.set("IndexColumn", columnPtr * 10);
csData.set("IndexWidth", 20);
csData.set("IndexSortPriority", 99);
csData.set("IndexSortDirection", 1);
}
}
ReloadCDef = true;
}
//
break;
}
case ToolsActionRemoveField: {
//
// Remove a field to the Listing Page
//
if (CDef.adminColumns.Count > 1)
{
columnPtr = 0;
foreach (var keyValuePair in CDef.adminColumns)
{
Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass adminColumn = keyValuePair.Value;
Processor.Models.Domain.ContentFieldMetadataModel field = CDef.fields[adminColumn.Name];
using (var csData = new CsModel(core)) {
csData.openRecord("Content Fields", field.id);
if (fieldId == TargetFieldID)
{
csData.set("IndexColumn", 0);
csData.set("IndexWidth", 0);
csData.set("IndexSortPriority", 0);
csData.set("IndexSortDirection", 0);
}
else
{
csData.set("IndexColumn", (columnPtr) * 10);
csData.set("IndexWidth", Math.Floor((adminColumn.Width * 100) / (double)ColumnWidthTotal));
}
}
columnPtr += 1;
}
ReloadCDef = true;
}
break;
}
case ToolsActionMoveFieldRight: {
//
// Move column field right
//
if (CDef.adminColumns.Count > 1)
{
MoveNextColumn = false;
columnPtr = 0;
foreach (var keyValuePair in CDef.adminColumns)
{
Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass adminColumn = keyValuePair.Value;
Processor.Models.Domain.ContentFieldMetadataModel field = CDef.fields[adminColumn.Name];
FieldName = adminColumn.Name;
using (var csData = new CsModel(core)) {
csData.openRecord("Content Fields", field.id);
if ((CDef.fields[FieldName.ToLowerInvariant()].id == TargetFieldID) && (columnPtr < CDef.adminColumns.Count))
{
csData.set("IndexColumn", (columnPtr + 1) * 10);
//
MoveNextColumn = true;
}
else if (MoveNextColumn)
{
//
// This is one past target
//
csData.set("IndexColumn", (columnPtr - 1) * 10);
MoveNextColumn = false;
}
else
{
//
// not target or one past target
//
csData.set("IndexColumn", (columnPtr) * 10);
MoveNextColumn = false;
}
csData.set("IndexWidth", Math.Floor((adminColumn.Width * 100) / (double)ColumnWidthTotal));
}
columnPtr += 1;
}
ReloadCDef = true;
}
// end case
break;
}
case ToolsActionMoveFieldLeft: {
//
// Move Index column field left
//
if (CDef.adminColumns.Count > 1)
{
MoveNextColumn = false;
columnPtr = 0;
foreach (var keyValuePair in CDef.adminColumns.Reverse())
{
Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass adminColumn = keyValuePair.Value;
Processor.Models.Domain.ContentFieldMetadataModel field = CDef.fields[adminColumn.Name];
FieldName = adminColumn.Name;
using (var csData = new CsModel(core)) {
csData.openRecord("Content Fields", field.id);
if ((field.id == TargetFieldID) && (columnPtr < CDef.adminColumns.Count))
{
csData.set("IndexColumn", (columnPtr - 1) * 10);
//
MoveNextColumn = true;
}
else if (MoveNextColumn)
{
//
// This is one past target
//
csData.set("IndexColumn", (columnPtr + 1) * 10);
MoveNextColumn = false;
}
else
{
//
// not target or one past target
//
csData.set("IndexColumn", (columnPtr) * 10);
MoveNextColumn = false;
}
csData.set("IndexWidth", Math.Floor((adminColumn.Width * 100) / (double)ColumnWidthTotal));
}
columnPtr += 1;
}
ReloadCDef = true;
}
break;
}
default: {
// do nothing
break;
}
}
//
// Get a new copy of the content definition
//
CDef = Processor.Models.Domain.ContentMetadataModel.create(core, ContentId, false, true);
}
if (Button == ButtonSaveandInvalidateCache)
{
core.cache.invalidateAll();
core.clearMetaData();
return(core.webServer.redirect("?af=" + AdminFormToolConfigureListing + "&ContentID=" + ContentId, "Tools-ConfigureListing, Save and Invalidate Cache, Go to back ConfigureListing tools"));
}
//
//--------------------------------------------------------------------------------
// Display the form
//--------------------------------------------------------------------------------
//
if (!string.IsNullOrEmpty(ContentName))
{
Stream.add("<br><br><B>" + ContentName + "</b><br>");
}
Stream.add("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"99%\"><tr>");
Stream.add("<td width=\"5%\"> </td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>10%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>20%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>30%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>40%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>50%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>60%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>70%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>80%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>90%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>100%</nobr></td>");
Stream.add("<td width=\"4%\" align=\"center\"> </td>");
Stream.add("</tr></TABLE>");
//
Stream.add("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"99%\"><tr>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.gif\" width=\"1\" height=\"10\"><IMG alt=\"\" src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/Images/spacer.gif\" width=\"100%\" height=\"10\"></nobr></td>");
Stream.add("</tr></TABLE>");
//
// print the column headers
//
ColumnWidthTotal = 0;
int InheritedFieldCount = 0;
if (CDef.adminColumns.Count > 0)
{
//
// Calc total width
//
foreach (KeyValuePair <string, Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass> kvp in CDef.adminColumns)
{
ColumnWidthTotal += kvp.Value.Width;
}
if (ColumnWidthTotal > 0)
{
Stream.add("<table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"90%\">");
int ColumnCount = 0;
foreach (KeyValuePair <string, Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass> kvp in CDef.adminColumns)
{
//
// print column headers - anchored so they sort columns
//
int ColumnWidth = encodeInteger(100 * (kvp.Value.Width / (double)ColumnWidthTotal));
FieldName = kvp.Value.Name;
var tempVar = CDef.fields[FieldName.ToLowerInvariant()];
fieldId = tempVar.id;
string Caption = tempVar.caption;
if (tempVar.inherited)
{
Caption += "*";
InheritedFieldCount += 1;
}
string AStart = "<A href=\"" + core.webServer.requestPage + "?" + RequestNameToolContentId + "=" + ContentId + "&af=" + AdminFormToolConfigureListing + "&fi=" + fieldId + "&dtcn=" + ColumnCount;
Stream.add("<td width=\"" + ColumnWidth + "%\" valign=\"top\" align=\"left\">" + SpanClassAdminNormal + Caption + "<br>");
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/black.GIF\" width=\"100%\" height=\"1\">");
Stream.add(AStart + "&dta=" + ToolsActionRemoveField + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonDeleteUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionMoveFieldRight + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonMoveRightUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionMoveFieldLeft + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonMoveLeftUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionSetAZ + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonSortazUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionSetZA + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonSortzaUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionExpand + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonOpenUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A><br>");
Stream.add(AStart + "&dta=" + ToolsActionContract + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonCloseUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A>");
Stream.add("</SPAN></td>");
ColumnCount += 1;
}
Stream.add("</tr>");
Stream.add("</TABLE>");
}
}
//
// ----- If anything was inherited, put up the message
//
if (InheritedFieldCount > 0)
{
Stream.add("<P class=\"ccNormal\">* This field was inherited from the Content Definition's Parent. Inherited fields will automatically change when the field in the parent is changed. If you alter these settings, this connection will be broken, and the field will no longer inherit it's properties.</P class=\"ccNormal\">");
}
//
// ----- now output a list of fields to add
//
if (CDef.fields.Count == 0)
{
Stream.add(SpanClassAdminNormal + "This Content Definition has no fields</SPAN><br>");
}
else
{
Stream.add(SpanClassAdminNormal + "<br>");
bool skipField = false;
foreach (KeyValuePair <string, Processor.Models.Domain.ContentFieldMetadataModel> keyValuePair in CDef.fields)
{
Processor.Models.Domain.ContentFieldMetadataModel field = keyValuePair.Value;
//
// test if this column is in use
//
skipField = false;
if (CDef.adminColumns.Count > 0)
{
foreach (KeyValuePair <string, Processor.Models.Domain.ContentMetadataModel.MetaAdminColumnClass> kvp in CDef.adminColumns)
{
if (field.nameLc == kvp.Value.Name)
{
skipField = true;
break;
}
}
}
//
// display the column if it is not in use
//
if (skipField)
{
if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileText)
{
//
// text filename can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (text file field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileCSS)
{
//
// text filename can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (css file field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileXML)
{
//
// text filename can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (xml file field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileJavascript)
{
//
// text filename can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (javascript file field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.LongText)
{
//
// long text can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (long text field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileImage)
{
//
// long text can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (image field)<br>");
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.Redirect)
{
//
// long text can not be search
//
Stream.add("<IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/Spacer.gif\" width=\"50\" height=\"15\" border=\"0\"> " + field.caption + " (redirect field)<br>");
}
else
{
//
// can be used as column header
//
Stream.add("<A href=\"" + core.webServer.requestPage + "?" + RequestNameToolContentId + "=" + ContentId + "&af=" + AdminFormToolConfigureListing + "&fi=" + field.id + "&dta=" + ToolsActionAddField + "&" + RequestNameAddFieldId + "=" + field.id + "\"><IMG src=\"https://s3.amazonaws.com/cdn.contensive.com/assets/20200122/images/LibButtonAddUp.gif\" width=\"50\" height=\"15\" border=\"0\"></A> " + field.caption + "<br>");
}
}
}
}
}
//
//--------------------------------------------------------------------------------
// print the content tables that have Listing Pages to Configure
//--------------------------------------------------------------------------------
//
string FormPanel = SpanClassAdminNormal + "Select a Content Definition to Configure its Listing Page<br>";
FormPanel += core.html.selectFromContent("ContentID", ContentId, "Content");
Stream.add(core.html.getPanel(FormPanel));
core.siteProperties.setProperty("AllowContentAutoLoad", AllowContentAutoLoad);
Stream.add(HtmlController.inputHidden("ReloadCDef", ReloadCDef));
result = AdminUIController.getToolForm(core, Stream.text, ButtonList);
} catch (Exception ex) {
LogController.logError(core, ex);
}
return(result);
}
//
//====================================================================================================
//
public static string get(CoreController core)
{
string result = "";
try {
//
int ContentId = 0;
string TableName = "";
string ContentName = "";
StringBuilderLegacyController Stream = new StringBuilderLegacyController();
string ButtonList = null;
string Description = null;
string Caption = null;
int NavId = 0;
int ParentNavId = 0;
DataSourceModel datasource = DataSourceModel.create(core.cpParent, core.docProperties.getInteger("DataSourceID"));
//
ButtonList = ButtonCancel + "," + ButtonRun;
Caption = "Create Content Definition";
Description = "This tool creates a Content Definition. If the SQL table exists, it is used. If it does not exist, it is created. If records exist in the table with a blank ContentControlID, the ContentControlID will be populated from this new definition. A Navigator Menu entry will be added under Manage Site Content - Advanced.";
//
// print out the submit form
//
if (core.docProperties.getText("Button") != "")
{
//
// Process input
//
ContentName = core.docProperties.getText("ContentName");
TableName = core.docProperties.getText("TableName");
//
Stream.add(SpanClassAdminSmall);
Stream.add("<P>Creating content [" + ContentName + "] on table [" + TableName + "] on Datasource [" + datasource.name + "].</P>");
if ((!string.IsNullOrEmpty(ContentName)) && (!string.IsNullOrEmpty(TableName)) && (!string.IsNullOrEmpty(datasource.name)))
{
using (var db = new DbController(core, datasource.name)) {
db.createSQLTable(TableName);
}
ContentMetadataModel.createFromSQLTable(core, datasource, TableName, ContentName);
core.cache.invalidateAll();
core.clearMetaData();
ContentId = Processor.Models.Domain.ContentMetadataModel.getContentId(core, ContentName);
ParentNavId = MetadataController.getRecordIdByUniqueName(core, NavigatorEntryModel.tableMetadata.contentName, "Manage Site Content");
if (ParentNavId != 0)
{
ParentNavId = 0;
using (var csSrc = new CsModel(core)) {
if (csSrc.open(NavigatorEntryModel.tableMetadata.contentName, "(name=" + DbController.encodeSQLText("Advanced") + ")and(parentid=" + ParentNavId + ")"))
{
ParentNavId = csSrc.getInteger("ID");
}
}
if (ParentNavId != 0)
{
using (var csDest = new CsModel(core)) {
csDest.open(NavigatorEntryModel.tableMetadata.contentName, "(name=" + DbController.encodeSQLText(ContentName) + ")and(parentid=" + NavId + ")");
if (!csDest.ok())
{
csDest.close();
csDest.insert(NavigatorEntryModel.tableMetadata.contentName);
}
if (csDest.ok())
{
csDest.set("name", ContentName);
csDest.set("parentid", ParentNavId);
csDest.set("contentid", ContentId);
}
}
}
}
ContentId = ContentMetadataModel.getContentId(core, ContentName);
Stream.add("<P>Content Definition was created. An admin menu entry for this definition has been added under 'Site Content', and will be visible on the next page view. Use the [<a href=\"?af=105&ContentID=" + ContentId + "\">Edit Content Definition Fields</a>] tool to review and edit this definition's fields.</P>");
}
else
{
Stream.add("<P>Error, a required field is missing. Content not created.</P>");
}
Stream.add("</SPAN>");
}
Stream.add(SpanClassAdminNormal);
Stream.add("Data Source<br>");
Stream.add(core.html.selectFromContent("DataSourceID", datasource.id, "Data Sources", "", "Default"));
Stream.add("<br><br>");
Stream.add("Content Name<br>");
Stream.add(HtmlController.inputText_Legacy(core, "ContentName", ContentName, 1, 40));
Stream.add("<br><br>");
Stream.add("Table Name<br>");
Stream.add(HtmlController.inputText_Legacy(core, "TableName", TableName, 1, 40));
Stream.add("<br><br>");
Stream.add("</SPAN>");
result = AdminUIController.getToolBody(core, Caption, ButtonList, "", false, false, Description, "", 10, Stream.text);
} catch (Exception ex) {
LogController.logError(core, ex);
}
return(result);
}
//
//========================================================================
//
public static string get(CoreController core)
{
try {
//
string Button = null;
string SQL = null;
string RQS = null;
int PageSize = 0;
int PageNumber = 0;
int TopCount = 0;
int RowPointer = 0;
int DataRowCount = 0;
string PreTableCopy = "";
string PostTableCopy = "";
int ColumnPtr = 0;
string[] ColCaption = null;
string[] ColAlign = null;
string[] ColWidth = null;
string[,] Cells = null;
string AdminURL = null;
int RowCnt = 0;
int RowPtr = 0;
int ContentId = 0;
string Format = null;
string Name = null;
string title = null;
string Description = null;
string ButtonCommaListLeft = null;
string ButtonCommaListRight = null;
int ContentPadding = 0;
string ContentSummary = "";
StringBuilderLegacyController Tab0 = new StringBuilderLegacyController();
StringBuilderLegacyController Tab1 = new StringBuilderLegacyController();
string Content = "";
string SQLFieldName = null;
var adminMenu = new EditTabModel();
//
const int ColumnCnt = 4;
//
Button = core.docProperties.getText(RequestNameButton);
ContentId = core.docProperties.getInteger("ContentID");
Format = core.docProperties.getText("Format");
//
title = "Custom Report Manager";
Description = "Custom Reports are a way for you to create a snapshot of data to view or download. To request a report, select the Custom Reports tab, check the report(s) you want, and click the [Request Download] Button. When your report is ready, it will be available in the <a href=\"?" + rnAdminForm + "=30\">Download Manager</a>. To create a new custom report, select the Request New Report tab, enter a name and SQL statement, and click the Apply button.";
ContentPadding = 0;
ButtonCommaListLeft = ButtonCancel + "," + ButtonDelete + "," + ButtonRequestDownload;
ButtonCommaListRight = "";
SQLFieldName = "SQLQuery";
//
if (!core.session.isAuthenticatedAdmin())
{
//
// Must be a developer
//
Description = Description + "You can not access the Custom Report Manager because your account is not configured as an administrator.";
}
else
{
//
// Process Requests
//
if (!string.IsNullOrEmpty(Button))
{
switch (Button)
{
case ButtonCancel:
return(core.webServer.redirect("/" + core.appConfig.adminRoute, "CustomReports, Cancel Button Pressed"));
case ButtonDelete:
RowCnt = core.docProperties.getInteger("RowCnt");
if (RowCnt > 0)
{
for (RowPtr = 0; RowPtr < RowCnt; RowPtr++)
{
if (core.docProperties.getBoolean("Row" + RowPtr))
{
MetadataController.deleteContentRecord(core, "Custom Reports", core.docProperties.getInteger("RowID" + RowPtr));
}
}
}
break;
case ButtonRequestDownload:
case ButtonApply:
//
Name = core.docProperties.getText("name");
SQL = core.docProperties.getText(SQLFieldName);
if (!string.IsNullOrEmpty(Name) || !string.IsNullOrEmpty(SQL))
{
if ((string.IsNullOrEmpty(Name)) || (string.IsNullOrEmpty(SQL)))
{
Processor.Controllers.ErrorController.addUserError(core, "A name and SQL Query are required to save a new custom report.");
}
else
{
int customReportId = 0;
using (var csData = new CsModel(core)) {
csData.insert("Custom Reports");
if (csData.ok())
{
customReportId = csData.getInteger("id");
csData.set("Name", Name);
csData.set(SQLFieldName, SQL);
}
csData.close();
}
requestDownload(core, customReportId);
}
}
//
RowCnt = core.docProperties.getInteger("RowCnt");
if (RowCnt > 0)
{
for (RowPtr = 0; RowPtr < RowCnt; RowPtr++)
{
if (core.docProperties.getBoolean("Row" + RowPtr))
{
int customReportId = core.docProperties.getInteger("RowID" + RowPtr);
using (var csData = new CsModel(core)) {
csData.openRecord("Custom Reports", customReportId);
if (csData.ok())
{
SQL = csData.getText(SQLFieldName);
Name = csData.getText("Name");
}
}
requestDownload(core, customReportId);
}
}
}
break;
}
}
//
// Build Tab0
//
Tab0.add("<p>The following is a list of available custom reports.</p>");
//
RQS = core.doc.refreshQueryString;
PageSize = core.docProperties.getInteger(RequestNamePageSize);
if (PageSize == 0)
{
PageSize = 50;
}
PageNumber = core.docProperties.getInteger(RequestNamePageNumber);
if (PageNumber == 0)
{
PageNumber = 1;
}
AdminURL = "/" + core.appConfig.adminRoute;
TopCount = PageNumber * PageSize;
//
// Setup Headings
//
ColCaption = new string[ColumnCnt + 1];
ColAlign = new string[ColumnCnt + 1];
ColWidth = new string[ColumnCnt + 1];
Cells = new string[PageSize + 1, ColumnCnt + 1];
//
ColCaption[ColumnPtr] = "Select<br><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=10 height=1>";
ColAlign[ColumnPtr] = "center";
ColWidth[ColumnPtr] = "10";
ColumnPtr = ColumnPtr + 1;
//
ColCaption[ColumnPtr] = "Name";
ColAlign[ColumnPtr] = "left";
ColWidth[ColumnPtr] = "100%";
ColumnPtr = ColumnPtr + 1;
//
ColCaption[ColumnPtr] = "Created By<br><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=100 height=1>";
ColAlign[ColumnPtr] = "left";
ColWidth[ColumnPtr] = "100";
ColumnPtr = ColumnPtr + 1;
//
ColCaption[ColumnPtr] = "Date Created<br><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=150 height=1>";
ColAlign[ColumnPtr] = "left";
ColWidth[ColumnPtr] = "150";
ColumnPtr = ColumnPtr + 1;
//
// Get Data
//
using (var csData = new CsModel(core)) {
RowPointer = 0;
if (!csData.open("Custom Reports"))
{
Cells[0, 1] = "There are no custom reports defined";
RowPointer = 1;
}
else
{
DataRowCount = csData.getRowCount();
while (csData.ok() && (RowPointer < PageSize))
{
int customReportId = csData.getInteger("ID");
Cells[RowPointer, 0] = HtmlController.checkbox("Row" + RowPointer) + HtmlController.inputHidden("RowID" + RowPointer, customReportId);
Cells[RowPointer, 1] = csData.getText("name");
Cells[RowPointer, 2] = csData.getText("CreatedBy");
Cells[RowPointer, 3] = csData.getDate("DateAdded").ToShortDateString();
RowPointer = RowPointer + 1;
csData.goNext();
}
}
csData.close();
}
string Cell = null;
Tab0.add(HtmlController.inputHidden("RowCnt", RowPointer));
Cell = AdminUIController.getReport(core, RowPointer, ColCaption, ColAlign, ColWidth, Cells, PageSize, PageNumber, PreTableCopy, PostTableCopy, DataRowCount, "ccPanel");
Tab0.add("<div>" + Cell + "</div>");
//
// Build RequestContent Form
//
Tab1.add("<p>Use this form to create a new custom report. Enter the SQL Query for the report, and a name that will be used as a caption.</p>");
//
Tab1.add("<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\" width=\"100%\">");
//
Tab1.add("<tr>");
Tab1.add("<td align=right>Name</td>");
Tab1.add("<td>" + HtmlController.inputText_Legacy(core, "Name", "", 1, 40) + "</td>");
Tab1.add("</tr>");
//
Tab1.add("<tr>");
Tab1.add("<td align=right>SQL Query</td>");
Tab1.add("<td>" + HtmlController.inputText_Legacy(core, SQLFieldName, "", 8, 40) + "</td>");
Tab1.add("</tr>");
//
Tab1.add("<tr><td width=\"120\"><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"120\" height=\"1\"></td><td width=\"100%\"> </td></tr></table>");
//
// Build and add tabs
//
adminMenu.addEntry("Custom Reports", Tab0.text, "ccAdminTab");
adminMenu.addEntry("Request New Report", Tab1.text, "ccAdminTab");
Content = adminMenu.getTabs(core);
//
}
//
core.html.addTitle("Custom Reports");
//
return(AdminUIController.getToolBody(core, title, ButtonCommaListLeft, ButtonCommaListRight, true, true, Description, ContentSummary, ContentPadding, Content));
} catch (Exception ex) {
LogController.logError(core, ex);
return(toolExceptionMessage);
}
}
//
//====================================================================================================
/// <summary>
/// Returns OK on success
/// + available drive space
/// + log size
/// </summary>
/// <param name="cp"></param>
/// <returns></returns>
public override object Execute(Contensive.BaseClasses.CPBaseClass cp)
{
try {
var result = new StringBuilder();
var core = ((CPClass)cp).core;
//
// -- tmp, check for 10% free on C-drive and D-drive
if (Directory.Exists(@"c:\"))
{
DriveInfo driveTest = new DriveInfo("c");
double freeSpace = Math.Round(100.0 * (Convert.ToDouble(driveTest.AvailableFreeSpace) / Convert.ToDouble(driveTest.TotalSize)), 2);
if (freeSpace < 10)
{
return("ERROR, Drive-C does not have 10% free");
}
result.AppendLine("ok, drive-c free space [" + freeSpace + "%], [" + (driveTest.AvailableFreeSpace / (1024 * 1024)).ToString("F2", CultureInfo.InvariantCulture) + " MB]");
}
if (Directory.Exists(@"d:\"))
{
DriveInfo driveTest = new DriveInfo("d");
double freeSpace = Math.Round(100.0 * (Convert.ToDouble(driveTest.AvailableFreeSpace) / Convert.ToDouble(driveTest.TotalSize)), 2);
if (freeSpace < 10)
{
return("ERROR, Drive-D does not have 10% free");
}
result.AppendLine("ok, drive-D free space [" + freeSpace + "%], [" + (driveTest.AvailableFreeSpace / (1024 * 1024)).ToString("F2", CultureInfo.InvariantCulture) + " MB]");
}
//
// -- log files under 1MB
if (!core.programDataFiles.pathExists("Logs/"))
{
core.programDataFiles.createPath("Logs/");
}
foreach (var fileDetail in core.programDataFiles.getFileList("Logs/"))
{
if (fileDetail.Size > 1000000)
{
return("ERROR, log file size error [" + fileDetail.Name + "], size [" + fileDetail.Size + "]");
}
}
result.AppendLine("ok, all log files under 1 MB");
//
// test default data connection
try {
using (var csData = new CsModel(core)) {
int recordId = 0;
if (csData.insert("Properties"))
{
recordId = csData.getInteger("ID");
}
if (recordId == 0)
{
return("ERROR, Failed to insert record in default data source.");
}
else
{
MetadataController.deleteContentRecord(core, "Properties", recordId);
}
}
} catch (Exception exDb) {
return("ERROR, exception occured during default data source record insert, [" + exDb + "].");
}
result.AppendLine("ok, database connection passed.");
//
// -- test for taskscheduler not running
if (DbBaseModel.createList <AddonModel>(core.cpParent, "(ProcessNextRun<" + DbController.encodeSQLDate(core.dateTimeNowMockable.AddHours(-1)) + ")").Count > 0)
{
return("ERROR, there are process addons unexecuted for over 1 hour. TaskScheduler may not be enabled, or no server is running the Contensive Task Service.");
}
if (DbBaseModel.createList <TaskModel>(core.cpParent, "(dateCompleted is null)and(dateStarted<" + DbController.encodeSQLDate(core.dateTimeNowMockable.AddHours(-1)) + ")").Count > 0)
{
return("ERROR, there are tasks that have been executing for over 1 hour. The Task Runner Server may have stopped.");
}
result.AppendLine("ok, taskscheduler running.");
//
// -- test for taskrunner not running
if (DbBaseModel.createList <TaskModel>(core.cpParent, "(dateCompleted is null)and(dateStarted is null)").Count > 100)
{
return("ERROR, there are over 100 task waiting to be execute. The Task Runner Server may have stopped.");
}
result.AppendLine("ok, taskrunner running.");
//
// -- verify the email process is running.
if (cp.Site.GetDate("EmailServiceLastCheck") < core.dateTimeNowMockable.AddHours(-1))
{
return("ERROR, Email process has not executed for over 1 hour.");
}
result.AppendLine("ok, email process running.");
//
// -- last -- if alarm folder is not empty, fail diagnostic. Last so others can add an alarm entry
if (!core.programDataFiles.pathExists("Alarms/"))
{
core.programDataFiles.createPath("Alarms/");
}
foreach (var alarmFile in core.programDataFiles.getFileList("Alarms/"))
{
return("ERROR, Alarm folder is not empty, [" + core.programDataFiles.readFileText("Alarms/" + alarmFile.Name) + "].");
}
// -- verify the default username=root, password=contensive is not present
var rootUserList = PersonModel.createList <PersonModel>(cp, "((username='******')and(password='******')and(active>0))");
if (rootUserList.Count > 0)
{
return("ERROR, delete or inactive default user root/contensive.");
}
//
// -- meta data test- lookup field without lookup set
string sql = "select c.id as contentid, c.name as contentName, f.* from ccfields f left join ccContent c on c.id = f.LookupContentID where f.Type = 7 and c.id is null and f.LookupContentID > 0 and f.Active > 0 and f.Authorable > 0";
using (DataTable dt = core.db.executeQuery(sql)) {
if (!dt.Rows.Count.Equals(0))
{
string badFieldList = "";
foreach (DataRow row in dt.Rows)
{
badFieldList += "," + row["contentName"] + "." + row["name"].ToString();
}
return("ERROR, the following field(s) are configured as lookup, but the field's lookup-content is not set [" + badFieldList.Substring(1) + "].");
}
}
//
// -- metadata test - many to many setup
sql = "select f.id,f.name as fieldName,f.ManyToManyContentID, f.ManyToManyRuleContentID, f.ManyToManyRulePrimaryField, f.ManyToManyRuleSecondaryField"
+ " ,pc.name as primaryContentName"
+ " , sc.name as secondaryContentName"
+ " , r.name as ruleContentName"
+ " , rp.name as PrimaryContentField"
+ " , rs.name as SecondaryContentField"
+ " from ccfields f"
+ " left join cccontent sc on sc.id = f.ManyToManyContentID"
+ " left join cccontent pc on pc.id = f.contentid"
+ " left join cccontent r on r.id = f.ManyToManyRuleContentID"
+ " left join ccfields rp on (rp.name = f.ManyToManyRulePrimaryField)and(rp.ContentID = r.id)"
+ " left join ccfields rs on(rs.name = f.ManyToManyRuleSecondaryField)and(rs.ContentID = r.id)"
+ " where"
+ " (f.type = 14)and(f.Authorable > 0)and(f.active > 0)"
+ " and((1 = 0)or(sc.id is null)or(pc.id is null)or(r.id is null)or(rp.id is null)or(rs.id is null))";
using (DataTable dt = core.db.executeQuery(sql)) {
if (!dt.Rows.Count.Equals(0))
{
string badFieldList = "";
foreach (DataRow row in dt.Rows)
{
badFieldList += "," + row["primaryContentName"] + "." + row["fieldName"].ToString();
}
return("ERROR, the following field(s) are configured as many-to-many, but the field's many-to-many metadata is not set [" + badFieldList.Substring(1) + "].");
}
}
return("ok, all server diagnostics passed" + Environment.NewLine + result.ToString());
} catch (Exception ex) {
cp.Site.ErrorReport(ex);
return("ERROR, unexpected exception during diagnostics");
}
}
//
//=============================================================================
// Print the Configure Index Form
//=============================================================================
//
public static string get(CPClass cp, CoreController core, AdminDataModel adminData)
{
string result = "";
try {
// todo refactor out
ContentMetadataModel adminContent = adminData.adminContent;
string Button = core.docProperties.getText(RequestNameButton);
if (Button == ButtonOK)
{
//
// -- Process OK, remove subform from querystring and return empty
cp.Doc.AddRefreshQueryString(RequestNameAdminSubForm, "");
return(result);
}
//
// Load Request
if (Button == ButtonReset)
{
//
// -- Process reset
core.userProperty.setProperty(AdminDataModel.IndexConfigPrefix + adminContent.id.ToString(), "");
}
IndexConfigClass IndexConfig = IndexConfigClass.get(core, adminData);
int ToolsAction = core.docProperties.getInteger("dta");
int TargetFieldId = core.docProperties.getInteger("fi");
string TargetFieldName = core.docProperties.getText("FieldName");
int ColumnPointer = core.docProperties.getInteger("dtcn");
const string RequestNameAddField = "addfield";
string FieldNameToAdd = GenericController.toUCase(core.docProperties.getText(RequestNameAddField));
const string RequestNameAddFieldId = "addfieldID";
int FieldIDToAdd = core.docProperties.getInteger(RequestNameAddFieldId);
bool normalizeSaveLoad = core.docProperties.getBoolean("NeedToReloadConfig");
bool AllowContentAutoLoad = false;
StringBuilderLegacyController Stream = new StringBuilderLegacyController();
string Title = "Set Columns: " + adminContent.name;
string Description = "Use the icons to add, remove and modify your personal column prefernces for this content (" + adminContent.name + "). Hit OK when complete. Hit Reset to restore your column preferences for this content to the site's default column preferences.";
Stream.add(AdminUIController.getHeaderTitleDescription(Title, Description));
//
//--------------------------------------------------------------------------------
// Process actions
//--------------------------------------------------------------------------------
//
if (adminContent.id != 0)
{
var CDef = ContentMetadataModel.create(core, adminContent.id);
int ColumnWidthTotal = 0;
if (ToolsAction != 0)
{
//
// Block contentautoload, then force a load at the end
//
AllowContentAutoLoad = (core.siteProperties.getBoolean("AllowContentAutoLoad", true));
core.siteProperties.setProperty("AllowContentAutoLoad", false);
bool reloadMetadata = false;
int SourceContentId = 0;
string SourceName = null;
//
// Make sure the FieldNameToAdd is not-inherited, if not, create new field
//
if (FieldIDToAdd != 0)
{
foreach (KeyValuePair <string, ContentFieldMetadataModel> keyValuePair in adminContent.fields)
{
ContentFieldMetadataModel field = keyValuePair.Value;
if (field.id == FieldIDToAdd)
{
if (field.inherited)
{
SourceContentId = field.contentId;
SourceName = field.nameLc;
//
// -- copy the field
using (var CSSource = new CsModel(core)) {
if (CSSource.open("Content Fields", "(ContentID=" + SourceContentId + ")and(Name=" + DbController.encodeSQLText(SourceName) + ")"))
{
using (var CSTarget = new CsModel(core)) {
if (CSTarget.insert("Content Fields"))
{
CSSource.copyRecord(CSTarget);
CSTarget.set("ContentID", adminContent.id);
reloadMetadata = true;
}
}
}
}
}
break;
}
}
}
//
// Make sure all fields are not-inherited, if not, create new fields
//
foreach (var column in IndexConfig.columns)
{
ContentFieldMetadataModel field = adminContent.fields[column.Name.ToLowerInvariant()];
if (field.inherited)
{
SourceContentId = field.contentId;
SourceName = field.nameLc;
using (var CSSource = new CsModel(core)) {
if (CSSource.open("Content Fields", "(ContentID=" + SourceContentId + ")and(Name=" + DbController.encodeSQLText(SourceName) + ")"))
{
using (var CSTarget = new CsModel(core)) {
if (CSTarget.insert("Content Fields"))
{
CSSource.copyRecord(CSTarget);
CSTarget.set("ContentID", adminContent.id);
reloadMetadata = true;
}
}
}
}
}
}
//
// get current values for Processing
//
foreach (var column in IndexConfig.columns)
{
ColumnWidthTotal += column.Width;
}
//
// ----- Perform any actions first
//
switch (ToolsAction)
{
case ToolsActionAddField: {
//
// Add a field to the index form
//
if (FieldIDToAdd != 0)
{
IndexConfigColumnClass column = null;
foreach (var columnx in IndexConfig.columns)
{
columnx.Width = encodeInteger((columnx.Width * 80) / (double)ColumnWidthTotal);
}
{
column = new IndexConfigColumnClass();
using (var csData = new CsModel(core)) {
if (csData.openRecord("Content Fields", FieldIDToAdd))
{
column.Name = csData.getText("name");
column.Width = 20;
}
}
IndexConfig.columns.Add(column);
normalizeSaveLoad = true;
}
}
//
break;
}
case ToolsActionRemoveField: {
//
// Remove a field to the index form
int columnWidthTotal = 0;
var dstColumns = new List <IndexConfigColumnClass>();
foreach (var column in IndexConfig.columns)
{
if (column.Name != TargetFieldName.ToLowerInvariant())
{
dstColumns.Add(column);
columnWidthTotal += column.Width;
}
}
IndexConfig.columns = dstColumns;
normalizeSaveLoad = true;
break;
}
case ToolsActionMoveFieldLeft: {
if (IndexConfig.columns.First().Name != TargetFieldName.ToLowerInvariant())
{
int listIndex = 0;
foreach (var column in IndexConfig.columns)
{
if (column.Name == TargetFieldName.ToLowerInvariant())
{
break;
}
listIndex += 1;
}
IndexConfig.columns.swap(listIndex, listIndex - 1);
normalizeSaveLoad = true;
}
break;
}
case ToolsActionMoveFieldRight: {
if (IndexConfig.columns.Last().Name != TargetFieldName.ToLowerInvariant())
{
int listIndex = 0;
foreach (var column in IndexConfig.columns)
{
if (column.Name == TargetFieldName.ToLowerInvariant())
{
break;
}
listIndex += 1;
}
IndexConfig.columns.swap(listIndex, listIndex + 1);
normalizeSaveLoad = true;
}
break;
}
case ToolsActionExpand: {
foreach (var column in IndexConfig.columns)
{
if (column.Name == TargetFieldName.ToLowerInvariant())
{
column.Width = Convert.ToInt32(Convert.ToDouble(column.Width) * 1.1);
}
else
{
column.Width = Convert.ToInt32(Convert.ToDouble(column.Width) * 0.9);
}
}
normalizeSaveLoad = true;
break;
}
case ToolsActionContract: {
foreach (var column in IndexConfig.columns)
{
if (column.Name != TargetFieldName.ToLowerInvariant())
{
column.Width = Convert.ToInt32(Convert.ToDouble(column.Width) * 1.1);
}
else
{
column.Width = Convert.ToInt32(Convert.ToDouble(column.Width) * 0.9);
}
}
normalizeSaveLoad = true;
break;
}
}
//
// Reload CDef if it changed
//
if (reloadMetadata)
{
core.clearMetaData();
core.cache.invalidateAll();
CDef = ContentMetadataModel.createByUniqueName(core, adminContent.name);
}
//
// save indexconfig
//
if (normalizeSaveLoad)
{
//
// Normalize the widths of the remaining columns
ColumnWidthTotal = 0;
foreach (var column in IndexConfig.columns)
{
ColumnWidthTotal += column.Width;
}
foreach (var column in IndexConfig.columns)
{
column.Width = encodeInteger((1000 * column.Width) / (double)ColumnWidthTotal);
}
GetHtmlBodyClass.setIndexSQL_SaveIndexConfig(cp, core, IndexConfig);
IndexConfig = IndexConfigClass.get(core, adminData);
}
}
//
//--------------------------------------------------------------------------------
// Display the form
//--------------------------------------------------------------------------------
//
Stream.add("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"99%\"><tr>");
Stream.add("<td width=\"5%\"> </td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>10%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>20%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>30%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>40%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>50%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>60%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>70%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>80%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>90%</nobr></td>");
Stream.add("<td width=\"9%\" align=\"center\" class=\"ccAdminSmall\"><nobr>100%</nobr></td>");
Stream.add("<td width=\"4%\" align=\"center\"> </td>");
Stream.add("</tr></table>");
//
Stream.add("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"99%\"><tr>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("<td width=\"9%\"><nobr><img src=\"" + cdnPrefix + "images/black.gif\" width=\"1\" height=\"10\" ><img alt=\"space\" src=\"" + cdnPrefix + "images/spacer.gif\" width=\"100%\" height=\"10\" ></nobr></td>");
Stream.add("</tr></table>");
//
// print the column headers
//
ColumnWidthTotal = 0;
int InheritedFieldCount = 0;
if (IndexConfig.columns.Count > 0)
{
//
// Calc total width
//
foreach (var column in IndexConfig.columns)
{
ColumnWidthTotal += column.Width;
}
if (ColumnWidthTotal > 0)
{
Stream.add("<table border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"90%\">");
//
// -- header
Stream.add("<tr>");
int ColumnWidth = 0;
int fieldId = 0;
string Caption = null;
foreach (var column in IndexConfig.columns)
{
//
// print column headers - anchored so they sort columns
//
ColumnWidth = encodeInteger(100 * (column.Width / (double)ColumnWidthTotal));
ContentFieldMetadataModel field = adminContent.fields[column.Name.ToLowerInvariant()];
fieldId = field.id;
Caption = field.caption;
if (field.inherited)
{
Caption = Caption + "*";
InheritedFieldCount = InheritedFieldCount + 1;
}
Stream.add("<td class=\"small\" width=\"" + ColumnWidth + "%\" valign=\"top\" align=\"left\" style=\"background-color:white;border: 1px solid #555;\">" + Caption + "</td>");
}
Stream.add("</tr>");
//
// -- body
Stream.add("<tr>");
foreach (var column in IndexConfig.columns)
{
//
// print column headers - anchored so they sort columns
//
ColumnWidth = encodeInteger(100 * (column.Width / (double)ColumnWidthTotal));
ContentFieldMetadataModel field = adminContent.fields[column.Name.ToLowerInvariant()];
fieldId = field.id;
Caption = field.caption;
if (field.inherited)
{
Caption = Caption + "*";
InheritedFieldCount = InheritedFieldCount + 1;
}
int ColumnPtr = 0;
string link = "?" + core.doc.refreshQueryString + "&FieldName=" + HtmlController.encodeHtml(field.nameLc) + "&fi=" + fieldId + "&dtcn=" + ColumnPtr + "&" + RequestNameAdminSubForm + "=" + AdminFormIndex_SubFormSetColumns;
Stream.add("<td width=\"" + ColumnWidth + "%\" valign=\"top\" align=\"left\">");
Stream.add(HtmlController.div(AdminUIController.getDeleteLink(link + "&dta=" + ToolsActionRemoveField), "text-center"));
Stream.add(HtmlController.div(AdminUIController.getArrowRightLink(link + "&dta=" + ToolsActionMoveFieldRight), "text-center"));
Stream.add(HtmlController.div(AdminUIController.getArrowLeftLink(link + "&dta=" + ToolsActionMoveFieldLeft), "text-center"));
Stream.add(HtmlController.div(AdminUIController.getExpandLink(link + "&dta=" + ToolsActionExpand), "text-center"));
Stream.add(HtmlController.div(AdminUIController.getContractLink(link + "&dta=" + ToolsActionContract), "text-center"));
Stream.add("</td>");
}
Stream.add("</tr>");
Stream.add("</table>");
}
}
//
// ----- If anything was inherited, put up the message
//
if (InheritedFieldCount > 0)
{
Stream.add("<p class=\"ccNormal\">* This field was inherited from the Content Definition's Parent. Inherited fields will automatically change when the field in the parent is changed. If you alter these settings, this connection will be broken, and the field will no longer inherit it's properties.</P class=\"ccNormal\">");
}
//
// ----- now output a list of fields to add
//
if (CDef.fields.Count == 0)
{
Stream.add(SpanClassAdminNormal + "This Content Definition has no fields</span><br>");
}
else
{
foreach (KeyValuePair <string, ContentFieldMetadataModel> keyValuePair in adminContent.fields)
{
ContentFieldMetadataModel field = keyValuePair.Value;
//
// display the column if it is not in use
if ((IndexConfig.columns.Find(x => x.Name == field.nameLc) == null))
{
if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.File)
{
//
// file can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileText)
{
//
// filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (text file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileHTML)
{
//
// filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (html file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileHTMLCode)
{
//
// filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (html code file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileCSS)
{
//
// css filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (css file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileXML)
{
//
// xml filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (xml file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileJavascript)
{
//
// javascript filename can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (javascript file field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.LongText)
{
//
// can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (long text field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.HTML)
{
//
// can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (html field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.FileImage)
{
//
// can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (image field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.Redirect)
{
//
// can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (redirect field)"));
}
else if (field.fieldTypeId == CPContentBaseClass.FieldTypeIdEnum.ManyToMany)
{
//
// many to many can not be search
Stream.add(HtmlController.div(iconNotAvailable + " " + field.caption + " (many-to-many field)"));
}
else
{
//
// can be used as column header
string link = "?" + core.doc.refreshQueryString + "&fi=" + field.id + "&dta=" + ToolsActionAddField + "&" + RequestNameAddFieldId + "=" + field.id + "&" + RequestNameAdminSubForm + "=" + AdminFormIndex_SubFormSetColumns;
Stream.add(HtmlController.div(AdminUIController.getPlusLink(link, " " + field.caption)));
}
}
}
}
}
//
//--------------------------------------------------------------------------------
// print the content tables that have index forms to Configure
//--------------------------------------------------------------------------------
//
core.siteProperties.setProperty("AllowContentAutoLoad", GenericController.encodeText(AllowContentAutoLoad));
string Content = ""
+ Stream.text
+ HtmlController.inputHidden("cid", adminContent.id.ToString())
+ HtmlController.inputHidden(rnAdminForm, "1")
+ HtmlController.inputHidden(RequestNameAdminSubForm, AdminFormIndex_SubFormSetColumns)
+ "";
//
// -- assemble form
result = AdminUIController.getToolForm(core, Content, ButtonOK + "," + ButtonReset);
core.html.addTitle(Title);
} catch (Exception ex) {
LogController.logError(core, ex);
}
return(result);
}