UserMsgsSentStorageAcl.php 696 B

123456789101112131415161718192021222324252627
  1. <?php
  2. Lib::loadClass('Core_AclSimpleSchemaBase');
  3. Lib::loadClass('Schema_UserMsgsStorageAcl');
  4. Lib::loadClass('ParseOgcFilter');
  5. class Schema_UserMsgsSentStorageAcl extends Schema_UserMsgsStorageAcl {
  6. function _parseSqlWhere($params = []) {
  7. $sqlWhereAnd = [];
  8. $sqlWhereAnd[] = " m.`uiTargetType` = 'default_db_table_record' ";
  9. $sqlUserLogin = DB::getPDO()->quote($this->login);
  10. $sqlWhereAnd[] = " m.`A_RECORD_CREATE_AUTHOR` = {$sqlUserLogin} ";
  11. $sqlWhereAnd[] = "
  12. ( m.`A_STATUS` in('WAITING', 'NORMAL')
  13. or ( m.`A_STATUS` = 'OFF_HARD' and m.`A_RECORD_DELETE_AUTHOR` != 'plabudda' )
  14. )
  15. ";
  16. // TODO: parse where/ogc, etc.
  17. return implode(" and ", $sqlWhereAnd);
  18. }
  19. }