التحقق من عدم تكرار القيم في قاعدة البيانات (البيانات الفريدة)

 بداية سنقوم بإضافة هذه الخدمات في الواجهة الخلفية حسب الحقول المطلوبة (Service):

 //------------------- For Add -----------------------
  async countUsersByNationalId(national_id: string) {
    return await this.UserRepository.count({
      where: {
        national_id: national_id
      }
    });
  }

  async countUsersByUsername(username: string) {
    return await this.UserRepository.count({
      where: {
        username: username
      }
    });
  }

  async countUsersByEmail(email: string) {
    return await this.UserRepository.count({
      where: {
        email: email.trim()
      }
    });
  }

  async countUsersByMobileNo(mobile_no: string) {
    return await this.UserRepository.count({
      where: {
        mobile_no: mobile_no
      }
    });
  }

  //------------------- For Edit -----------------------
  async countUsersByNationalIdForEdit(national_id: string, previous_national_id: string) {
    if (previous_national_id === national_id)
      return 0;

    return await this.UserRepository.count({
      where: {
        national_id: national_id
      }
    });
  }

  async countUsersByUsernameForEdit(username: string, old_username: string) {
    if (old_username === username)
      return 0;

    return await this.UserRepository.count({
      where: {
        username: username
      }
    });
  }

  async countUsersByEmailForEdit(email: string, old_email: string) {
    if (old_email === email)
      return 0;

    return await this.UserRepository.count({
      where: {
        email: email.trim()
      }
    });
  }

  async countUsersByMobileNoForEdit(mobile_no: string, old_mobile_no: string) {
    if (old_mobile_no === mobile_no)
      return 0;

    return await this.UserRepository.count({
      where: {
        mobile_no: mobile_no
      }
    });
  }


أما بالنسبة للـ Controller سيكون بهذا النحو:

  //------------------- For Add -----------------------
  @Get('count-users-by-national-id/:national_id')
  countUsersByNationalId(@Param('national_id') national_id: string) {
    if (national_id) {
      return this.usersService.countUsersByNationalId(national_id);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-username/:username')
  countUsersByUsername(@Param('username') username: string) {
    if (username) {
      return this.usersService.countUsersByUsername(username);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-email/:email')
  countUsersByEmail(@Param('email') email: string) {
    if (email) {
      return this.usersService.countUsersByEmail(email);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-mobile-no/:mobile_no')
  countUsersByMobileNo(@Param('mobile_no') mobile_no: string) {
    if (mobile_no) {
      return this.usersService.countUsersByMobileNo(mobile_no);
    } else {
      return 0;
    }
  }

  //------------------- For Edit -----------------------
  @Get('count-users-by-national-id/:national_id/:previous_national_id')
  countUsersByNationalIdForEdit(@Param('national_id') national_id: string, @Param('previous_national_id') previous_national_id) {
    if (national_id) {
      return this.usersService.countUsersByNationalIdForEdit(national_id, previous_national_id);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-username/:username/:old_username')
  countUsersByUsernameForEdit(@Param('username') username: string, @Param('old_username') old_username: string) {
    if (username) {
      return this.usersService.countUsersByUsernameForEdit(username, old_username);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-email/:email/:old_email')
  countUsersByEmailForEdit(@Param('email') email: string, @Param('old_email') old_email: string) {
    if (email) {
      return this.usersService.countUsersByEmailForEdit(email, old_email);
    } else {
      return 0;
    }
  }

  @Get('count-users-by-mobile-no/:mobile_no/:old_mobile_no')
  countUsersByMobileNoForEdit(@Param('mobile_no') mobile_no: string, @Param('old_mobile_no') old_mobile_no: string) {
    if (mobile_no) {
      return this.usersService.countUsersByMobileNoForEdit(mobile_no, old_mobile_no);
    } else {
      return 0;
    }
  }

أما بالنسبة لخدمة الواجهة الأمامية ستكون بهذا النحو:

  countUsersByNationalId(national_id: string) {
    return this.http.get(`${this.api}/${this.table}/count-users-by-national-id/${national_id}`);
  }

  countUsersByUsername(username: string) {
    return this.http.get(`${this.api}/${this.table}/count-users-by-username/${username}`);
  }

  countUsersByMobileNo(mobile: string) {
    return this.http.get(`${this.api}/${this.table}/count-users-by-mobile-no/${mobile}`);
  }

  countUsersByEmail(email: string) {
    return this.http.get(`${this.api}/${this.table}/count-users-by-email/${email}`);
  }

طريقة الاستخدام للتحقق من وجود الحقول أو لا (في حالة الإضافة):

//Vareibales
  _existsNationalId: boolean = false;
  _existsEmail: boolean = false;
  _existsMobileNo: boolean = false;
  _existsUsername: boolean = false;

  existsEmail(event: string) {
    if (event) {
      this.usersService.countUsersByEmail(event).subscribe((res) => {
        setTimeout(() => {
          if (res.toString() === "1") {
            this._existsEmail = true;
          } else {
            this._existsEmail = false;
          }
        }, 500);
      },
        (error) => {
          this._existsEmail = false;
        });
    } else {
      this._existsEmail = false;
    }
  }

  existsNationalId(event: string) {
    if (event) {
      this.usersService.countUsersByNationalId(event).subscribe((res) => {
        setTimeout(() => {
          if (res.toString() === "1") {
            this._existsNationalId = true;
          } else {
            this._existsNationalId = false;
          }
        }, 500);
      },
        (error) => {
          this._existsNationalId = false;
        });
    } else {
      this._existsNationalId = false;
    }
  }

  existsUsername(event: string) {
    if (event) {
      this.usersService.countUsersByUsername(event).subscribe((res) => {
        setTimeout(() => {
          if (res.toString() === "1") {
            this._existsUsername = true;
          } else {
            this._existsUsername = false;
          }
        }, 500);
      },
        (error) => {
          this._existsUsername = false;
        });
    } else {
      this._existsUsername = false;
    }
  }

  existsMobileNo(event: string) {
    if (event) {
      this.usersService.countUsersByMobileNo(event).subscribe((res) => {
        setTimeout(() => {
          if (res.toString() === "1") {
            this._existsMobileNo = true;
          } else {
            this._existsMobileNo = false;
          }
        }, 500);
      },
        (error) => {
          this._existsMobileNo = false;
        });
    } else {
      this._existsMobileNo = false;
    }
  }
  //------------------ End ----------------------------

طريقة الاستخدام للتحقق من وجود الحقول أو لا (في حالة التعديل):

  oldUser: User = new User();
  ngOnInit() {
    this.usersService.getOneItem(this.id).subscribe(res => {
      this.oldUser = res;
    });
  }

  existsEmail(event: string) {
    if (event) {
      if (this.oldUser.email) {
        this.usersService.countUsersByEmailForEdit(event, this.oldUser.email).subscribe((res) => {
          setTimeout(() => {
            if (res.toString() === "1") {
              this._existsEmail = true;
            } else {
              this._existsEmail = false;
            }
          }, 500);
        },
          (error) => {
            this._existsEmail = false;
          });
      } else {
        this._existsEmail = false;
      }
    } else {
      this._existsEmail = false;
    }
  }

  existsNationalId(event: string) {
    if (event) {
      if (this.oldUser.national_id) {
        this.usersService.countUsersByNationalIdForEdit(event, this.oldUser.national_id).subscribe((res) => {
          setTimeout(() => {
            if (res.toString() === "1") {
              this._existsNationalId = true;
            } else {
              this._existsNationalId = false;
            }
          }, 500);
        },
          (error) => {
            this._existsNationalId = false;
          });
      } else {
        if (event) {
          this.usersService.countUsersByNationalId(event).subscribe((res) => {
            setTimeout(() => {
              if (res.toString() === "1") {
                this._existsNationalId = true;
              } else {
                this._existsNationalId = false;
              }
            }, 500);
          },
            (error) => {
              this._existsNationalId = false;
            });
        } else {
          this._existsNationalId = false;
        }
      }
    } else {
      this._existsNationalId = false;
    }
  }

  existsUsername(event: string) {
    if (event) {
      if (this.oldUser.username) {
        this.usersService.countUsersByUsernameForEdit(event, this.oldUser.username).subscribe((res) => {
          setTimeout(() => {
            if (res.toString() === "1") {
              this._existsUsername = true;
            } else {
              this._existsUsername = false;
            }
          }, 500);
        },
          (error) => {
            this._existsUsername = false;
          });
      } else {
        this._existsUsername = false;
      }
    } else {
      this._existsUsername = false;
    }
  }

  existsMobileNo(event: string) {
    if (event) {
      if (this.oldUser.mobile_no) {
        this.usersService.countUsersByMobileNoForEdit(event, this.oldUser.mobile_no).subscribe((res) => {
          setTimeout(() => {
            if (res.toString() === "1") {
              this._existsMobileNo = true;
            } else {
              this._existsMobileNo = false;
            }
          }, 500);
        },
          (error) => {
            this._existsMobileNo = false;
          });
      } else {
        this._existsMobileNo = false;
      }
    } else {
      this._existsMobileNo = false;
    }
  }

استدعاء الدوال عبر ملفات الـ HTML :

<!-- اسم المستخدم -->
<div class="col-sm-6">
  <mat-form-field class="w-100 mt-1" appearance="outline">
  <mat-label>{{'LABELS.USERNAME' |
    translate}}</mat-label>
    <input #username [(ngModel)]="user.username"
    (keyup)="existsUsername(user.username)"
    formControlName="username" maxlength="11" matInput
    type="text"
    [placeholder]="'PLACEHOLDERS.USERNAME' | translate"
    required>
    <mat-icon matSuffix class="icon-edit">person</mat-icon>
      <mat-error align="start"
    *ngIf="form.controls['username'].hasError('required')">
      {{'ERRORS.REQUIRED' | translate}}
    </mat-error>
  <mat-hint *ngIf="_existsUsername"
    style="color:red !important"
    class="animate__animated animate__fadeInRight">{{'ERRORS.EXISTS_VALUE'
  | translate}}</mat-hint>
    <mat-hint align="end">{{username.value.length}} /
    11</mat-hint>
  </mat-form-field>
</div>


شكراً على القراءة .....






























تعليقات

إرسال تعليق

المشاركات الشائعة من هذه المدونة

ngx-extended-pdf-viewer

https://www.npmjs.com/package/ngx-extended-pdf-viewer https://pdfviewer.net/extended-pdf-viewer/simple المكتبة: https://github.com/vadimdez/ng2-pdf-viewer  To view a PDF file using a lightbox in Angular, you can use the ngx-extended-pdf-viewer library for displaying the PDF and ng-gallery for the lightbox functionality. Here’s a step-by-step guide: Step 1: Install the Required Packages Install ngx-extended-pdf-viewer : This library provides an efficient way to display PDFs in Angular. Install ng-gallery : This library provides a customizable lightbox gallery. Run the following commands: bash نسخ الكود npm install ngx-extended-pdf-viewer npm install ng-gallery Step 2: Import Modules in Your Angular Module In your main Angular module (e.g., app.module.ts ), import both NgxExtendedPdfViewerModule and GalleryModule . typescript نسخ الكود import { NgxExtendedPdfViewerModule } from 'ngx-extended-pdf-viewer' ; import { GalleryModule } from 'ng-gallery' ; @NgModule ({...
قراءة المزيد

how to getting access token for https://fcm.googleapis.com/v1/projects/al-ayahya-co/messages:send for angular and backend nestjs

صورة
  Getting Access Token for FCM in Angular and NestJS To send messages using the Firebase Cloud Messaging (FCM) HTTP v1 API, you need to obtain an access token that authorizes your requests. Below are the steps to achieve this using Angular for the frontend and NestJS for the backend. Step 1: Set Up Firebase Project Create a Firebase Project : Go to the  Firebase Console  and create a new project if you haven't already. Enable FCM : In your Firebase project, navigate to the Cloud Messaging section and enable it. Step 2: Service Account Key Generate a Service Account Key : In the Firebase Console, go to  Project Settings  >  Service accounts . Click on  Generate new private key . This will download a JSON file containing your service account credentials. Step 3: Backend (NestJS) Implementation Install Required Packages : You need to install the  google-auth-library  to handle authentication: bash npm install google-auth-library Create a Serv...
قراءة المزيد

طريقة تفعيل زر Inline Keyboard في Telegram Bot

https://g.co/bard/share/85e904a02dd1 https://g.co/bard/share/99e480e0dca7  there are two main approaches to achieve this functionality in your Telegram bot: 1. Inline Keyboard with URL Button: This approach uses an inline keyboard with a button linked to the desired website URL. Here's how: Create an inline keyboard: Use the InlineKeyboardMarkup object provided by your chosen bot development library (e.g., Telegraf for Python). Define a list of lists where each sublist represents a row of buttons. Add a URL button: In each sublist, add an InlineKeyboardButton object with the button text and the url parameter set to the website URL. Send the message with the keyboard: Use the sendMessage method with the inline_keyboard parameter set to your created inline keyboard object. Example (Python with Telegraf): Python from telegraf.ext import Updater, CommandHandler, MessageHandler, Filters def open_website(update, context):   keyboard = InlineKeyboardMarkup([     [InlineKeyb...
قراءة المزيد