expiringsubscriptionreport.component.html 10 KB
<style>
  :host /deep/ ng2-smart-table {
    font-size: 12px;
  }
</style>
<div class="row" style="margin-right: auto;">
  <div class="col-sm-12 pageHeading" style="margin-left: 15px;">
    <h4>Expiring Subscription Report</h4>
  </div>
  <div class="col-sm-12">

    <div class="container-fluid main-full">
      <div class="row" style="margin-right:-40px">
        <div class="well no-margin-btm">
            <div class="col-xs-12" *ngIf="alerts !== ''">
                <div class="alert alert-danger" [innerHTML]="alerts">
                </div>

              </div>
          <div class="row" [formGroup]="ExpiringSubscriptionReportForm">
            <div class="col-lg-4 col-sm-4">
              <div class="row">
                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="sFromDate" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">From Date :</label>
                    <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                      <div id="sFromDate" class="input-group input-group-sm input-append date">
                        <input type="text" class="form-control" [bsConfig]="bsConfig" formControlName="sFromDate" #dp1="bsDatepicker" bsDatepicker [(bsValue)]="bsValue1"
						(bsValueChange)="FromDateChange(dp1)" (change)="FromDateChange(dp1)" placeholder="mm/dd/yyyy">                     
                        <span class="input-group-btn add-on">
                          <button class="btn btn-default" type="button" (click)="dp1.toggle()"><i class="fa fa-calendar"></i></button>
                        </span>
                      </div>
                    </div>

                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="sToDate" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">To Date :</label>
                    <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                      <div id="sToDate" class="input-group input-group-sm input-append date">
                        <input type="text" class="form-control" [bsConfig]="bsConfig" formControlName="sToDate"  #dp2="bsDatepicker" bsDatepicker [(bsValue)]="bsValue2" 
						(bsValueChange)="ToDateChange(dp2)" (change)="ToDateChange(dp2)" placeholder="mm/dd/yyyy">
                        <span class="input-group-btn add-on">
                          <button class="btn btn-default" type="button" (click)="dp2.toggle()"><i class="fa fa-calendar"></i></button>
                        </span>
                      </div>
                    </div>

                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="Zip" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">Zip :</label>
                    <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                      <input type="text" class="form-control input-sm" id="Zip" placeholder="" formControlName="sZip">
                    </div>

                  </div>
                </div>


              </div>
            </div>
            <div class="col-lg-4 col-sm-4">
              <div class="row">
                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="LicenseType" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">License Type :</label>
                  </div>
                  <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                    <select class="form-control input-sm" id="LicenseType" formControlName="iLicenseTypeId">
                      <option selected="selected" value="0">All</option>
                      <option *ngFor="let lcitem of lstLicenceType" value="{{lcitem.Id}}">{{lcitem.Title}}</option>
                    </select>
                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="LicenseType" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">Account Type :</label>
                  </div>
                  <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                    <select class="form-control input-sm" id="AccountType"  formControlName="iAccountTypeId">
                      <option selected="selected" value="0">All</option>
                      <option *ngFor="let at of lstAccountType" value="{{at.Id}}">{{at.Title}}</option>
                    </select>
                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="State" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">State(only U.S.) :</label>
                    <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                      <select class="form-control input-sm " id="State" formControlName="iStateId">
                        <option selected="selected" value="0">All</option>
                        <option *ngFor="let item of lstState" value="{{item.Id}}">
                          {{item.StateName}}
                        </option>
                      </select>
                    </div>
                  </div>
                </div>

              </div>
            </div>
            <div class="col-lg-4 col-sm-4">
              <div class="row">

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="SubscriptionStart" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">Subscription Start Price :</label>
                  </div>
                  <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                    <input type="text" class="form-control input-sm" id="SubscriptionStart" placeholder="" formControlName="iStartPrice" >
                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="SubscriptionEnd" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">Subscription End Price :</label>
                  </div>
                  <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                    <input type="text" class="form-control input-sm" id="SubscriptionEnd" placeholder=""  formControlName="iEndPrice">
                  </div>
                </div>

                <div class="col-sm-12">
                  <div class="form-group marginTop5">
                    <label for="State" class="col-sm-12 col-lg-6 control-label text-right-lg paddTop7 padd-left0">Country :</label>
                    <div class="col-sm-12 col-lg-6 padd-left0 padd-right0">
                      <select class="form-control input-sm " id="Country"  formControlName="iCountryId">
                        <option selected="selected" value="0">All</option>
                        <option *ngFor="let c of lstCountry" value="{{c.Id}}">{{c.CountryName}}</option>   
                      </select>
                    </div>
                  </div>
                </div>
                
                <div class="col-sm-12">
                  <div class="form-group marginTop5 text-right">
                    <button class="btn btn-primary btn-sm" data-toggle="modal" data-target="#mymodal" (click)="SearchRecords()" [disabled]="!ExpiringSubscriptionReportForm.valid || alerts != ''"><i class="fa fa-file"></i>  Generate Report</button>
                  </div>
                </div>

              </div>
            </div>
          </div>
          

        </div>

        <div class="well">
          <table id="fixed_hdr2" class="table-hover  ui-widget-header sorttable">
            <thead>
              <tr>
                <th id="AccountNumber">Account Number</th>
                <th id="LicenseeName">Licensee Name</th>
                <th id="LicenseType">License Type</th>
                <th id="InstitutionName">Institution Name</th>
                <th id="AccountType">Account Type</th>            
                <th id="StartDate">Start Date</th>
                <th id="EndDate">End Date</th>
                <th id="LicenseCreationDate">Original Entry Date</th>
                <th id="SubscriptionPrice">Subscription Price</th>
                <th id="DaysRemaining">Time Period</th>
                <th id="CardNumber">Card Number</th>
              </tr>
            </thead>
            <tbody>
              <tr *ngIf="NoRecord !== ''">

                <td colspan="6"><b style="color: red;text-align: center; padding-left: 606px;"><span [innerHTML]="NoRecord"></span></b></td>
              </tr>
              <tr *ngFor="let esr of lstExpiringSubscriptionReport | orderBy: key : reverse;">
                <td>{{esr.AccountNumber}}</td>
                <td>{{esr.LicenseeName}}</td>
                <td>{{esr.LicenseType}}</td>
                <td>{{esr.InstitutionName}}</td>
                <td>{{esr.AccountType}}</td>              
                <td>{{esr.StartDate | date: 'MM/dd/yyyy'}}</td>
                <td>{{esr.EndDate | date: 'MM/dd/yyyy'}}</td>
                <td>{{esr.LicenseCreationDate | date: 'MM/dd/yyyy'}}</td>
                <td>{{esr.SubscriptionPrice}}</td>
                <td>{{esr.DaysRemaining}}</td>
                <td>{{esr.CardNumber}}</td>
              </tr>
            </tbody>
          </table>
          <admin-pager [recordCount]="recordCount" [pageNo]="pageNo" [pageLength]="pageLength" (pagerEvent)="GetExpiringSubscriptionReport($event)"></admin-pager>
          <div class="row">
            <div class="col-sm-12 marginTop20 text-center">
              <button type="button" class="btn btn-primary btn-sm" (click)="ExportEvent()" [ngClass]="{disabled : !buttonStatus}"><i class="fa fa-file-excel-o"></i>  Export To CSV</button>
            </div>
          </div>
        </div>

      </div>
    </div>
  </div>
</div>