Exemplos de CUserMessage::countList em PHP

Exemplo n.º 1

Arquivo: ajax_list_usermessage.php Projeto: fbone/mediboard4

$step = CAppUI::pref("nbMailList");
$usermessage = new CUserMessage();
$group = null;
$where = array();
$lj = array("usermessage_dest" => "usermessage.usermessage_id = usermessage_dest.user_message_id");
$order = "usermessage_dest.datetime_sent DESC";
$unread = 0;
if ($mode == "inbox") {
    $where = array();
    $where["usermessage_dest.to_user_id"] = " = '{$user->_id}'";
    $where["datetime_sent"] = " IS NOT NULL";
    $where["usermessage_dest.archived"] = " = '0'";
    $where['usermessage_dest.deleted'] = " = '0'";
    $order = "usermessage_dest.starred DESC, usermessage_dest.datetime_sent DESC";
    $where["datetime_read"] = " IS NULL";
    $unread = $usermessage->countList($where, $group, $lj);
    $unread = $unread ? $unread : 0;
    unset($where["datetime_read"]);
    $total_found = CUserMessageDest::countInboxFor($user);
}
if ($mode == "archive") {
    $where = array();
    $where["usermessage_dest.to_user_id"] = " = '{$user->_id}'";
    $where["usermessage_dest.archived"] = " = '1'";
    $where['usermessage_dest.deleted'] = " = '0'";
    $order = "usermessage_dest.starred DESC, usermessage_dest.datetime_sent DESC";
    $total_found = CUserMessageDest::countArchivedFor($user);
}
if ($mode == "sentbox") {
    $where = array();
    $where["from_user_id"] = " = '{$user->_id}'";