<h2>Editing File: /var/softaculous/webasyst/search.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
return array (
  'contact_info' =&gt; 
  array (
    'name' =&gt; 'Contact info',
    'items' =&gt; 
    array (
      'name' =&gt; 
      array (
        'name' =&gt; 'Name',
        'title' =&gt; false,
        'children' =&gt; 1,
        'items' =&gt; 
        array (
          'name' =&gt; 
          array (
            'field_id' =&gt; 'name',
          ),
          'title' =&gt; 
          array (
            'field_id' =&gt; 'title',
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; 'c.title = \'\'',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; 'c.title != \'\'',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND title LIKE \':term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT title AS name, COUNT(*) count
                            FROM wa_contact
                            WHERE title != \'\' :autocomplete
                            GROUP BY title
                            ORDER BY count DESC
                            LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT title) FROM wa_contact WHERE title != \'\' :autocomplete',
              ),
            ),
          ),
          'firstname' =&gt; 
          array (
            'field_id' =&gt; 'firstname',
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; 'c.firstname = \'\'',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; 'c.firstname != \'\'',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND firstname LIKE \':term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT firstname AS name, COUNT(*) count
                            FROM wa_contact
                            WHERE firstname != \'\' :autocomplete
                            GROUP BY firstname
                            ORDER BY count DESC
                            LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT firstname) FROM wa_contact WHERE firstname != \'\' :autocomplete',
              ),
            ),
          ),
          'middlename' =&gt; 
          array (
            'field_id' =&gt; 'middlename',
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; 'c.middlename = \'\'',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; 'c.middlename != \'\'',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND middlename LIKE \':term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT middlename AS name, COUNT(*) count
                            FROM wa_contact
                            WHERE middlename != \'\' :autocomplete
                            GROUP BY middlename
                            ORDER BY count DESC
                            LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT middlename) FROM wa_contact WHERE middlename != \'\' :autocomplete',
              ),
            ),
          ),
          'lastname' =&gt; 
          array (
            'field_id' =&gt; 'lastname',
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; 'c.lastname = \'\'',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; 'c.lastname != \'\'',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND lastname LIKE \':term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT lastname AS name, COUNT(*) count
                            FROM wa_contact
                            WHERE lastname != \'\' :autocomplete
                            GROUP BY lastname
                            ORDER BY count DESC
                            LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT lastname) FROM wa_contact WHERE lastname != \'\' :autocomplete',
              ),
            ),
          ),
        ),
      ),
      'jobtitle' =&gt; 
      array (
        'field_id' =&gt; 'jobtitle',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.jobtitle = \'\'',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.jobtitle != \'\'',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND jobtitle LIKE \':term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT jobtitle AS name, COUNT(*) count
                    FROM wa_contact
                    WHERE jobtitle != \'\' :autocomplete
                    GROUP BY jobtitle
                    ORDER BY count DESC
                    LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT jobtitle) FROM wa_contact WHERE jobtitle != \'\' :autocomplete',
          ),
        ),
      ),
      'company' =&gt; 
      array (
        'field_id' =&gt; 'company',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.company = \'\'',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.company != \'\'',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND company LIKE \':term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT company AS name, COUNT(*) count
                    FROM wa_contact
                    WHERE company != \'\' :autocomplete
                    GROUP BY company
                    ORDER BY count DESC
                    LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT company) FROM wa_contact WHERE company != \'\' :autocomplete',
          ),
        ),
      ),
      'email' =&gt; 
      array (
        'field_id' =&gt; 'email',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_emails WHERE contact_id = c.id) = 0',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_emails WHERE contact_id = c.id) &gt; 0',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'WHERE email LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT email AS name
                    FROM wa_contact_emails
                    :autocomplete
                    LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT email) FROM wa_contact_emails :autocomplete',
          ),
        ),
      ),
      'phone' =&gt; 
      array (
        'field_id' =&gt; 'phone',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'phone\') = 0',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'phone\') &gt; 0',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT value AS name, COUNT(*) count
                    FROM wa_contact_data
                    WHERE field = \'phone\' :autocomplete
                    GROUP BY value
                    ORDER BY count DESC
                    LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT value) FROM wa_contact_data WHERE field = \'phone\' :autocomplete',
          ),
        ),
      ),
      'sex' =&gt; 
      array (
        'field_id' =&gt; 'sex',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.sex IS NULL',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.sex IS NOT NULL',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 1,
            'sql' =&gt; 'SELECT sex AS name, sex AS value, COUNT(*) AS count
                    FROM wa_contact
                    WHERE sex IS NOT NULL
                    GROUP BY sex',
          ),
        ),
      ),
      'im' =&gt; 
      array (
        'field_id' =&gt; 'im',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'im\') = 0 ',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'im\') &gt; 0 ',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT value, value AS name, COUNT(*) count
                                FROM wa_contact_data
                                WHERE field = \'im\' :autocomplete
                                GROUP BY value
                                ORDER BY count DESC
                                LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT value) FROM `wa_contact_data` WHERE field = \'im\'',
          ),
        ),
      ),
      'address' =&gt; 
      array (
        'field_id' =&gt; 'address',
        'items' =&gt; 
        array (
          'street' =&gt; 
          array (
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:street\') = 0',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'adress:street\') &gt; 0',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT value AS name, COUNT(DISTINCT contact_id) count
                            FROM wa_contact_data
                            WHERE field = \'address:street\' :autocomplete
                            GROUP BY value
                            ORDER BY count DESC
                            LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT value)
                            FROM wa_contact_data
                            WHERE field = \'address:street\' :autocomplete',
              ),
            ),
          ),
          'city' =&gt; 
          array (
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:city\') = 0',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:city\') &gt; 0',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT value AS name, COUNT(DISTINCT contact_id) count
                        FROM wa_contact_data
                        WHERE field = \'address:city\' :autocomplete
                        GROUP BY value
                        ORDER BY count DESC
                        LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT value)
                            FROM wa_contact_data
                            WHERE field = \'address:city\' :autocomplete',
              ),
            ),
          ),
          'region' =&gt; 
          array (
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:region\') = 0',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:region\') &gt; 0',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 1,
                'class' =&gt; 'crmContactsSearchRegionValues',
              ),
            ),
          ),
          'country' =&gt; 
          array (
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:country\') = 0',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:country\') &gt; 0',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 1,
                'class' =&gt; 'crmContactsSearchCountryValues',
              ),
            ),
          ),
          'zip' =&gt; 
          array (
            'items' =&gt; 
            array (
              'blank' =&gt; 
              array (
                'name' =&gt; 'Empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:zip\') = 0',
              ),
              'not_blank' =&gt; 
              array (
                'name' =&gt; 'Not empty',
                'where' =&gt; '(SELECT COUNT(*) FROM wa_contact_data WHERE contact_id = c.id AND field = \'address:zip\') &gt; 0',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 'AND value LIKE \':term%\'',
                'limit' =&gt; 10,
                'sql' =&gt; 'SELECT value AS name, COUNT(DISTINCT contact_id) count
                        FROM wa_contact_data
                        WHERE field = \'address:zip\'
                        GROUP BY value
                        ORDER BY count DESC
                        LIMIT :limit',
                'count' =&gt; 'SELECT COUNT(DISTINCT value)
                            FROM wa_contact_data
                            WHERE field = \'address:zip\' :autocomplete',
              ),
            ),
          ),
        ),
      ),
      'url' =&gt; 
      array (
        'field_id' =&gt; 'url',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'url\') = 0 ',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'url\') &gt; 0 ',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT value, value AS name, COUNT(*) count
                                FROM wa_contact_data
                                WHERE field = \'url\' :autocomplete
                                GROUP BY value
                                ORDER BY count DESC
                                LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT value) FROM `wa_contact_data` WHERE field = \'url\'',
          ),
        ),
      ),
      'birthday' =&gt; 
      array (
        'field_id' =&gt; 'birthday',
        'readonly' =&gt; 1,
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.birth_day IS NULL AND c.birth_month IS NULL AND c.birth_year IS NULL',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.birth_day IS NOT NULL OR c.birth_month IS NOT NULL OR c.birth_year IS NOT NULL',
          ),
          ':sep' =&gt; 
          array (
          ),
          'today' =&gt; 
          array (
            'name' =&gt; 'today',
            'where' =&gt; 'c.birth_day = DAY(NOW()) AND c.birth_month = MONTH(NOW())',
          ),
          'today_or_tomorrow' =&gt; 
          array (
            'name' =&gt; 'today or tomorrow',
            'where' =&gt; '(c.birth_day = DAY(NOW()) OR c.birth_day = DAY(DATE_ADD(NOW(), INTERVAL 1 DAY))) AND c.birth_month = MONTH(NOW())',
          ),
          'week' =&gt; 
          array (
            'name' =&gt; 'in the nearest week',
            'where' =&gt; 'c.birth_day IS NOT NULL AND c.birth_month IS NOT NULL AND
                    STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &gt;= NOW() AND (
                        STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= DATE_ADD(NOW(), INTERVAL 7 DAY) OR
                        STR_TO_DATE(CONCAT(YEAR(DATE_ADD(NOW(), INTERVAL 1 YEAR)), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= DATE_ADD(NOW(), INTERVAL 7 DAY))',
          ),
          'month' =&gt; 
          array (
            'name' =&gt; 'in the nearest month',
            'where' =&gt; 'c.birth_day IS NOT NULL AND c.birth_month IS NOT NULL AND
                    STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &gt;= NOW() AND (
                        STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= DATE_ADD(NOW(), INTERVAL 30 DAY) OR
                        STR_TO_DATE(CONCAT(YEAR(DATE_ADD(NOW(), INTERVAL 1 YEAR)), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= DATE_ADD(NOW(), INTERVAL 30 DAY))',
          ),
          ':period' =&gt; 
          array (
            'name' =&gt; 'select a period',
            'where' =&gt; 
            array (
              ':between' =&gt; 'c.birth_day IS NOT NULL AND c.birth_month IS NOT NULL AND
                            STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &gt;= \':0\' AND
                                STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= \':1\'',
              ':gt' =&gt; 'c.birth_day IS NOT NULL AND c.birth_month IS NOT NULL AND
                            STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &gt;= \':?\'',
              ':lt' =&gt; 'c.birth_day IS NOT NULL AND c.birth_month IS NOT NULL AND
                            STR_TO_DATE(CONCAT(YEAR(NOW()), \'-\', c.birth_month, \'-\', c.birth_day), \'%Y-%m-%d\') &lt;= \':?\'',
            ),
          ),
        ),
      ),
      'locale' =&gt; 
      array (
        'field_id' =&gt; 'locale',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.locale IS NULL OR c.locale = \'\'',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.locale IS NOT NULL AND c.locale != \'\'',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 1,
            'sql' =&gt; 'SELECT locale AS name, locale AS value, COUNT(*) AS count
                            FROM wa_contact
                            WHERE locale IS NOT NULL AND locale != \'\'
                            GROUP BY locale',
          ),
        ),
      ),
      'timezone' =&gt; 
      array (
        'field_id' =&gt; 'timezone',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.timezone IS NULL OR c.timezone = \'\'',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.timezone IS NOT NULL AND c.timezone != \'\'',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'sql' =&gt; 'SELECT timezone AS name, timezone AS value, COUNT(*) AS count
                                FROM wa_contact
                                WHERE timezone IS NOT NULL AND timezone != \'\'
                                GROUP BY timezone',
          ),
        ),
      ),
      'socialnetwork' =&gt; 
      array (
        'field_id' =&gt; 'socialnetwork',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'socialnetwork\') = 0 ',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; '(SELECT COUNT(*) FROM `wa_contact_data` WHERE contact_id = c.id AND field = \'socialnetwork\') &gt; 0 ',
          ),
          ':sep' =&gt; 
          array (
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'AND value LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT value, value AS name, COUNT(*) count
                                FROM wa_contact_data
                                WHERE field = \'socialnetwork\' :autocomplete
                                GROUP BY value
                                ORDER BY count DESC
                                LIMIT :limit',
            'count' =&gt; 'SELECT COUNT(DISTINCT value) FROM `wa_contact_data` WHERE field = \'socialnetwork\'',
          ),
        ),
      ),
      'about' =&gt; 
      array (
        'field_id' =&gt; 'about',
        'items' =&gt; 
        array (
          'blank' =&gt; 
          array (
            'name' =&gt; 'Empty',
            'where' =&gt; 'c.about IS NULL OR c.about = \'\'',
          ),
          'not_blank' =&gt; 
          array (
            'name' =&gt; 'Not empty',
            'where' =&gt; 'c.about IS NOT NULL AND c.about != \'\'',
          ),
          ':values' =&gt; 
          array (
            'autocomplete' =&gt; 'WHERE about LIKE \'%:term%\'',
            'limit' =&gt; 10,
            'sql' =&gt; 'SELECT about AS name
                            FROM wa_contact
                            :autocomplete
                            LIMIT :limit',
          ),
        ),
      ),
      'contact_type' =&gt; 
      array (
        'name' =&gt; 'Contact type',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'person' =&gt; 
          array (
            'name' =&gt; 'Person',
            'where' =&gt; 'c.is_company = 0',
          ),
          'company' =&gt; 
          array (
            'name' =&gt; 'Company',
            'where' =&gt; 'c.is_company = 1',
          ),
        ),
      ),
      'creating' =&gt; 
      array (
        'name' =&gt; 'Creating method and date',
        'multi' =&gt; true,
        'items' =&gt; 
        array (
          'method' =&gt; 
          array (
            'name' =&gt; 'Method',
            'items' =&gt; 
            array (
              ':values' =&gt; 
              array (
                'autocomplete' =&gt; 1,
                'class' =&gt; 'crmContactsSearchCreateMethodValues',
              ),
            ),
          ),
          'date' =&gt; 
          array (
            'name' =&gt; 'Date',
            'items' =&gt; 
            array (
              ':period' =&gt; 
              array (
                'name' =&gt; 'select a period',
                'where' =&gt; 
                array (
                  ':between' =&gt; 'c.create_datetime IS NOT NULL AND DATE(c.create_datetime) &gt;= \':0\' AND DATE(c.create_datetime) &lt;= \':1\'',
                  ':gt' =&gt; 'c.create_datetime IS NOT NULL AND DATE(c.create_datetime) &gt;= \':?\'',
                  ':lt' =&gt; 'c.create_datetime IS NOT NULL AND DATE(c.create_datetime) &lt;= \':?\'',
                ),
              ),
            ),
          ),
        ),
      ),
    ),
  ),
  'activity' =&gt; 
  array (
    'name' =&gt; 'Activity',
    'items' =&gt; 
    array (
      'action_by' =&gt; 
      array (
        'name' =&gt; 'Performed an action',
        'multi' =&gt; true,
        'join' =&gt; 
        array (
          'table' =&gt; 'wa_log',
        ),
        'items' =&gt; 
        array (
          'action' =&gt; 
          array (
            'name' =&gt; 'Action',
            'readonly' =&gt; true,
            'skip_first_space' =&gt; true,
            'items' =&gt; 
            array (
              'any_action' =&gt; 
              array (
                'name' =&gt; 'any action',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'class' =&gt; 'crmContactsSearchActivityActionValues',
              ),
            ),
          ),
          'period' =&gt; 
          array (
            'name' =&gt; 'Period',
            'items' =&gt; 
            array (
              ':period' =&gt; 
              array (
                'name' =&gt; '',
                'where' =&gt; 
                array (
                  ':between' =&gt; 'DATE(:parent_table.datetime) &gt;= \':0\' AND DATE(:parent_table.datetime) &lt;= \':1\'',
                  ':gt' =&gt; 'DATE(:parent_table.datetime) &gt;= \':?\'',
                  ':lt' =&gt; 'DATE(:parent_table.datetime) &lt;= \':?\'',
                ),
              ),
            ),
          ),
        ),
      ),
      'action_to' =&gt; 
      array (
        'name' =&gt; 'Applied an action to',
        'multi' =&gt; true,
        'join' =&gt; 
        array (
          'table' =&gt; 'wa_log',
          'on' =&gt; ':table.subject_contact_id = c.id',
        ),
        'items' =&gt; 
        array (
          'action' =&gt; 
          array (
            'name' =&gt; 'Action',
            'readonly' =&gt; true,
            'skip_first_space' =&gt; true,
            'items' =&gt; 
            array (
              'any_action' =&gt; 
              array (
                'name' =&gt; 'any action',
              ),
              ':sep' =&gt; 
              array (
              ),
              ':values' =&gt; 
              array (
                'class' =&gt; 'crmContactsSearchActivityActionValues',
                'options' =&gt; 
                array (
                  'subject' =&gt; true,
                ),
              ),
            ),
          ),
          'period' =&gt; 
          array (
            'name' =&gt; 'Period',
            'items' =&gt; 
            array (
              ':period' =&gt; 
              array (
                'name' =&gt; '',
                'where' =&gt; 
                array (
                  ':between' =&gt; 'DATE(:parent_table.datetime) &gt;= \':0\' AND DATE(:parent_table.datetime) &lt;= \':1\'',
                  ':gt' =&gt; 'DATE(:parent_table.datetime) &gt;= \':?\'',
                  ':lt' =&gt; 'DATE(:parent_table.datetime) &lt;= \':?\'',
                ),
              ),
            ),
          ),
        ),
      ),
      'access' =&gt; 
      array (
        'name' =&gt; 'Access',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'forbidden' =&gt; 
          array (
            'name' =&gt; 'Forbidden',
            'where' =&gt; 'c.is_user=-1',
          ),
          'customer_portal' =&gt; 
          array (
            'name' =&gt; 'Customer portal only',
            'where' =&gt; 'c.is_user=0',
          ),
          'backend' =&gt; 
          array (
            'name' =&gt; 'Backend',
            'where' =&gt; 'c.is_user=1',
          ),
        ),
      ),
      'status' =&gt; 
      array (
        'name' =&gt; 'Status',
        'readonly' =&gt; true,
        'items' =&gt; 
        array (
          'online' =&gt; 
          array (
            'name' =&gt; 'Online',
            'join' =&gt; 
            array (
              'table' =&gt; 'wa_login_log',
              'on' =&gt; 'c.id = :table.contact_id',
              'where' =&gt; 'c.last_datetime IS NOT NULL AND
                    UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(c.last_datetime) &lt; \'300\' AND :table.datetime_out IS NULL',
            ),
            'group_by' =&gt; 1,
          ),
          'offline' =&gt; 
          array (
            'name' =&gt; 'Offline',
            'where' =&gt; 'c.last_datetime IS NULL OR
                    UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(c.last_datetime) &gt;= \'300\'',
          ),
          'never_login' =&gt; 
          array (
            'name' =&gt; 'Never logged in',
            'where' =&gt; 'c.last_datetime IS NULL',
          ),
        ),
      ),
    ),
  ),
);
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Fwebasyst'>Back to Directory</a>