// Page ID

var $PageID = 'list';

// Project ID

var $ProjectID = "{B2F6402D-7C0A-4760-82AD-045088CEBA18}";

// Table name

var $TableName = 'view2';

// Page object name

var $PageObjName = 'view2_list';

// Grid form hidden field names

var $FormName = 'fview2list';

var $FormActionName = 'k_action';

var $FormKeyName = 'k_key';

var $FormOldKeyName = 'k_oldkey';

var $FormBlankRowName = 'k_blankrow';

var $FormKeyCountName = 'key_count';

// Page name

function PageName() {

return ew_CurrentPage();

}

// Page URL

function PageUrl() {

$PageUrl = ew_CurrentPage() . "?";

if ($this->UseTokenInUrl) $PageUrl .= "t=" . $this->TableVar . "&"; // Add page token

return $PageUrl;

}

// Page URLs

var $AddUrl;

var $EditUrl;

var $CopyUrl;

var $DeleteUrl;

var $ViewUrl;

var $ListUrl;

// Export URLs

var $ExportPrintUrl;

var $ExportHtmlUrl;

var $ExportExcelUrl;

var $ExportWordUrl;

var $ExportXmlUrl;

var $ExportCsvUrl;

var $ExportPdfUrl;

// Custom export

var $ExportExcelCustom = FALSE;

var $ExportWordCustom = FALSE;

var $ExportPdfCustom = FALSE;

var $ExportEmailCustom = FALSE;

// Update URLs

var $InlineAddUrl;

var $InlineCopyUrl;

var $InlineEditUrl;

var $GridAddUrl;

var $GridEditUrl;

var $MultiDeleteUrl;

var $MultiUpdateUrl;

// Message

function getMessage() {

return @$_SESSION[EW_SESSION_MESSAGE];

}

function setMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_MESSAGE], $v);

}

function getFailureMessage() {

return @$_SESSION[EW_SESSION_FAILURE_MESSAGE];

}

function setFailureMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_FAILURE_MESSAGE], $v);

}

function getSuccessMessage() {

return @$_SESSION[EW_SESSION_SUCCESS_MESSAGE];

}

function setSuccessMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_SUCCESS_MESSAGE], $v);

}

function getWarningMessage() {

return @$_SESSION[EW_SESSION_WARNING_MESSAGE];

}

function setWarningMessage($v) {

ew_AddMessage($_SESSION[EW_SESSION_WARNING_MESSAGE], $v);

}

// Methods to clear message

function ClearMessage() {

$_SESSION[EW_SESSION_MESSAGE] = "";

}

function ClearFailureMessage() {

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = "";

}

function ClearSuccessMessage() {

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = "";

}

function ClearWarningMessage() {

$_SESSION[EW_SESSION_WARNING_MESSAGE] = "";

}

function ClearMessages() {

$_SESSION[EW_SESSION_MESSAGE] = "";

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = "";

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = "";

$_SESSION[EW_SESSION_WARNING_MESSAGE] = "";

}

// Show message

function ShowMessage() {

$hidden = TRUE;

$html = "";

// Message

$sMessage = $this->getMessage();

$this->Message_Showing($sMessage, "");

if ($sMessage <> "") { // Message in Session, display

if (!$hidden)

$sMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sMessage;

$html .= "<div class=\"alert alert-info ewInfo\">" . $sMessage . "</div>";

$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message in Session

}

// Warning message

$sWarningMessage = $this->getWarningMessage();

$this->Message_Showing($sWarningMessage, "warning");

if ($sWarningMessage <> "") { // Message in Session, display

if (!$hidden)

$sWarningMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sWarningMessage;

$html .= "<div class=\"alert alert-warning ewWarning\">" . $sWarningMessage . "</div>";

$_SESSION[EW_SESSION_WARNING_MESSAGE] = ""; // Clear message in Session

}

// Success message

$sSuccessMessage = $this->getSuccessMessage();

$this->Message_Showing($sSuccessMessage, "success");

if ($sSuccessMessage <> "") { // Message in Session, display

if (!$hidden)

$sSuccessMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sSuccessMessage;

$html .= "<div class=\"alert alert-success ewSuccess\">" . $sSuccessMessage . "</div>";

$_SESSION[EW_SESSION_SUCCESS_MESSAGE] = ""; // Clear message in Session

}

// Failure message

$sErrorMessage = $this->getFailureMessage();

$this->Message_Showing($sErrorMessage, "failure");

if ($sErrorMessage <> "") { // Message in Session, display

if (!$hidden)

$sErrorMessage = "<button type=\"button\" class=\"close\" data-dismiss=\"alert\">&times;</button>" . $sErrorMessage;

$html .= "<div class=\"alert alert-danger ewError\">" . $sErrorMessage . "</div>";

$_SESSION[EW_SESSION_FAILURE_MESSAGE] = ""; // Clear message in Session

}

echo "<div class=\"ewMessageDialog\"" . (($hidden) ? " style=\"display: none;\"" : "") . ">" . $html . "</div>";

}

var $PageHeader;

var $PageFooter;

// Show Page Header

function ShowPageHeader() {

$sHeader = $this->PageHeader;

$this->Page_DataRendering($sHeader);

if ($sHeader <> "") { // Header exists, display

echo "<p>" . $sHeader . "</p>";

}

}

// Show Page Footer

function ShowPageFooter() {

$sFooter = $this->PageFooter;

$this->Page_DataRendered($sFooter);

if ($sFooter <> "") { // Footer exists, display

echo "<p>" . $sFooter . "</p>";

}

}

// Validate page request

function IsPageRequest() {

global $objForm;

if ($this->UseTokenInUrl) {

if ($objForm)

return ($this->TableVar == $objForm->GetValue("t"));

if (@$_GET["t"] <> "")

return ($this->TableVar == $_GET["t"]);

} else {

return TRUE;

}

}

var $Token = "";

var $TokenTimeout = 0;

var $CheckToken = EW_CHECK_TOKEN;

var $CheckTokenFn = "ew_CheckToken";

var $CreateTokenFn = "ew_CreateToken";

// Valid Post

function ValidPost() {

if (!$this->CheckToken || !ew_IsHttpPost())

return TRUE;

if (!isset($_POST[EW_TOKEN_NAME]))

return FALSE;

$fn = $this->CheckTokenFn;

if (is_callable($fn))

return $fn($_POST[EW_TOKEN_NAME], $this->TokenTimeout);

return FALSE;

}

// Create Token

function CreateToken() {

global $gsToken;

if ($this->CheckToken) {

$fn = $this->CreateTokenFn;

if ($this->Token == "" && is_callable($fn)) // Create token

$this->Token = $fn();

$gsToken = $this->Token; // Save to global variable

}

}

//

// Page class constructor

//

function __construct() {

global $conn, $Language;

global $UserTable, $UserTableConn;

$GLOBALS["Page"] = &$this;

$this->TokenTimeout = ew_SessionTimeoutTime();

// Language object

if (!isset($Language)) $Language = new cLanguage();

// Parent constuctor

parent::__construct();

// Table object (view2)

if (!isset($GLOBALS["view2"]) || get_class($GLOBALS["view2"]) == "cview2") {

$GLOBALS["view2"] = &$this;

$GLOBALS["Table"] = &$GLOBALS["view2"];

}

// Initialize URLs

$this->ExportPrintUrl = $this->PageUrl() . "export=print";

$this->ExportExcelUrl = $this->PageUrl() . "export=excel";

$this->ExportWordUrl = $this->PageUrl() . "export=word";

$this->ExportHtmlUrl = $this->PageUrl() . "export=html";

$this->ExportXmlUrl = $this->PageUrl() . "export=xml";

$this->ExportCsvUrl = $this->PageUrl() . "export=csv";

$this->ExportPdfUrl = $this->PageUrl() . "export=pdf";

$this->AddUrl = "view2add.php";

$this->InlineAddUrl = $this->PageUrl() . "a=add";

$this->GridAddUrl = $this->PageUrl() . "a=gridadd";

$this->GridEditUrl = $this->PageUrl() . "a=gridedit";

$this->MultiDeleteUrl = "view2delete.php";

$this->MultiUpdateUrl = "view2update.php";

// Table object (user)

if (!isset($GLOBALS['user'])) $GLOBALS['user'] = new cuser();

// Page ID

if (!defined("EW_PAGE_ID"))

define("EW_PAGE_ID", 'list', TRUE);

// Table name (for backward compatibility)

if (!defined("EW_TABLE_NAME"))

define("EW_TABLE_NAME", 'view2', TRUE);

// Start timer

if (!isset($GLOBALS["gTimer"])) $GLOBALS["gTimer"] = new cTimer();

// Open connection

if (!isset($conn)) $conn = ew_Connect($this->DBID);

// User table object (user)

if (!isset($UserTable)) {

$UserTable = new cuser();

$UserTableConn = Conn($UserTable->DBID);

}

// List options

$this->ListOptions = new cListOptions();

$this->ListOptions->TableVar = $this->TableVar;

// Export options

$this->ExportOptions = new cListOptions();

$this->ExportOptions->Tag = "div";

$this->ExportOptions->TagClassName = "ewExportOption";

// Other options

$this->OtherOptions['addedit'] = new cListOptions();

$this->OtherOptions['addedit']->Tag = "div";

$this->OtherOptions['addedit']->TagClassName = "ewAddEditOption";

$this->OtherOptions['detail'] = new cListOptions();

$this->OtherOptions['detail']->Tag = "div";

$this->OtherOptions['detail']->TagClassName = "ewDetailOption";

$this->OtherOptions['action'] = new cListOptions();

$this->OtherOptions['action']->Tag = "div";

$this->OtherOptions['action']->TagClassName = "ewActionOption";

// Filter options

$this->FilterOptions = new cListOptions();

$this->FilterOptions->Tag = "div";

$this->FilterOptions->TagClassName = "ewFilterOption fview2listsrch";

// List actions

$this->ListActions = new cListActions();

}

//

// Page_Init

//

function Page_Init() {

global $gsExport, $gsCustomExport, $gsExportFile, $UserProfile, $Language, $Security, $objForm;

// User profile

$UserProfile = new cUserProfile();

// Security

$Security = new cAdvancedSecurity();

if (!$Security->IsLoggedIn()) $Security->AutoLogin();

if ($Security->IsLoggedIn()) $Security->TablePermission_Loading();

$Security->LoadCurrentUserLevel($this->ProjectID . $this->TableName);

if ($Security->IsLoggedIn()) $Security->TablePermission_Loaded();

if (!$Security->CanList()) {

$Security->SaveLastUrl();

$this->setFailureMessage($Language->Phrase("NoPermission")); // Set no permission

$this->Page_Terminate(ew_GetUrl("index.php"));

}

if ($Security->IsLoggedIn()) {

$Security->UserID_Loading();

$Security->LoadUserID();

$Security->UserID_Loaded();

if (strval($Security->CurrentUserID()) == "") {

$this->setFailureMessage($Language->Phrase("NoPermission")); // Set no permission

$this->Page_Terminate();

}

}

// Get export parameters

$custom = "";

if (@$_GET["export"] <> "") {

$this->Export = $_GET["export"];

$custom = @$_GET["custom"];

} elseif (@$_POST["export"] <> "") {

$this->Export = $_POST["export"];

$custom = @$_POST["custom"];

} elseif (ew_IsHttpPost()) {

if (@$_POST["exporttype"] <> "")

$this->Export = $_POST["exporttype"];

$custom = @$_POST["custom"];

} else {

$this->setExportReturnUrl(ew_CurrentUrl());

}

$gsExportFile = $this->TableVar; // Get export file, used in header

// Get custom export parameters

if ($this->Export <> "" && $custom <> "") {

$this->CustomExport = $this->Export;

$this->Export = "print";

}

$gsCustomExport = $this->CustomExport;

$gsExport = $this->Export; // Get export parameter, used in header

// Update Export URLs

if (defined("EW_USE_PHPEXCEL"))

$this->ExportExcelCustom = FALSE;

if ($this->ExportExcelCustom)

$this->ExportExcelUrl .= "&amp;custom=1";

if (defined("EW_USE_PHPWORD"))

$this->ExportWordCustom = FALSE;

if ($this->ExportWordCustom)

$this->ExportWordUrl .= "&amp;custom=1";

if ($this->ExportPdfCustom)

$this->ExportPdfUrl .= "&amp;custom=1";

$this->CurrentAction = (@$_GET["a"] <> "") ? $_GET["a"] : @$_POST["a_list"]; // Set up current action

// Get grid add count

$gridaddcnt = @$_GET[EW_TABLE_GRID_ADD_ROW_COUNT];

if (is_numeric($gridaddcnt) && $gridaddcnt > 0)

$this->GridAddRowCount = $gridaddcnt;

// Set up list options

$this->SetupListOptions();

// Setup export options

$this->SetupExportOptions();

// Global Page Loading event (in userfn*.php)

Page_Loading();

// Page Load event

$this->Page_Load();

// Check token

if (!$this->ValidPost()) {

echo $Language->Phrase("InvalidPostRequest");

$this->Page_Terminate();

exit();

}

// Process auto fill

if (@$_POST["ajax"] == "autofill") {

$results = $this->GetAutoFill(@$_POST["name"], @$_POST["q"]);

if ($results) {

// Clean output buffer

if (!EW_DEBUG_ENABLED && ob_get_length())

ob_end_clean();

echo $results;

$this->Page_Terminate();

exit();

}

}

// Create Token

$this->CreateToken();

// Setup other options

$this->SetupOtherOptions();

// Set up custom action (compatible with old version)

foreach ($this->CustomActions as $name => $action)

$this->ListActions->Add($name, $action);

// Show checkbox column if multiple action

foreach ($this->ListActions->Items as $listaction) {

if ($listaction->Select == EW_ACTION_MULTIPLE && $listaction->Allow) {

$this->ListOptions->Items["checkbox"]->Visible = TRUE;

break;

}

}

}

//

// Page_Terminate

//

function Page_Terminate($url = "") {

global $gsExportFile, $gTmpImages;

// Page Unload event

$this->Page_Unload();

// Global Page Unloaded event (in userfn*.php)

Page_Unloaded();

// Export

global $EW_EXPORT, $view2;

if ($this->CustomExport <> "" && $this->CustomExport == $this->Export && array_key_exists($this->CustomExport, $EW_EXPORT)) {

$sContent = ob_get_contents();

if ($gsExportFile == "") $gsExportFile = $this->TableVar;

$class = $EW_EXPORT[$this->CustomExport];

if (class_exists($class)) {

$doc = new $class($view2);

$doc->Text = $sContent;

if ($this->Export == "email")

echo $this->ExportEmail($doc->Text);

else

$doc->Export();

ew_DeleteTmpImages(); // Delete temp images

exit();

}

}

$this->Page_Redirecting($url);

// Close connection

ew_CloseConn();

// Go to URL if specified

if ($url <> "") {

if (!EW_DEBUG_ENABLED && ob_get_length())

ob_end_clean();

header("Location: " . $url);

}

exit();

}

// Class variables

var $ListOptions; // List options

var $ExportOptions; // Export options

var $SearchOptions; // Search options

var $OtherOptions = array(); // Other options

var $FilterOptions; // Filter options

var $ListActions; // List actions

var $SelectedCount = 0;

var $SelectedIndex = 0;

var $DisplayRecs = 15;

var $StartRec;

var $StopRec;

var $TotalRecs = 0;

var $RecRange = 10;

var $Pager;

var $DefaultSearchWhere = ""; // Default search WHERE clause

var $SearchWhere = ""; // Search WHERE clause

var $RecCnt = 0; // Record count

var $EditRowCnt;

var $StartRowCnt = 1;

var $RowCnt = 0;

var $Attrs = array(); // Row attributes and cell attributes

var $RowIndex = 0; // Row index

var $KeyCount = 0; // Key count

var $RowAction = ""; // Row action

var $RowOldKey = ""; // Row old key (for copy)

var $RecPerRow = 0;

var $MultiColumnClass;

var $MultiColumnEditClass = "col-sm-12";

var $MultiColumnCnt = 12;

var $MultiColumnEditCnt = 12;

var $GridCnt = 0;

var $ColCnt = 0;

var $DbMasterFilter = ""; // Master filter

var $DbDetailFilter = ""; // Detail filter

var $MasterRecordExists;

var $MultiSelectKey;

var $Command;

var $RestoreSearch = FALSE;

var $DetailPages;

var $Recordset;

var $OldRecordset;

//

// Page main

//

function Page_Main() {

global $objForm, $Language, $gsFormError, $gsSearchError, $Security;

// Search filters

$sSrchAdvanced = ""; // Advanced search filter

$sSrchBasic = ""; // Basic search filter

$sFilter = "";

// Get command

$this->Command = strtolower(@$_GET["cmd"]);

if ($this->IsPageRequest()) { // Validate request

// Process list action first

if ($this->ProcessListAction()) // Ajax request

$this->Page_Terminate();

// Set up records per page

$this->SetUpDisplayRecs();

// Handle reset command

$this->ResetCmd();

// Set up Breadcrumb

if ($this->Export == "")

$this->SetupBreadcrumb();

// Hide list options

if ($this->Export <> "") {

$this->ListOptions->HideAllOptions(array("sequence"));

$this->ListOptions->UseDropDownButton = FALSE; // Disable drop down button

$this->ListOptions->UseButtonGroup = FALSE; // Disable button group

} elseif ($this->CurrentAction == "gridadd" || $this->CurrentAction == "gridedit") {

$this->ListOptions->HideAllOptions();

$this->ListOptions->UseDropDownButton = FALSE; // Disable drop down button

$this->ListOptions->UseButtonGroup = FALSE; // Disable button group

}

// Hide options

if ($this->Export <> "" || $this->CurrentAction <> "") {

$this->ExportOptions->HideAllOptions();

$this->FilterOptions->HideAllOptions();

}

// Hide other options

if ($this->Export <> "") {

foreach ($this->OtherOptions as &$option)

$option->HideAllOptions();

}

// Get default search criteria

ew_AddFilter($this->DefaultSearchWhere, $this->BasicSearchWhere(TRUE));

// Get basic search values

$this->LoadBasicSearchValues();

// Restore filter list

$this->RestoreFilterList();

// Restore search parms from Session if not searching / reset / export

if (($this->Export <> "" || $this->Command <> "search" && $this->Command <> "reset" && $this->Command <> "resetall") && $this->CheckSearchParms())

$this->RestoreSearchParms();

// Call Recordset SearchValidated event

$this->Recordset_SearchValidated();

// Set up sorting order

$this->SetUpSortOrder();

// Get basic search criteria

if ($gsSearchError == "")

$sSrchBasic = $this->BasicSearchWhere();

}

// Restore display records

if ($this->getRecordsPerPage() <> "") {

$this->DisplayRecs = $this->getRecordsPerPage(); // Restore from Session

} else {

$this->DisplayRecs = 15; // Load default

}

// Load Sorting Order

$this->LoadSortOrder();

// Load search default if no existing search criteria

if (!$this->CheckSearchParms()) {

// Load basic search from default

$this->BasicSearch->LoadDefault();

if ($this->BasicSearch->Keyword != "")

$sSrchBasic = $this->BasicSearchWhere();

}

// Build search criteria

ew_AddFilter($this->SearchWhere, $sSrchAdvanced);

ew_AddFilter($this->SearchWhere, $sSrchBasic);

// Call Recordset_Searching event

$this->Recordset_Searching($this->SearchWhere);

// Save search criteria

if ($this->Command == "search" && !$this->RestoreSearch) {

$this->setSearchWhere($this->SearchWhere); // Save to Session

$this->StartRec = 1; // Reset start record counter

$this->setStartRecordNumber($this->StartRec);

} else {

$this->SearchWhere = $this->getSearchWhere();

}

// Build filter

$sFilter = "";

if (!$Security->CanList())

$sFilter = "(0=1)"; // Filter all records

ew_AddFilter($sFilter, $this->DbDetailFilter);

ew_AddFilter($sFilter, $this->SearchWhere);

// Set up filter in session

$this->setSessionWhere($sFilter);

$this->CurrentFilter = "";

// Export data only

if ($this->CustomExport == "" && in_array($this->Export, array("html","word","excel","xml","csv","email","pdf"))) {

$this->ExportData();

$this->Page_Terminate(); // Terminate response

exit();

}

// Load record count first

if (!$this->IsAddOrEdit()) {

$bSelectLimit = $this->UseSelectLimit;

if ($bSelectLimit) {

$this->TotalRecs = $this->SelectRecordCount();

} else {

if ($this->Recordset = $this->LoadRecordset())

$this->TotalRecs = $this->Recordset->RecordCount();

}

}

// Search options

$this->SetupSearchOptions();

}

// Set up number of records displayed per page

function SetUpDisplayRecs() {

$sWrk = @$_GET[EW_TABLE_REC_PER_PAGE];

if ($sWrk <> "") {

if (is_numeric($sWrk)) {

$this->DisplayRecs = intval($sWrk);

} else {

if (strtolower($sWrk) == "all") { // Display all records

$this->DisplayRecs = -1;

} else {

$this->DisplayRecs = 15; // Non-numeric, load default

}

}

$this->setRecordsPerPage($this->DisplayRecs); // Save to Session

// Reset start position

$this->StartRec = 1;

$this->setStartRecordNumber($this->StartRec);

}

}

// Build filter for all keys

function BuildKeyFilter() {

global $objForm;

$sWrkFilter = "";

// Update row index and get row key

$rowindex = 1;

$objForm->Index = $rowindex;

$sThisKey = strval($objForm->GetValue($this->FormKeyName));

while ($sThisKey <> "") {

if ($this->SetupKeyValues($sThisKey)) {

$sFilter = $this->KeyFilter();

if ($sWrkFilter <> "") $sWrkFilter .= " OR ";

$sWrkFilter .= $sFilter;

} else {

$sWrkFilter = "0=1";

break;

}

// Update row index and get row key

$rowindex++; // Next row

$objForm->Index = $rowindex;

$sThisKey = strval($objForm->GetValue($this->FormKeyName));

}

return $sWrkFilter;

}

// Set up key values

function SetupKeyValues($key) {

$arrKeyFlds = explode($GLOBALS["EW_COMPOSITE_KEY_SEPARATOR"], $key);

if (count($arrKeyFlds) >= 1) {

$this->USER_ID->setFormValue($arrKeyFlds[0]);

if (!is_numeric($this->USER_ID->FormValue))

return FALSE;

}

return TRUE;

}

// Get list of filters

function GetFilterList() {

// Initialize

$sFilterList = "";

$sFilterList = ew_Concat($sFilterList, $this->FIRSTNAME->AdvancedSearch->ToJSON(), ","); // Field FIRSTNAME

$sFilterList = ew_Concat($sFilterList, $this->SECONDNAME->AdvancedSearch->ToJSON(), ","); // Field SECONDNAME

$sFilterList = ew_Concat($sFilterList, $this->LASTNAME->AdvancedSearch->ToJSON(), ","); // Field LASTNAME

$sFilterList = ew_Concat($sFilterList, $this->SURNAME->AdvancedSearch->ToJSON(), ","); // Field SURNAME

$sFilterList = ew_Concat($sFilterList, $this->MAIL->AdvancedSearch->ToJSON(), ","); // Field MAIL

if ($this->BasicSearch->Keyword <> "") {

$sWrk = "\"" . EW_TABLE_BASIC_SEARCH . "\":\"" . ew_JsEncode2($this->BasicSearch->Keyword) . "\",\"" . EW_TABLE_BASIC_SEARCH_TYPE . "\":\"" . ew_JsEncode2($this->BasicSearch->Type) . "\"";

$sFilterList = ew_Concat($sFilterList, $sWrk, ",");

}

// Return filter list in json

return ($sFilterList <> "") ? "{" . $sFilterList . "}" : "null";

}

// Restore list of filters

function RestoreFilterList() {

// Return if not reset filter

if (@$_POST["cmd"] <> "resetfilter")

return FALSE;

$filter = json_decode(ew_StripSlashes(@$_POST["filter"]), TRUE);

$this->Command = "search";

// Field FIRSTNAME

$this->FIRSTNAME->AdvancedSearch->SearchValue = @$filter["x_FIRSTNAME"];

$this->FIRSTNAME->AdvancedSearch->SearchOperator = @$filter["z_FIRSTNAME"];

$this->FIRSTNAME->AdvancedSearch->SearchCondition = @$filter["v_FIRSTNAME"];

$this->FIRSTNAME->AdvancedSearch->SearchValue2 = @$filter["y_FIRSTNAME"];

$this->FIRSTNAME->AdvancedSearch->SearchOperator2 = @$filter["w_FIRSTNAME"];

$this->FIRSTNAME->AdvancedSearch->Save();

// Field SECONDNAME

$this->SECONDNAME->AdvancedSearch->SearchValue = @$filter["x_SECONDNAME"];

$this->SECONDNAME->AdvancedSearch->SearchOperator = @$filter["z_SECONDNAME"];

$this->SECONDNAME->AdvancedSearch->SearchCondition = @$filter["v_SECONDNAME"];

$this->SECONDNAME->AdvancedSearch->SearchValue2 = @$filter["y_SECONDNAME"];

$this->SECONDNAME->AdvancedSearch->SearchOperator2 = @$filter["w_SECONDNAME"];

$this->SECONDNAME->AdvancedSearch->Save();

// Field LASTNAME

$this->LASTNAME->AdvancedSearch->SearchValue = @$filter["x_LASTNAME"];

$this->LASTNAME->AdvancedSearch->SearchOperator = @$filter["z_LASTNAME"];

$this->LASTNAME->AdvancedSearch->SearchCondition = @$filter["v_LASTNAME"];

$this->LASTNAME->AdvancedSearch->SearchValue2 = @$filter["y_LASTNAME"];

$this->LASTNAME->AdvancedSearch->SearchOperator2 = @$filter["w_LASTNAME"];

$this->LASTNAME->AdvancedSearch->Save();

// Field SURNAME

$this->SURNAME->AdvancedSearch->SearchValue = @$filter["x_SURNAME"];

$this->SURNAME->AdvancedSearch->SearchOperator = @$filter["z_SURNAME"];

$this->SURNAME->AdvancedSearch->SearchCondition = @$filter["v_SURNAME"];

$this->SURNAME->AdvancedSearch->SearchValue2 = @$filter["y_SURNAME"];

$this->SURNAME->AdvancedSearch->SearchOperator2 = @$filter["w_SURNAME"];

$this->SURNAME->AdvancedSearch->Save();

// Field MAIL

$this->MAIL->AdvancedSearch->SearchValue = @$filter["x_MAIL"];

$this->MAIL->AdvancedSearch->SearchOperator = @$filter["z_MAIL"];

$this->MAIL->AdvancedSearch->SearchCondition = @$filter["v_MAIL"];

$this->MAIL->AdvancedSearch->SearchValue2 = @$filter["y_MAIL"];

$this->MAIL->AdvancedSearch->SearchOperator2 = @$filter["w_MAIL"];

$this->MAIL->AdvancedSearch->Save();

$this->BasicSearch->setKeyword(@$filter[EW_TABLE_BASIC_SEARCH]);

$this->BasicSearch->setType(@$filter[EW_TABLE_BASIC_SEARCH_TYPE]);

}

// Return basic search SQL

function BasicSearchSQL($arKeywords, $type) {

$sWhere = "";

$this->BuildBasicSearchSQL($sWhere, $this->FIRSTNAME, $arKeywords, $type);

$this->BuildBasicSearchSQL($sWhere, $this->SECONDNAME, $arKeywords, $type);

$this->BuildBasicSearchSQL($sWhere, $this->LASTNAME, $arKeywords, $type);

$this->BuildBasicSearchSQL($sWhere, $this->SURNAME, $arKeywords, $type);

$this->BuildBasicSearchSQL($sWhere, $this->MAIL, $arKeywords, $type);

return $sWhere;

}

// Build basic search SQL

function BuildBasicSearchSql(&$Where, &$Fld, $arKeywords, $type) {

$sDefCond = ($type == "OR") ? "OR" : "AND";

$arSQL = array(); // Array for SQL parts

$arCond = array(); // Array for search conditions

$cnt = count($arKeywords);

$j = 0; // Number of SQL parts

for ($i = 0; $i < $cnt; $i++) {

$Keyword = $arKeywords[$i];

$Keyword = trim($Keyword);

if (EW_BASIC_SEARCH_IGNORE_PATTERN <> "") {

$Keyword = preg_replace(EW_BASIC_SEARCH_IGNORE_PATTERN, "\\", $Keyword);

$ar = explode("\\", $Keyword);

} else {

$ar = array($Keyword);

}

foreach ($ar as $Keyword) {

if ($Keyword <> "") {

$sWrk = "";

if ($Keyword == "OR" && $type == "") {

if ($j > 0)

$arCond[$j-1] = "OR";

} elseif ($Keyword == EW_NULL_VALUE) {

$sWrk = $Fld->FldExpression . " IS NULL";

} elseif ($Keyword == EW_NOT_NULL_VALUE) {

$sWrk = $Fld->FldExpression . " IS NOT NULL";

} elseif ($Fld->FldIsVirtual && $Fld->FldVirtualSearch) {

$sWrk = $Fld->FldVirtualExpression . ew_Like(ew_QuotedValue("%" . $Keyword . "%", EW_DATATYPE_STRING, $this->DBID), $this->DBID);

} elseif ($Fld->FldDataType != EW_DATATYPE_NUMBER || is_numeric($Keyword)) {

$sWrk = $Fld->FldBasicSearchExpression . ew_Like(ew_QuotedValue("%" . $Keyword . "%", EW_DATATYPE_STRING, $this->DBID), $this->DBID);

}

if ($sWrk <> "") {

$arSQL[$j] = $sWrk;

$arCond[$j] = $sDefCond;

$j += 1;

}

}

}

}

$cnt = count($arSQL);

$bQuoted = FALSE;

$sSql = "";

if ($cnt > 0) {

for ($i = 0; $i < $cnt-1; $i++) {

if ($arCond[$i] == "OR") {

if (!$bQuoted) $sSql .= "(";

$bQuoted = TRUE;

}

$sSql .= $arSQL[$i];

if ($bQuoted && $arCond[$i] <> "OR") {

$sSql .= ")";

$bQuoted = FALSE;

}

$sSql .= " " . $arCond[$i] . " ";

}

$sSql .= $arSQL[$cnt-1];

if ($bQuoted)

$sSql .= ")";

}

if ($sSql <> "") {

if ($Where <> "") $Where .= " OR ";

$Where .= "(" . $sSql . ")";

}

}

// Return basic search WHERE clause based on search keyword and type

function BasicSearchWhere($Default = FALSE) {

global $Security;

$sSearchStr = "";

if (!$Security->CanSearch()) return "";

$sSearchKeyword = ($Default) ? $this->BasicSearch->KeywordDefault : $this->BasicSearch->Keyword;

$sSearchType = ($Default) ? $this->BasicSearch->TypeDefault : $this->BasicSearch->Type;

if ($sSearchKeyword <> "") {

$sSearch = trim($sSearchKeyword);

if ($sSearchType <> "=") {

$ar = array();

// Match quoted keywords (i.e.: "...")

if (preg_match_all('/"([^"]*)"/i', $sSearch, $matches, PREG_SET_ORDER)) {

foreach ($matches as $match) {

$p = strpos($sSearch, $match[0]);

$str = substr($sSearch, 0, $p);

$sSearch = substr($sSearch, $p + strlen($match[0]));

if (strlen(trim($str)) > 0)

$ar = array_merge($ar, explode(" ", trim($str)));

$ar[] = $match[1]; // Save quoted keyword

}

}

// Match individual keywords

if (strlen(trim($sSearch)) > 0)

$ar = array_merge($ar, explode(" ", trim($sSearch)));

// Search keyword in any fields

if (($sSearchType == "OR" || $sSearchType == "AND") && $this->BasicSearch->BasicSearchAnyFields) {

foreach ($ar as $sKeyword) {

if ($sKeyword <> "") {

if ($sSearchStr <> "") $sSearchStr .= " " . $sSearchType . " ";

$sSearchStr .= "(" . $this->BasicSearchSQL(array($sKeyword), $sSearchType) . ")";

}

}

} else {

$sSearchStr = $this->BasicSearchSQL($ar, $sSearchType);

}

} else {

$sSearchStr = $this->BasicSearchSQL(array($sSearch), $sSearchType);

}

if (!$Default) $this->Command = "search";

}

if (!$Default && $this->Command == "search") {

$this->BasicSearch->setKeyword($sSearchKeyword);

$this->BasicSearch->setType($sSearchType);

}

return $sSearchStr;

}

// Check if search parm exists

function CheckSearchParms() {

// Check basic search

if ($this->BasicSearch->IssetSession())

return TRUE;

return FALSE;

}

// Clear all search parameters

function ResetSearchParms() {

// Clear search WHERE clause

$this->SearchWhere = "";

$this->setSearchWhere($this->SearchWhere);

// Clear basic search parameters

$this->ResetBasicSearchParms();

}

// Load advanced search default values

function LoadAdvancedSearchDefault() {

return FALSE;

}

// Clear all basic search parameters

function ResetBasicSearchParms() {

$this->BasicSearch->UnsetSession();

}

// Restore all search parameters

function RestoreSearchParms() {

$this->RestoreSearch = TRUE;

// Restore basic search values

$this->BasicSearch->Load();

}

// Set up sort parameters

function SetUpSortOrder() {

// Check for Ctrl pressed

$bCtrl = (@$_GET["ctrl"] <> "");

// Check for "order" parameter

if (@$_GET["order"] <> "") {

$this->CurrentOrder = ew_StripSlashes(@$_GET["order"]);

$this->CurrentOrderType = @$_GET["ordertype"];

$this->UpdateSort($this->FIRSTNAME, $bCtrl); // FIRSTNAME

$this->UpdateSort($this->SECONDNAME, $bCtrl); // SECONDNAME

$this->UpdateSort($this->LASTNAME, $bCtrl); // LASTNAME