/**
* get value safe for html display
* @param FlexiTableFieldObject $oField
* @param array $oRow
* @return String
*/
public function getFieldDisplay(FlexiTableFieldObject $oField, $oRow)
{
$sName = $oField->getName();
$mValue = $oRow[$sName];
$bAllowHTML = $oField->allowhtml;
switch ($oField->type) {
case "select-text":
case "select-tinyint":
case "select-smallint":
case "select-bigint":
case "select-mediumint":
case "select-enum":
case "select-int":
if ($oField->existsOption($mValue)) {
$mValue = $oField->getOptionLabel($mValue);
}
break;
case "timestamp-int":
$sFormat = FlexiDateUtil::getPHPDateTimeFormat(FlexiConfig::$sInputDateTimeFormat);
if (!empty($mValue) && $mValue > 0) {
$mValue = date($sFormat, $mValue);
} else {
$mValue = "";
}
break;
case "datetime":
$sFormat = FlexiDateUtil::getPHPDateTimeFormat(FlexiConfig::$sInputDateTimeFormat);
if (!empty($mValue) && $mValue != "0000-00-00" && $mValue != "0000-00-00 00:00:00") {
$mValue = date($sFormat, strtotime($mValue));
} else {
$mValue = "";
}
break;
case "date":
$sFormat = FlexiDateUtil::getPHPDateTimeFormat(FlexiConfig::$sDisplayDateFormat);
if (!empty($mValue) && $mValue != "0000-00-00" && $mValue != "0000-00-00 00:00:00") {
$mValue = date($sFormat, strtotime($mValue));
} else {
$mValue = "";
}
break;
case "file-varchar":
case "file-text":
if (!empty($mValue)) {
try {
$sPath = (empty($oField->savepath) ? "" : $oField->savepath . "/") . $mValue;
$sURL = FlexiFileUtil::getMediaURL($sPath);
$mValue = "<a href='" . $sURL . "' target='_blank'>Open</a>";
} catch (Exception $e) {
$mValue = $e->getMessage();
}
$oField->allowtag = "a";
}
$bAllowHTML = true;
break;
case "image-varchar":
case "image-text":
if (!empty($mValue)) {
try {
$sPath = (empty($oField->savepath) ? "" : $oField->savepath . "/") . $mValue;
//echo "path: " . $sPath;
$sURL = FlexiFileUtil::getMediaURL($sPath);
$sThumbURL = FlexiFileUtil::getMediaURL($sPath, null, null, array("maxwidth" => $this->iMaxImageWidth));
$mValue = "<a href='" . $sURL . "' target='_blank'>" . "<img src='" . $sThumbURL . "'/>" . "</a>";
} catch (Exception $e) {
$mValue = $e->getMessage();
}
$oField->allowtag = "a,img";
}
$bAllowHTML = true;
break;
case "multiimage-text":
if (!empty($mValue)) {
$mValue = "";
$aPath = explode($oField->uploadseparator, $oRow[$sName]);
$sBasePath = empty($oField->savepath) ? "" : $oField->savepath . "/";
foreach ($aPath as $sPath) {
$sPath = trim($sPath);
try {
if (!empty($sPath)) {
$sPath = $sBasePath . $sPath;
$sURL = FlexiFileUtil::getMediaURL($sPath);
$sThumbURL = FlexiFileUtil::getMediaURL($sPath, null, null, array("maxwidth" => $this->iMaxImageWidth));
$mValue .= "<a href='" . $sURL . "' target='_blank'>" . "<img src='" . $sThumbURL . "'/>" . "</a>";
}
} catch (Exception $e) {
$mValue .= $e->getMessage();
}
}
//foreach
$oField->allowtag = "a,img";
}
$bAllowHTML = true;
break;
case "email":
if (!empty($mValue)) {
$oField->allowtag = "a";
$sURL = "mailto:" . $mValue;
$mValue = "<a href='" . $sURL . "'>" . $mValue . "</a>";
}
$bAllowHTML = true;
break;
}
//switch type
if (is_null($mValue)) {
$mValue = "";
}
if ($bAllowHTML) {
if (!empty($oField->allowtag)) {
$aSafe = $this->getFieldSafeTags($oField);
$sTag = implode(",", $aSafe["tag"]);
$aAttribute = $aSafe["attribute"];
$mValue = FlexiStringUtil::stripTagsAttributes($mValue, $sTag, $aAttribute);
}
} else {
$mValue = strip_tags($mValue);
}
$this->onGetFieldDisplay($oField, $oRow, $mValue);
return $mValue;
}
$mValue = isset($vars["#value"]) ? $vars["#value"] : (isset($vars["#default_value"]) ? $vars["#default_value"] : null);
$sMaxLen = isset($vars["#maxlength"]) ? " maxlength=\"" . $vars["#maxlength"] . "\"" : "";
$bDisabled = isset($vars["#disabled"]) ? $vars["#disabled"] : false;
$sRequired = isset($vars["#required"]) ? $vars["#required"] ? "<span class=\"required\">*</span>" : "" : "";
$sMinDate = "";
$sMaxDate = "";
if (isset($vars["#mindate"])) {
$aDate = explode("-", $vars["#mindate"]);
$sMinDate = ", minDate: new Date(" . $aDate[0] . ", " . $aDate[1] . ", " . $aDate[2] . ")";
}
if (isset($vars["#maxdate"])) {
$aDate = explode("-", $vars["#maxdate"]);
$sMaxDate = ", maxDate: new Date(" . $aDate[0] . ", " . $aDate[1] . ", " . $aDate[2] . ")";
}
$sFormat = isset($vars["#format"]) ? $vars["#format"] : FlexiConfig::$sInputDateFormat;
$sPHPFormat = FlexiDateUtil::getPHPDateTimeFormat($sFormat);
//fix double i, which only 1 i(min) in php
$sDisplayValue = "";
if (!empty($mValue)) {
if (substr($mValue, 0, 4) == "0000") {
//empty date
$sDisplayValue = "";
} else {
$iDatetime = strtotime($mValue);
$sDisplayValue = date($sPHPFormat, $iDatetime);
}
}
echo isset($vars["#prefix"]) ? $vars["#prefix"] : "";
?>
<input type="text" name="<?php
echo $vars["#name"];
/**
* Api to create user
* @param String $sUserName
* @param String $sPassword
* @param String $sFullName
* @param array of Strings $aGroups
* @param array $aOptions
* @return Doctrine_Record
*/
public function createUser($sUserName, $sPassword, $sFullName = "", $aGroups = array(), $aOptions = array(), $bSendEmail = true)
{
//var_dump($aOptions);
$this->checkMe();
$bVerifyEmail = isset($aOptions["verifyemail"]) ? $aOptions["verifyemail"] : FlexiConfig::$bRequireEmailVerification;
if ($bVerifyEmail && empty(FlexiConfig::$sSupportEmail)) {
throw new FlexiException("Support e-mail not set: " . FlexiConfig::$sSupportEmail, ERROR_CONFIGURATION);
}
$oModel = FlexiModeUtil::getRedbeanModel(FlexiConfig::$sDBPrefix . "users");
$oModel->user_name = $sUserName;
$oModel->password = md5($sPassword);
$oModel->first_name = $sFullName;
$oModel->email = $aOptions["email"];
$oModel->date_registered = FlexiDateUtil::getSQLDateNow();
$oModel->deleted = "N";
FlexiModelUtil::getInstance()->insertRedBean($oModel);
if (!empty($oModel->email) && $bVerifyEmail) {
$oView = new FlexiView();
$sMessage = $oView->render("user.verify", array("fullname" => $sFullName, "module" => "FlexiLogin", "method" => "verify", "params" => array("id" => $oModel->id, "r" => $oModel->Extend->verifycode)));
$sSubject = "Verification required";
$oMail = FlexiMailer::getInstance();
$oMail->setFrom(FlexiConfig::$sSupportEmail);
$oMail->mail($sSubject, $sMessage, $oModel->Attributes->email);
// sendMailMessage($oModel->Attributes->email, $oModel->username, $sPassword, $oModel->Attributes->fullname);
}
return $oModel;
}
