P-Table Otomatik Export¶
P-Table Otomatik Export, P-Table'ın verilerini otomatik olarak dışa aktarmanızı sağlar.
- [dataTable] => p-table #dataTable değeri
- [title] => Başlık
- [disablePdfExport] => Pdf export kullanılmasın
- [orientationPdf] => 'portrait' | 'landscape' = 'portrait'; PDF Yönü
- [apiUrl] => Verilerin export edileceği api url adresi, GetWithFilter api olmak zorundadır.
- [id] => Export butonlarına id vermek için kullanılır
- [showTitlePdf] => PDF export işleminde başlık gösterilsin
- [showDatePdf] => PDF export işleminde tarih gösterilsin
- [showPageNumberPdf] => PDF export işleminde sayfa numarası gösterilsin
- [enableShowGlobalLoading] => Dosya yükleme anında global loading gösterilsin mi
- [disableCsvExport] => CSV export kullanılmasın
- [disableExcelExport] => Excel export kullanılmasın
<alpata-table-export
[dataTable]="dataTable"
[title]="'Banka Hareketleri Listesi'"
[disablePdfExport]="true"
[orientationPdf]="'landscape'"
[apiUrl]="'/api/v1/Finance/FinanceBankaHareketleri/GetWithFilterInfo'"
[id]="'id_degeri_giriniz'">
</alpata-table-export>
Örnek P-Table Kodu¶
Aşağıdaki kod bloğu Finance banka hareketleri sayfasından alınmıştır.
<p-table #dataTable [lazy]="true" [value]="itemListe" [rowsPerPageOptions]="[10, 25, 50, 100]"
[showCurrentPageReport]="true" [paginator]="true" [rows]="10" [loading]="isLoadingTableData"
(onLazyLoad)="pTableVeriGetir($event)" [sortOrder]="1" responsiveLayout="scroll"
[totalRecords]="totalRecords" [sortField]="'Id'"
[currentPageReportTemplate]="isLoadingTableData ? '': 'Sayfa {currentPage}/{totalPages} ({totalRecords} kayıt)'">
<ng-template pTemplate="caption">
<div class="p-d-flex">
<alpata-table-export [dataTable]="dataTable" [title]="'Banka Hareketleri Listesi'"
[disablePdfExport]="true" [orientationPdf]="'landscape'"
[apiUrl]="'/api/v1/Finance/FinanceBankaHareketleri/GetWithFilterInfo'" [id]="'ff'">
</alpata-table-export>
</div>
</ng-template>
<ng-template pTemplate="header">
<tr>
<th scope="col" class="ptable-sube" data-prop="AuthInfo" data-type="sube">
<div class="p-d-flex p-jc-between p-ai-center">
Şube
</div>
</th>
<th scope="col" pSortableColumn="CariKodu" data-prop="CariKodu">
<div class="p-d-flex p-jc-between p-ai-center">
Cari Kodu <p-sortIcon field="CariKodu"></p-sortIcon>
<p-columnFilter type="text" field="CariKodu" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="CariUnvan" data-prop="CariUnvan">
<div class="p-d-flex p-jc-between p-ai-center">
Cari Unvan <p-sortIcon field="CariUnvan"></p-sortIcon>
<p-columnFilter type="text" field="CariUnvan" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="Tarih" data-prop="Tarih" data-type="date">
<div class="p-d-flex p-jc-between p-ai-center">
İşlem Tarihi <p-sortIcon field="Tarih"></p-sortIcon>
<p-columnFilter type="date" field="Tarih" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="DekontNo" data-prop="DekontNo">
<div class="p-d-flex p-jc-between p-ai-center">
Dekont No<p-sortIcon field="DekontNo"></p-sortIcon>
<p-columnFilter type="text" field="DekontNo" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="GirisBankaAdi" data-prop="GirisBankaAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Giriş Banka <p-sortIcon field="GirisBankaAdi"></p-sortIcon>
<p-columnFilter type="text" field="GirisBankaAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="GirisBankaSubeAdi" data-prop="GirisBankaSubeAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Giriş Şube <p-sortIcon field="GirisBankaSubeAdi"></p-sortIcon>
<p-columnFilter type="text" field="GirisBankaSubeAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="GirisHesapAdi" data-prop="GirisHesapAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Giriş Hesap <p-sortIcon field="GirisHesapAdi"></p-sortIcon>
<p-columnFilter type="text" field="GirisHesapAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="CikisBankaAdi" data-prop="CikisBankaAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Çıkış Banka <p-sortIcon field="CikisBankaAdi"></p-sortIcon>
<p-columnFilter type="text" field="CikisBankaAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="CikisBankaSubeAdi" data-prop="CikisBankaSubeAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Çıkış Şube <p-sortIcon field="CikisBankaSubeAdi"></p-sortIcon>
<p-columnFilter type="text" field="CikisBankaSubeAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="CikisHesapAdi" data-prop="CikisHesapAdi">
<div class="p-d-flex p-jc-between p-ai-center">
Çıkış Hesap <p-sortIcon field="CikisHesapAdi"></p-sortIcon>
<p-columnFilter type="text" field="CikisHesapAdi" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="Tutar" data-prop="Tutar" data-type="currency">
<div class="p-d-flex p-jc-between p-ai-center">
Tutar
<p-sortIcon field="Tutar"></p-sortIcon>
<p-columnFilter type="text" field="Tutar" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="IslemUcreti" data-prop="IslemUcreti" data-type="currency">
<div class="p-d-flex p-jc-between p-ai-center">
İşlem Ücreti <p-sortIcon field="IslemUcreti"></p-sortIcon>
<p-columnFilter type="text" field="IslemUcreti" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="Aciklama" data-prop="Aciklama">
<div class="p-d-flex p-jc-between p-ai-center">
Açıklama
<p-sortIcon field="Aciklama"></p-sortIcon>
<p-columnFilter type="text" field="Aciklama" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="BankaHareketTipDurumInfo" data-prop="BankaHareketTipDurumInfo">
<div class="p-d-flex p-jc-between p-ai-center">
İşlem Tipi
<p-sortIcon field="BankaHareketTipDurumInfo"></p-sortIcon>
<p-columnFilter type="text" field="BankaHareketTipDurumInfo" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="BankaHareketDurumInfo" data-prop="BankaHareketDurumInfo">
<div class="p-d-flex p-jc-between p-ai-center">
Durum <p-sortIcon field="BankaHareketDurumInfo"></p-sortIcon>
<p-columnFilter type="text" field="BankaHareketDurumInfo" display="menu"></p-columnFilter>
</div>
</th>
<th scope="col" pSortableColumn="KaynakTipInfo" data-prop="KaynakTipInfo">
<div class="p-d-flex p-jc-between p-ai-center">
Kaynak Tip
<p-sortIcon field="KaynakTipInfo"></p-sortIcon>
<p-columnFilter type="text" field="KaynakTipInfo" display="menu"></p-columnFilter>
</div>
</th>
</tr>
</ng-template>
<ng-template pTemplate="body" let-item>
<tr>
<td class="ptable-sube">
<alpata-sube-bilgi [data]="item" [id]="'2'"></alpata-sube-bilgi>
</td>
<td>{{item.CariKodu}}</td>
<td>{{item.CariUnvan}}</td>
<td>{{item.Tarih | date: "dd/MM/yyyy HH:mm:ss"}}</td>
<td>{{item.DekontNo}}</td>
<td>{{item.GirisBankaAdi}}</td>
<td>{{item.GirisBankaSubeAdi}}</td>
<td>{{item.GirisHesapAdi}}</td>
<td>{{item.CikisBankaAdi}}</td>
<td>{{item.CikisBankaSubeAdi}}</td>
<td>{{item.CikisHesapAdi}}</td>
<td>{{item.Tutar| currency:'':'':'1.2-2':'tr'}}</td>
<td>{{item.IslemUcreti| currency:'':'':'1.2-2':'tr'}}</td>
<td>{{item.Aciklama}}</td>
<td>{{item.BankaHareketTipDurumInfo}}</td>
<td>{{item.BankaHareketDurumInfo}}</td>
<td>{{item.KaynakTipInfo}}</td>
</tr>
</ng-template>
<ng-template pTemplate="emptymessage">
<tr>
<td colspan="44">Gösterilecek kayıt yok</td>
</tr>
</ng-template>
</p-table>