Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 1 | Rev 2220 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 1 Rev 2219
Línea 7... Línea 7...
7 
use LeadersLinked\Model\ChatGroupUserMessage;
 7 
use LeadersLinked\Model\ChatGroupUserMessage;
8 
use LeadersLinked\Mapper\Common\MapperCommon;
 8 
use LeadersLinked\Mapper\Common\MapperCommon;
9 
use Laminas\Db\Adapter\AdapterInterface;
 9 
use Laminas\Db\Adapter\AdapterInterface;
10 
use Laminas\Log\LoggerInterface;
 10 
use Laminas\Log\LoggerInterface;
11 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 11 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
- 
 
 12 
use Laminas\Db\Sql\Expression;
Línea 12... Línea 13...
12 
 
 13 
 
13 
class ChatGroupUserMessageMapper extends MapperCommon
 14 
class ChatGroupUserMessageMapper extends MapperCommon
14 
{
 15 
{
Línea 41... Línea 42...
41 
            self::$_instance = new ChatGroupUserMessageMapper($adapter);
 42 
            self::$_instance = new ChatGroupUserMessageMapper($adapter);
42 
        }
 43 
        }
43 
        return self::$_instance;
 44 
        return self::$_instance;
44 
    }
 45 
    }
Línea -... Línea 46...
- 
 
 46
- 
 
 47 
 
- 
 
 48
- 
 
 49
- 
 
 50 
    /**
- 
 
 51 
     *
- 
 
 52 
     * @param int $group_id
- 
 
 53 
     * @param int $user_id
- 
 
 54 
     * @return boolean
- 
 
 55 
     */
- 
 
 56 
    public function existcountNotSeenMessages($group_id, $user_id)
- 
 
 57 
    {
- 
 
 58 
 
- 
 
 59 
        $select = $this->sql->select(self::_TABLE);
- 
 
 60 
        $select->columns(['total' => new Expression('COUNT(*)')]);
- 
 
 61 
        $select->where->equalTo('group_id', $group_id);
- 
 
 62 
        $select->where->equalTo('receiver_id', $user_id);
- 
 
 63 
        $select->where->equalTo('seen', ChatGroupUserMessage::SEEN_NO);
- 
 
 64 
 
- 
 
 65
- 
 
 66 
        $record = $this->executeFetchOneArray($select);
- 
 
 67 
        return $record['total'];
- 
 
 68
- 
 
 69 
    }
- 
 
 70
- 
 
 71 
    /**
- 
 
 72 
     *
- 
 
 73 
     * @param int $group_id
- 
 
 74 
     * @param int $user_id
- 
 
 75 
     * @return boolean
- 
 
 76 
     */
- 
 
 77 
    public function countNotReceivedMessages($group_id, $user_id)
- 
 
 78 
    {
- 
 
 79 
 
- 
 
 80 
        $select = $this->sql->select(self::_TABLE);
- 
 
 81 
        $select->columns(['total' => new Expression('COUNT(*)')]);
- 
 
 82 
        $select->where->equalTo('group_id', $group_id);
- 
 
 83 
        $select->where->equalTo('receiver_id', $user_id);
- 
 
 84 
        $select->where->equalTo('recd', ChatGroupUserMessage::RECD_NO);
- 
 
 85 
 
- 
 
 86
- 
 
 87 
        $record = $this->executeFetchOneArray($select);
- 
 
 88 
        return $record['total'];
- 
 
 89
- 
 
 90 
    }
- 
 
 91
Línea 45... Línea 92...
45
92
46
93
47 
    /**
 94 
    /**
48 
     *
95 
     *