erLhcoreClassModelUser::getUserCount PHP Method

getUserCount() public static method

public static getUserCount ( $params = [] )
    public static function getUserCount($params = array())
    {
        $session = erLhcoreClassUser::getSession();
        $q = $session->database->createSelectQuery();
        $q->select("COUNT(id)")->from("lh_users");
        if (isset($params['filter']) && count($params['filter']) > 0) {
            $conditions = array();
            foreach ($params['filter'] as $field => $fieldValue) {
                $conditions[] = $q->expr->eq($field, $q->bindValue($fieldValue));
            }
            $q->where($conditions);
        }
        $stmt = $q->prepare();
        $stmt->execute();
        $result = $stmt->fetchColumn();
        return $result;
    }

Usage Example

コード例 #1
0
         }
         $stringParts[] = array('key' => $name_item, 'value' => isset($valuesArray[$key]) ? trim($valuesArray[$key]) : '');
     }
     $chat->additional_data = json_encode($stringParts);
 }
 if (erLhcoreClassModelChatConfig::fetch('session_captcha')->current_value == 1) {
     if (!$form->hasValidData($nameField) || $form->{$nameField} == '' || $form->{$nameField} < time() - 600 || $hashCaptcha != sha1($_SERVER['REMOTE_ADDR'] . $form->{$nameField} . erConfigClassLhConfig::getInstance()->getSetting('site', 'secrethash'))) {
         $Errors[] = erTranslationClassLhTranslation::getInstance()->getTranslation('chat/startchat', 'Invalid captcha code, please enable Javascript!');
     }
 } else {
     // Captcha validation
     if (!$form->hasValidData($nameField) || $form->{$nameField} == '' || $form->{$nameField} < time() - 600) {
         $Errors[] = erTranslationClassLhTranslation::getInstance()->getTranslation('chat/startchat', 'Invalid captcha code, please enable Javascript!');
     }
 }
 if ($form->hasValidData('operator') && erLhcoreClassModelUser::getUserCount(array('filter' => array('id' => $form->operator, 'disabled' => 0))) > 0) {
     $inputData->operator = $chat->user_id = $form->operator;
 }
 if ($form->hasValidData('user_timezone')) {
     $timezone_name = timezone_name_from_abbr(null, $form->user_timezone * 3600, true);
     if ($timezone_name !== false) {
         $chat->user_tz_identifier = $timezone_name;
     } else {
         $chat->user_tz_identifier = '';
     }
 }
 $chat->dep_id = $inputData->departament_id;
 // Assign default department
 if ($form->hasValidData('DepartamentID') && erLhcoreClassModelDepartament::getCount(array('filter' => array('id' => $form->DepartamentID, 'disabled' => 0))) > 0) {
     $inputData->departament_id = $chat->dep_id = $form->DepartamentID;
 } elseif ($chat->dep_id == 0 || erLhcoreClassModelDepartament::getCount(array('filter' => array('id' => $chat->dep_id, 'disabled' => 0))) == 0) {
All Usage Examples Of erLhcoreClassModelUser::getUserCount