public override XVar getPdfValue(dynamic data, dynamic _param_keylink = null)
{
#region default values
if (_param_keylink as Object == null)
{
_param_keylink = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic keylink = XVar.Clone(_param_keylink);
#endregion
dynamic imageType = null, width = null;
if (XVar.Pack(!(XVar)(data[this.field])))
{
return("\"\"");
}
width = XVar.Clone(this.container.pSet.getImageWidth((XVar)(this.field)));
if (XVar.Pack(!(XVar)(width)))
{
width = new XVar(100);
if (XVar.Equals(XVar.Pack(this.container.pageType), XVar.Pack(Constants.PAGE_VIEW)))
{
width = new XVar(300);
}
}
imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(data[this.field])));
if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png"))
{
return(MVCFunctions.Concat("{ \r\n\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(data[this.field]))))), "\",\r\n\t\t\t\twidth: ", width, ", \r\n\t\t\t\theight: ", this.container.pSet.getImageHeight((XVar)(this.field)), " \r\n\t\t\t}"));
}
return("\"\"");
}
public override XVar getPdfValue(dynamic data, dynamic _param_keylink = null)
{
#region default values
if (_param_keylink as Object == null)
{
_param_keylink = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic keylink = XVar.Clone(_param_keylink);
#endregion
dynamic content = null, imageType = null, location = null, mapData = XVar.Array(), staticUrl = null;
mapData = XVar.Clone(this.pageObject.addGoogleMapData((XVar)(this.field), (XVar)(data)));
location = XVar.Clone(getLocation((XVar)(mapData["markers"][0])));
staticUrl = XVar.Clone(getStaticMapURL((XVar)(location), (XVar)(mapData["zoom"]), (XVar)(mapData["markers"][0]["mapIcon"])));
content = XVar.Clone(MVCFunctions.myurl_get_contents_binary((XVar)(staticUrl)));
imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(content)));
if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png"))
{
return(MVCFunctions.Concat("{ \r\n\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(content))))), "\",\r\n\t\t\t}"));
}
return("\"\"");
}
public override XVar buildControl(dynamic _param_value, dynamic _param_mode, dynamic _param_fieldNum, dynamic _param_validate, dynamic _param_additionalCtrlParams, dynamic _param_data)
{
#region pass-by-value parameters
dynamic value = XVar.Clone(_param_value);
dynamic mode = XVar.Clone(_param_mode);
dynamic fieldNum = XVar.Clone(_param_fieldNum);
dynamic validate = XVar.Clone(_param_validate);
dynamic additionalCtrlParams = XVar.Clone(_param_additionalCtrlParams);
dynamic data = XVar.Clone(_param_data);
#endregion
dynamic disp = null, strfilename = null, strtype = null;
base.buildControl((XVar)(value), (XVar)(mode), (XVar)(fieldNum), (XVar)(validate), (XVar)(additionalCtrlParams), (XVar)(data));
disp = new XVar("");
strfilename = new XVar("");
if ((XVar)(mode == Constants.MODE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_EDIT))
{
dynamic filename = null, itype = null;
value = XVar.Clone(this.connection.stripSlashesBinary((XVar)(value)));
itype = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(value)));
if (XVar.Pack(itype))
{
if (XVar.Pack(this.pageObject.pSetEdit.showThumbnail((XVar)(this.field))))
{
disp = new XVar("<a target=_blank");
disp = MVCFunctions.Concat(disp, " href=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&", this.iquery, "&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\" class='zoombox'>");
disp = MVCFunctions.Concat(disp, "<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\" border=0");
if (XVar.Pack(this.is508))
{
disp = MVCFunctions.Concat(disp, " alt=\"Image from DB\"");
}
disp = MVCFunctions.Concat(disp, " src=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&field=", MVCFunctions.RawUrlEncode((XVar)(this.pageObject.pSetEdit.getStrThumbnail((XVar)(this.field)))), "&alt=", MVCFunctions.RawUrlEncode((XVar)(this.field)), this.keylink, "&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\">");
disp = MVCFunctions.Concat(disp, "</a>");
}
else
{
disp = XVar.Clone(MVCFunctions.Concat("<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\""));
if (XVar.Pack(this.is508))
{
disp = MVCFunctions.Concat(disp, " alt=\"Image from DB\"");
}
disp = MVCFunctions.Concat(disp, " border=0 src=\"", MVCFunctions.GetTableLink(new XVar("imager"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&", this.iquery, "&src=1&rndVal=", MVCFunctions.rand(new XVar(0), new XVar(32768))))), "\">");
}
}
else
{
if (XVar.Pack(MVCFunctions.strlen((XVar)(value))))
{
disp = XVar.Clone(MVCFunctions.Concat("<img id=\"image_", MVCFunctions.GoodFieldName((XVar)(this.field)), "_", this.id, "\" name=\"", this.cfield, "\" border=0 "));
if (XVar.Pack(this.is508))
{
disp = MVCFunctions.Concat(disp, " alt=\"file\"");
}
disp = MVCFunctions.Concat(disp, " src=\"", MVCFunctions.GetRootPathForResources(new XVar("images/file.gif")), "\">");
}
}
if ((XVar)((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(!(XVar)(itype))) && (XVar)(MVCFunctions.strlen((XVar)(value))))
{
if (XVar.Pack(!(XVar)(filename = XVar.Clone(data[this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))]))))
{
filename = new XVar("file.bin");
}
disp = XVar.Clone(MVCFunctions.Concat("<a href=\"", MVCFunctions.GetTableLink(new XVar("getfile"), new XVar(""), (XVar)(MVCFunctions.Concat("table=", CommonFunctions.GetTableURL((XVar)(this.pageObject.tName)), "&filename=", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "&", this.iquery))), "\".>", disp, "</a>"));
}
if ((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))))
{
if (XVar.Pack(!(XVar)(filename = XVar.Clone(data[this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))]))))
{
filename = new XVar("");
}
if (mode == Constants.MODE_INLINE_EDIT)
{
strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Filename", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\" value=\"", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "\">"));
}
else
{
strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Filename", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\" value=\"", MVCFunctions.runner_htmlspecialchars((XVar)(filename)), "\">"));
}
}
if (XVar.Pack(MVCFunctions.strlen((XVar)(value))))
{
strtype = XVar.Clone(MVCFunctions.Concat("<br><input id=\"", this.ctype, "_keep\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file0\" checked class=\"rnr-uploadtype\">", "Keep"));
if ((XVar)(MVCFunctions.strlen((XVar)(value))) && (XVar)(!(XVar)(this.pageObject.pSetEdit.isRequired((XVar)(this.field)))))
{
strtype = MVCFunctions.Concat(strtype, "<input id=\"", this.ctype, "_delete\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file1\" class=\"rnr-uploadtype\">", "Delete");
}
strtype = MVCFunctions.Concat(strtype, "<input id=\"", this.ctype, "_update\" type=\"Radio\" name=\"", this.ctype, "\" value=\"file2\" class=\"rnr-uploadtype\">", "Update");
}
else
{
strtype = XVar.Clone(MVCFunctions.Concat("<input id=\"", this.ctype, "_update\" type=\"hidden\" name=\"", this.ctype, "\" value=\"file2\" class=\"rnr-uploadtype\">"));
}
}
else
{
strtype = XVar.Clone(MVCFunctions.Concat("<input id=\"", this.ctype, "\" type=\"hidden\" name=\"", this.ctype, "\" value=\"file2\">"));
if ((XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE) && (XVar)(this.pageObject.pSetEdit.getFilenameField((XVar)(this.field))))
{
strfilename = XVar.Clone(MVCFunctions.Concat("<br><label for=\"filename_", this.cfieldname, "\">", "Filename", "</label> <input type=\"text\" ", this.inputStyle, " id=\"filename_", this.cfieldname, "\" name=\"filename_", this.cfieldname, "\" size=\"20\" maxlength=\"50\">"));
}
}
if ((XVar)(mode == Constants.MODE_INLINE_EDIT) && (XVar)(this.format == Constants.EDIT_FORMAT_DATABASE_FILE))
{
disp = new XVar("");
}
MVCFunctions.Echo(MVCFunctions.Concat(disp, strtype));
if ((XVar)((XVar)(mode == Constants.MODE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_EDIT)) && (XVar)(MVCFunctions.strlen((XVar)(value))))
{
MVCFunctions.Echo("<br>");
}
MVCFunctions.Echo(MVCFunctions.Concat("<input type=\"File\" ", this.inputStyle, " id=\"", this.cfield, "\" ", (XVar.Pack((XVar)((XVar)(mode == Constants.MODE_INLINE_EDIT) || (XVar)(mode == Constants.MODE_INLINE_ADD)) && (XVar)(this.is508)) ? XVar.Pack(MVCFunctions.Concat("alt=\"", this.strLabel, "\" ")) : XVar.Pack("")), " name=\"", this.cfield, "\" >", strfilename));
MVCFunctions.Echo(MVCFunctions.Concat("<input type=\"Hidden\" id=\"notempty_", this.cfieldname, "\" value=\"", (XVar.Pack(MVCFunctions.strlen((XVar)(value))) ? XVar.Pack(1) : XVar.Pack(0)), "\">"));
buildControlEnd((XVar)(validate), (XVar)(mode));
return(null);
}
public override XVar getPdfValue(dynamic data, dynamic _param_keylink = null)
{
#region default values
if (_param_keylink as Object == null)
{
_param_keylink = new XVar("");
}
#endregion
#region pass-by-value parameters
dynamic keylink = XVar.Clone(_param_keylink);
#endregion
dynamic defWidth = null, filesArray = XVar.Array(), resultValues = XVar.Array(), thumbWidth = null, width = null;
if (XVar.Pack(!(XVar)(data[this.field])))
{
return("\"\"");
}
defWidth = new XVar(100);
if (XVar.Equals(XVar.Pack(this.container.pageType), XVar.Pack(Constants.PAGE_VIEW)))
{
defWidth = new XVar(300);
}
width = XVar.Clone((XVar.Pack(this.imageWidth) ? XVar.Pack(this.imageWidth) : XVar.Pack(defWidth)));
thumbWidth = XVar.Clone((XVar.Pack(this.thumbWidth) ? XVar.Pack(this.thumbWidth) : XVar.Pack(72)));
if (XVar.Pack(this.isImageURL))
{
return(MVCFunctions.Concat("{ \r\n\t\t\t\timage:\"", data[this.field], "\",\r\n\t\t\t\twidth: ", width, ", \r\n\t\t\t\theight: ", this.imageHeight, " \t\t\t\r\n\t\t\t}"));
}
this.upload_handler.tkeys = XVar.Clone(keylink);
resultValues = XVar.Clone(XVar.Array());
filesArray = XVar.Clone(getFilesArray((XVar)(data[this.field])));
foreach (KeyValuePair <XVar, dynamic> imageFile in filesArray.GetEnumerator())
{
dynamic content = null, hasBigImage = null, hasThumbnail = null, imagePath = null, imageType = null, thumbPath = null, userFile = null;
userFile = XVar.Clone(this.upload_handler.buildUserFile((XVar)(imageFile.Value)));
if (XVar.Pack(!(XVar)(CommonFunctions.CheckImageExtension((XVar)(imageFile.Value["name"])))))
{
resultValues.InitAndSetArrayItem("\"\"", null);
continue;
}
imagePath = XVar.Clone(getImagePath((XVar)(imageFile.Value["name"])));
hasBigImage = XVar.Clone(MVCFunctions.myfile_exists((XVar)(imagePath)));
if (XVar.Pack(!(XVar)(hasBigImage)))
{
continue;
}
if (XVar.Pack(!(XVar)(this.showThumbnails)))
{
content = XVar.Clone(MVCFunctions.myfile_get_contents((XVar)(imagePath)));
imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(content)));
if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png"))
{
resultValues.InitAndSetArrayItem(MVCFunctions.Concat("{ \r\n\t\t\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(content))))), "\",\r\n\t\t\t\t\t\twidth: ", width, ", \r\n\t\t\t\t\t\theight: ", this.imageHeight, " \r\n\t\t\t\t\t}"), null);
}
continue;
}
thumbPath = XVar.Clone(getImagePath((XVar)(imageFile.Value["thumbnail"])));
hasThumbnail = XVar.Clone(MVCFunctions.myfile_exists((XVar)(thumbPath)));
if (XVar.Pack(hasThumbnail))
{
content = XVar.Clone(MVCFunctions.myfile_get_contents((XVar)(thumbPath)));
imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(content)));
if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png"))
{
resultValues.InitAndSetArrayItem(MVCFunctions.Concat("{ \r\n\t\t\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(content))))), "\",\r\n\t\t\t\t\t\twidth: ", thumbWidth, ", \r\n\t\t\t\t\t\theight: ", this.thumbHeight, " \r\n\t\t\t\t\t}"), null);
}
}
else
{
content = XVar.Clone(MVCFunctions.myfile_get_contents((XVar)(imagePath)));
imageType = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(content)));
if ((XVar)(imageType == "image/jpeg") || (XVar)(imageType == "image/png"))
{
resultValues.InitAndSetArrayItem(MVCFunctions.Concat("{ \r\n\t\t\t\t\t\timage: \"", CommonFunctions.jsreplace((XVar)(MVCFunctions.Concat("data:", imageType, ";base64,", MVCFunctions.base64_encode((XVar)(content))))), "\",\r\n\t\t\t\t\t\twidth: ", thumbWidth, ", \r\n\t\t\t\t\t\theight: ", this.thumbHeight, " \r\n\t\t\t\t\t}"), null);
}
}
}
if (0 < MVCFunctions.count(resultValues))
{
return(MVCFunctions.Concat("[", MVCFunctions.implode(new XVar(","), (XVar)(resultValues)), "]"));
}
return("\"\"");
}
public XVar mfhandler()
{
try
{
dynamic _connection = null, field = null, fileName = null, formStamp = null, fsFileName = null, fsize = null, ftype = null, havePermission = null, iconShowed = null, isDBFile = null, isPDF = null, outputAsAttachment = null, pageType = null, pdf = null, requestAction = null, sessionFile = XVar.Array(), upload_handler = null, value = null, var_params = XVar.Array();
ProjectSettings pSet;
isPDF = new XVar(false);
if (XVar.Pack(isPDF))
{
GlobalVars.strTableName = XVar.Clone(var_params["table"]);
field = XVar.Clone(var_params["field"]);
pageType = XVar.Clone(var_params["pageType"]);
outputAsAttachment = new XVar(false);
}
else
{
GlobalVars.strTableName = XVar.Clone(MVCFunctions.postvalue(new XVar("table")));
field = XVar.Clone(MVCFunctions.postvalue(new XVar("field")));
pageType = XVar.Clone(MVCFunctions.postvalue(new XVar("pageType")));
outputAsAttachment = XVar.Clone(MVCFunctions.postvalue(new XVar("nodisp")) != 1);
}
if (GlobalVars.strTableName == XVar.Pack(""))
{
if (XVar.Pack(!(XVar)(isPDF)))
{
MVCFunctions.Echo("<p>No table name received</p>");
}
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (field == XVar.Pack(""))
{
if (XVar.Pack(!(XVar)(isPDF)))
{
MVCFunctions.Echo("<p>No field name received</p>");
}
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(!(XVar)(CommonFunctions.GetTableURL((XVar)(GlobalVars.strTableName)))))
{
MVCFunctions.Echo(new XVar(0));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(isPDF))
{
requestAction = new XVar("GET");
}
else
{
requestAction = XVar.Clone(MVCFunctions.postvalue("_action"));
}
_connection = XVar.Clone(GlobalVars.cman.byTable((XVar)(GlobalVars.strTableName)));
pSet = XVar.UnPackProjectSettings(new ProjectSettings((XVar)(GlobalVars.strTableName), (XVar)(pageType)));
if (XVar.Pack(!(XVar)(isPDF)))
{
CommonFunctions.add_nocache_headers();
}
Assembly.GetExecutingAssembly().GetType(MVCFunctions.Concat("runnerDotNet.", MVCFunctions.Concat("", CommonFunctions.GetTableURL((XVar)(GlobalVars.strTableName)), ""),
"_Variables")).InvokeMember("Apply", BindingFlags.InvokeMethod, null, null, null);
if (requestAction == "POST")
{
havePermission = XVar.Clone((XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Add"))) || (XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Edit"))));
}
else
{
havePermission = XVar.Clone((XVar)(CommonFunctions.CheckSecurity((XVar)(XSession.Session[MVCFunctions.Concat("_", GlobalVars.strTableName, "_OwnerID")]), new XVar("Search"))) || (XVar)(MVCFunctions.postvalue(new XVar("fkey"))));
}
if ((XVar)((XVar)(!(XVar)(CommonFunctions.isLogged())) && (XVar)(pageType != Constants.PAGE_REGISTER)) || (XVar)(!(XVar)(havePermission)))
{
MVCFunctions.HeaderRedirect(new XVar("login"), new XVar(""), new XVar("message=expired"));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
upload_handler = XVar.Clone(new UploadHandler((XVar)(CommonFunctions.getOptionsForMultiUpload((XVar)(pSet), (XVar)(field)))));
upload_handler.pSet = XVar.Clone(pSet);
upload_handler.field = XVar.Clone(field);
upload_handler.table = XVar.Clone(GlobalVars.strTableName);
upload_handler.pageType = XVar.Clone(pageType);
switch (((XVar)requestAction).ToString())
{
case "DELETE":
CommonFunctions.printMFHandlerHeaders();
formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("formStamp")));
if (formStamp != XVar.Pack(""))
{
upload_handler.formStamp = XVar.Clone(formStamp);
upload_handler.delete();
}
break;
case "POST":
CommonFunctions.printMFHandlerHeaders();
formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("formStamp")));
if (formStamp != XVar.Pack(""))
{
upload_handler.formStamp = XVar.Clone(formStamp);
upload_handler.post();
}
break;
case "GET":
default:
if (XVar.Pack(isPDF))
{
isDBFile = XVar.Clone(var_params.KeyExists("filename"));
fileName = XVar.Clone((XVar.Pack(var_params.KeyExists("file")) ? XVar.Pack(var_params["file"]) : XVar.Pack(var_params["filename"])));
}
else
{
isDBFile = XVar.Clone(MVCFunctions.postvalue(new XVar("filename")) != "");
fileName = XVar.Clone((XVar.Pack(MVCFunctions.postvalue(new XVar("file")) != "") ? XVar.Pack(MVCFunctions.postvalue(new XVar("file"))) : XVar.Pack(MVCFunctions.postvalue(new XVar("filename")))));
formStamp = XVar.Clone(MVCFunctions.postvalue(new XVar("fkey")));
}
if (fileName == XVar.Pack(""))
{
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
sessionFile = new XVar(null);
fsFileName = new XVar("");
if ((XVar)(!(XVar)(isDBFile)) && (XVar)(formStamp != XVar.Pack("")))
{
sessionFile = XVar.Clone(XSession.Session[MVCFunctions.Concat("mupload_", formStamp)][fileName]["file"]);
}
else
{
dynamic i = null, keys = XVar.Array(), qResult = null, queryObj = null, strWhereClause = null, tKeys = XVar.Array();
keys = XVar.Clone(XVar.Array());
tKeys = XVar.Clone(pSet.getTableKeys());
i = new XVar(0);
for (; i < MVCFunctions.count(tKeys); i++)
{
if (XVar.Pack(isPDF))
{
keys.InitAndSetArrayItem(var_params[MVCFunctions.Concat("key", i + 1)], tKeys[i]);
}
else
{
keys.InitAndSetArrayItem(MVCFunctions.postvalue((XVar)(MVCFunctions.Concat("key", i + 1))), tKeys[i]);
}
}
strWhereClause = XVar.Clone(CommonFunctions.KeyWhere((XVar)(keys)));
if (pSet.getAdvancedSecurityType() != Constants.ADVSECURITY_ALL)
{
strWhereClause = XVar.Clone(CommonFunctions.whereAdd((XVar)(strWhereClause), (XVar)(CommonFunctions.SecuritySQL(new XVar("Search")))));
}
queryObj = XVar.Clone(pSet.getSQLQuery().CloneObject());
if (XVar.Pack(!(XVar)(queryObj.HasGroupBy())))
{
queryObj.RemoveAllFieldsExcept((XVar)(pSet.getFieldIndex((XVar)(field))));
}
qResult = XVar.Clone(_connection.query((XVar)(queryObj.gSQLWhere((XVar)(strWhereClause)))));
if (XVar.Pack(isDBFile))
{
if (XVar.Pack(qResult))
{
dynamic data = XVar.Array();
data = XVar.Clone(qResult.fetchAssoc());
if (XVar.Pack(data))
{
value = XVar.Clone(_connection.stripSlashesBinary((XVar)(data[field])));
}
}
}
else
{
dynamic row = XVar.Array();
GlobalVars.cipherer = XVar.Clone(new RunnerCipherer((XVar)(GlobalVars.strTableName), (XVar)(pSet)));
row = XVar.Clone(GlobalVars.cipherer.DecryptFetchedArray((XVar)(qResult.fetchAssoc())));
if (XVar.Pack(row))
{
dynamic filesArray = XVar.Array();
filesArray = XVar.Clone(MVCFunctions.my_json_decode((XVar)(row[field])));
if ((XVar)(!(XVar)(MVCFunctions.is_array((XVar)(filesArray)))) || (XVar)(MVCFunctions.count(filesArray) == 0))
{
if (row[field] == "")
{
filesArray = XVar.Clone(XVar.Array());
}
else
{
dynamic uploadedFile = XVar.Array();
uploadedFile = XVar.Clone(upload_handler.get_file_object((XVar)(row[field])));
if (XVar.Pack(uploadedFile == null))
{
filesArray = XVar.Clone(XVar.Array());
}
else
{
filesArray = XVar.Clone(new XVar(0, MVCFunctions.my_json_decode((XVar)(MVCFunctions.my_json_encode((XVar)(uploadedFile))))));
}
}
}
foreach (KeyValuePair <XVar, dynamic> uploadedFile in filesArray.GetEnumerator())
{
if (uploadedFile.Value["usrName"] == fileName)
{
sessionFile = XVar.Clone(uploadedFile.Value);
break;
}
}
}
}
}
iconShowed = new XVar(false);
if (XVar.Pack(isDBFile))
{
ftype = new XVar("");
if (pSet.getViewFormat((XVar)(field)) == Constants.FORMAT_DATABASE_IMAGE)
{
if (XVar.Pack(!(XVar)(value)))
{
value = XVar.Clone(MVCFunctions.myfile_get_contents(new XVar("images/no_image.gif")));
}
ftype = XVar.Clone(MVCFunctions.SupposeImageType((XVar)(value)));
}
if (XVar.Pack(!(XVar)(ftype)))
{
ftype = XVar.Clone(CommonFunctions.getContentTypeByExtension((XVar)(MVCFunctions.substr((XVar)(fileName), (XVar)(MVCFunctions.strrpos((XVar)(fileName), new XVar(".")))))));
}
fsize = XVar.Clone(MVCFunctions.strlen_bin((XVar)(value)));
}
else
{
if (sessionFile != null)
{
dynamic isSRC = null, isThumbnail = null;
isThumbnail = new XVar(false);
isSRC = new XVar(false);
if (XVar.Pack(isPDF))
{
isThumbnail = XVar.Clone(var_params.KeyExists("thumbnail"));
isSRC = XVar.Clone(var_params.KeyExists("src"));
}
else
{
isThumbnail = XVar.Clone(MVCFunctions.postvalue(new XVar("thumbnail")) != "");
isSRC = XVar.Clone(MVCFunctions.postvalue(new XVar("src")) == 1);
}
if (MVCFunctions.postvalue(new XVar("icon")) != "")
{
fsFileName = XVar.Clone(MVCFunctions.Concat("images/icons/", CommonFunctions.getIconByFileType((XVar)(sessionFile["type"]), (XVar)(sessionFile["name"]))));
fsize = XVar.Clone(MVCFunctions.filesize((XVar)(MVCFunctions.getabspath((XVar)(fsFileName)))));
ftype = new XVar("image/png");
}
else
{
if ((XVar)((XVar)(isThumbnail) && (XVar)(sessionFile["thumbnail"])) && (XVar)(MVCFunctions.GDExist()))
{
fsFileName = XVar.Clone(sessionFile["thumbnail"]);
fsize = XVar.Clone(sessionFile["thumbnail_size"]);
ftype = XVar.Clone(sessionFile["thumbnail_type"]);
}
else
{
if ((XVar)((XVar)(false) && (XVar)((XVar)(pageType == Constants.PAGE_EDIT) || (XVar)(pageType == Constants.PAGE_ADD))) && (XVar)(isSRC))
{
iconShowed = new XVar(true);
fsFileName = XVar.Clone(MVCFunctions.Concat("images/icons/", CommonFunctions.getIconByFileType((XVar)(sessionFile["type"]), (XVar)(sessionFile["name"]))));
fsize = XVar.Clone(MVCFunctions.filesize((XVar)(MVCFunctions.getabspath((XVar)(fsFileName)))));
ftype = new XVar("image/png");
}
else
{
fsFileName = XVar.Clone(sessionFile["name"]);
fsize = XVar.Clone(sessionFile["size"]);
ftype = XVar.Clone(sessionFile["type"]);
}
}
}
}
}
if ((XVar)((XVar)(isDBFile) && (XVar)(value)) || (XVar)(fsFileName != XVar.Pack("")))
{
dynamic norange = null;
if (XVar.Pack(!(XVar)(isDBFile)))
{
if ((XVar)((XVar)(!(XVar)(pSet.isAbsolute((XVar)(field)))) && (XVar)(!(XVar)(MVCFunctions.isAbsolutePath((XVar)(fsFileName))))) || (XVar)(iconShowed))
{
fsFileName = XVar.Clone(MVCFunctions.getabspath((XVar)(fsFileName)));
}
if (XVar.Pack(!(XVar)(MVCFunctions.myfile_exists((XVar)(fsFileName)))))
{
fsFileName = XVar.Clone(MVCFunctions.getabspath(new XVar("images/no_image.gif")));
fsize = XVar.Clone(MVCFunctions.filesize((XVar)(fsFileName)));
ftype = new XVar("image/gif");
}
}
if (XVar.Pack(isPDF))
{
dynamic file = null;
if (XVar.Pack(isDBFile))
{
file = XVar.Clone(value);
}
else
{
file = XVar.Clone(MVCFunctions.myfile_get_contents((XVar)(fsFileName)));
}
return(MVCFunctions.GetBuferContentAndClearBufer());
}
norange = XVar.Clone(MVCFunctions.postvalue(new XVar("norange")) == 1);
if (MVCFunctions.postvalue(new XVar("norange")) == 1)
{
MVCFunctions.Header("Accept-Ranges", "none");
MVCFunctions.Header("Cache-Control", "private");
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Type: ", ftype)));
MVCFunctions.Header("Access-Control-Allow-Methods", "HEAD, GET, POST");
if (XVar.Pack(outputAsAttachment))
{
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Disposition: attachment;Filename=\"", fileName, "\"")));
}
MVCFunctions.SendContentLength((XVar)(fsize));
if (MVCFunctions.GetServerVariable("REQUEST_METHOD") == "HEAD")
{
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(isDBFile))
{
MVCFunctions.echoBinary((XVar)(value));
}
else
{
MVCFunctions.printfile((XVar)(fsFileName));
}
}
else
{
dynamic httpRange = null, printContentLength = null, range = null, range_orig = null, seek_end = null, seek_start = null, size_unit = null, tmparr = XVar.Array();
size_unit = new XVar("");
range_orig = new XVar("");
httpRange = XVar.Clone(MVCFunctions.GetHttpRange());
if (XVar.Pack(MVCFunctions.preg_match(new XVar("/^bytes=((\\d*-\\d*,? ?)+)$/"), (XVar)(httpRange))))
{
tmparr = XVar.Clone(MVCFunctions.explode(new XVar("="), (XVar)(httpRange)));
size_unit = XVar.Clone(tmparr[0]);
range_orig = XVar.Clone(tmparr[1]);
}
if (size_unit == "bytes")
{
if (!XVar.Equals(XVar.Pack(MVCFunctions.strpos((XVar)(range_orig), new XVar(","))), XVar.Pack(false)))
{
dynamic extra_ranges = null;
tmparr = XVar.Clone(MVCFunctions.explode(new XVar(","), (XVar)(range_orig)));
range = XVar.Clone(tmparr[0]);
extra_ranges = XVar.Clone(tmparr[1]);
}
else
{
range = XVar.Clone(range_orig);
}
}
else
{
range = new XVar("-");
}
tmparr = XVar.Clone(MVCFunctions.explode(new XVar("-"), (XVar)(range)));
seek_start = XVar.Clone(tmparr[0]);
seek_end = XVar.Clone(tmparr[1]);
seek_end = XVar.Clone((XVar.Pack(MVCFunctions.strlen((XVar)(seek_end)) == 0) ? XVar.Pack(fsize - 1) : XVar.Pack(MVCFunctions.min((XVar)(MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_end))))), (XVar)(fsize - 1)))));
seek_start = XVar.Clone((XVar.Pack((XVar)(MVCFunctions.strlen((XVar)(seek_start)) == 0) || (XVar)(seek_end < MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_start)))))) ? XVar.Pack(0) : XVar.Pack(MVCFunctions.max((XVar)(MVCFunctions.abs((XVar)(MVCFunctions.intval((XVar)(seek_start))))), new XVar(0)))));
if ((XVar)(XVar.Pack(0) < seek_start) || (XVar)(seek_end < fsize - 1))
{
MVCFunctions.Header(new XVar("HTTP/1.1 206 Partial Content"));
}
MVCFunctions.Header("Accept-Ranges", "bytes");
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Range: bytes ", seek_start, "-", seek_end, "/", fsize)));
if (XVar.Pack(outputAsAttachment))
{
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Disposition: attachment;Filename=\"", fileName, "\"")));
}
printContentLength = new XVar(true);
if (XVar.Pack(printContentLength))
{
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Length: ", (seek_end - seek_start) + 1)));
}
MVCFunctions.Header("Cache-Control", "cache, must-revalidate");
MVCFunctions.Header("Pragma", "public");
MVCFunctions.Header((XVar)(MVCFunctions.Concat("Content-Type: ", ftype)));
if (MVCFunctions.GetServerVariable("REQUEST_METHOD") == "HEAD")
{
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
if (XVar.Pack(isDBFile))
{
MVCFunctions.echoBinaryPartial((XVar)(value), (XVar)(seek_start), (XVar)(seek_end));
}
else
{
MVCFunctions.printfileByRange((XVar)(fsFileName), (XVar)(seek_start), (XVar)(seek_end));
}
}
}
break;
}
MVCFunctions.Echo(new XVar(""));
return(MVCFunctions.GetBuferContentAndClearBufer());
}
catch (RunnerRedirectException ex)
{ return(Redirect(ex.Message)); }
}