templates/backend/laporan/_table2.html.twig line 1

Open in your IDE?
  2.                                     
  3.                                     <div class="row">
  4.                                         <div class="col-lg-12">
  5.                                                 <strong>REKAPITULASI JUMLAH PAKET BERDASARKAN PROGRESS PEMILIHAN PENYEDIA, SUMBER DANA, DAN PLANT</strong>
  6.                                     <hr>
  7.                                             <div class="table-responsive">
  8.                                                 <table class="table table-bordered" border="1" id="table_ajax" width="100%">
  9.                                                     <thead>
  10.                                                         <tr>
  11.                                                             <th rowspan="3" style="vertical-align:middle; text-align:center">SUMBER DANA</th>
  12.                                                             <th rowspan="3" style="vertical-align:middle; text-align:center">PLANT</th>
  13.                                                             <th colspan="5" style="text-align: center;">JUMLAH PAKET</th>
  14.                                                         </tr>
  15.                                                         <tr>
  16.                                                             <th rowspan="2" style="text-align: center;">Total PK (di Div.Pengadaan)</th>
  17.                                                             <th colspan="2" style="text-align: center;">Selesai</th>
  18.                                                             <th colspan="2" style="text-align: center;">Dalam Proses</th>
  19.                                                         </tr>
  20.                                                         <tr>
  21.                                                            
  22.                                                             <th style="text-align: center;">Jumlah</th>
  23.                                                             <th style="text-align: center;">%</th>
  24.                                                             <th style="text-align: center;">Jumlah</th>
  25.                                                             <th style="text-align: center;">*Rata-Rata Count Days (Hari Kalender)</th>
  26.                                                         </tr>
  27.                                                     </thead>
  28.                                                     <tbody>
  29.                                                         {% set grand_total_pemilihan_penyedia = 0 %}
  30.                                                         {% set grand_total_selesai = 0 %}
  31.                                                         {% set grand_total_persen_selesai = 0 %}
  32.                                                         {% set grand_total_proses = 0 %}
  33.                                                         {% set grand_total_rata_countdays = 0 %}
  34.                                                         {% set jumlah_sumber = 0 %}
  35.                                                         {% for sumber_dana, items in result %}
  36.                                                             {% set rowspan = items|length %}
  37.                                                             {% set total_pemilihan_penyedia = 0 %}
  38.                                                             {% set total_selesai = 0 %}
  39.                                                             {% set total_persen_selesai = 0 %}
  40.                                                             {% set total_proses = 0 %}
  41.                                                             {% set total_countdays = 0 %}
  42.                                                             {% set rata_countdays_per_item = 0 %}
  43.                                                             {% set total_rata_countdays = 0 %}
  44.                                                             {% set persen = 0 %}
  45.                                                             {% set loop_index = 0 %}
  46.                                                             {% set jumlah_item = 0 %}
  47.                                                             
  48.                                                             {% for item in items %}
  49.                                                             {% set persen = item.dalam_proses != 0 ? (item.selesai / (item.dalam_proses + item.selesai) * 100) : 0 %}
  50.                                                             {% set rata_countdays_per_item = item.dalam_proses != 0 ? (item.total_hari_kerja / item.dalam_proses) : 0 %}
  51.                                                            
  53.                                                                 <tr>
  54.                                                                     {% if loop_index == 0 %}
  55.                                                                         <td rowspan="{{ rowspan + 1 }}" style="vertical-align:middle; text-align:center" bgcolor="#F0F2BD"><strong>{{ sumber_dana|upper }}</strong></td>
  56.                                                                     {% endif %}
  57.                                                                     <td>{{ item[group] }}</td>
  58.                                                                     <td style="text-align:center">
  59.                                                                         {% if template == 'comparasi' %}
  60.                                                                         {{ item.dalam_proses + item.selesai }}
  61.                                                                         {% else %}
  62.                                                                         <a data-toggle="modal" data-target="#modal" href="{{ path(page_name ~ '_detail',{group:group,nama:item[group],tahap:'tahap_pemilihan_penyedia',sumber_dana:sumber_dana,tanggal_awal:tanggal_awal,tanggal_akhir:tanggal_akhir,tipe_tahun:tipe_tahun,tahun}) }}" ><span class="badge rounded-pill bg-grd-info text-dark">{{ item.dalam_proses + item.selesai }}</span></a>
  63.                                                                         {% endif %}
  64.                                                                     </td>
  65.                                                                     <td style="text-align:center">
  66.                                                                         {% if template == 'comparasi' %}
  67.                                                                         {{ item.selesai }}
  68.                                                                         {% else %}
  69.                                                                         <a data-toggle="modal" data-target="#modal" href="{{ path(page_name ~ '_detail',{group:group,nama:item[group],tahap:'selesai',sumber_dana:sumber_dana,tanggal_awal:tanggal_awal,tanggal_akhir:tanggal_akhir,tipe_tahun:tipe_tahun,tahun}) }}" ><span class="badge rounded-pill bg-grd-info text-dark">{{ item.selesai }}</span></a> 
  70.                                                                         {% endif %}
  71.                                                                     </td>
  72.                                                                     <td style="text-align:center">{{ persen|number_format(2, '.', ',') }}%</td>
  73.                                                                     <td style="text-align:center">
  74.                                                                         {% if template == 'comparasi' %}
  75.                                                                         {{ item.dalam_proses }}
  76.                                                                         {% else %}
  77.                                                                         <a data-toggle="modal" data-target="#modal" href="{{ path(page_name ~ '_detail',{group:group,nama:item[group],tahap:'dalam_proses',sumber_dana:sumber_dana,tanggal_awal:tanggal_awal,tanggal_akhir:tanggal_akhir,tipe_tahun:tipe_tahun,tahun}) }}" ><span class="badge rounded-pill bg-grd-info text-dark">{{ item.dalam_proses }}</span></a>
  78.                                                                         {% endif %}
  79.                                                                      </td>
  80.                                                                     <td style="text-align:center">{{rata_countdays_per_item|number_format(1, '.', ',') }}</td>
  81.                                                                 </tr>
  82.                                                                 {% set total_pemilihan_penyedia = total_pemilihan_penyedia + (item.dalam_proses + item.selesai ) %}
  83.                                                                 {% set total_selesai = total_selesai + item.selesai %}
  84.                                                                 {% set total_persen_selesai = persen != 0 ? (total_selesai / total_pemilihan_penyedia * 100) : 0 %}
  85.                                                                 {% set total_proses = total_proses + item.dalam_proses %}
  86.                                                                 {% set total_countdays = total_countdays + item.total_hari_kerja %}
  87.                                                                 {# {% set total_rata_countdays =   total_proses != 0 ? (total_countdays / total_proses)|number_format(1, '.', ',') : 0 %} #}
  88.                                                                
  89.                                                                 {% set total_rata_countdays = total_rata_countdays + rata_countdays_per_item %}
  90.                                                                 {% set loop_index = loop_index + 1 %}
  91.                                                                 {% set jumlah_item = jumlah_item + 1 %}
  92.                                                             {% endfor %}
  93.                                                             <tr bgcolor="#44444E">
  94.                                                                 <td><strong>Total {{ sumber_dana|upper }}.SGN</strong></td>
  95.                                                                 <td style="text-align:center"><strong>{{ total_pemilihan_penyedia }}</strong></td>
  96.                                                                 <td style="text-align:center"><strong>{{ total_selesai }}</strong></td>
  97.                                                                 <td style="text-align:center"><strong>{{ total_persen_selesai|number_format(2, '.', ',') }}%</strong></td>
  98.                                                                 <td style="text-align:center"><strong>{{ total_proses }}</strong></td>
  99.                                                                 <td style="text-align:center"><strong>{{ (total_rata_countdays / jumlah_item)|number_format(1, '.', ',') }}</strong></td>
  100.                                                             </tr>
  101.                                                             {% set jumlah_sumber = jumlah_sumber + 1 %}
  102.                                                             {% set grand_total_pemilihan_penyedia = grand_total_pemilihan_penyedia + total_pemilihan_penyedia %}
  103.                                                             {% set grand_total_selesai = grand_total_selesai + total_selesai %}
  104.                                                             {% set grand_total_persen_selesai = grand_total_selesai != 0 ? (grand_total_selesai / grand_total_pemilihan_penyedia * 100) : 0 %}
  105.                                                             {% set grand_total_proses = grand_total_proses + total_proses %}
  106.                                                             {% set grand_total_rata_countdays = grand_total_rata_countdays + (total_rata_countdays / jumlah_item) %}
  107.                                                         {% endfor %}
  109.                                                         {# TOTAL SEMUA #}
  110.                                                     
  111.                                                         
  112.                                                         <tr bgcolor="#37353E">
  113.                                                             <td colspan="2" align="center"><strong>TOTAL SGN</strong></td>
  114.                                                             <td style="text-align:center"><strong>{{ grand_total_pemilihan_penyedia }}</strong></td>
  115.                                                             <td style="text-align:center"><strong>{{ grand_total_selesai }}</strong></td>
  116.                                                             <td style="text-align:center"><strong>{{ grand_total_persen_selesai|number_format(2, '.', ',') }}%</strong></td>
  117.                                                             <td style="text-align:center"><strong>{{ grand_total_proses }}</strong></td>
  118.                                                             <td style="text-align:center"><strong>{{ (jumlah_sumber) > 0 ? (grand_total_rata_countdays / jumlah_sumber)|number_format(1, '.', ',') : 0 }}</strong></td>
  119.                                                         </tr>
  120.                                                     </tbody>
  121.                                                 </table>
  122.                                             </div>
  123.                                         </div>
  124.                                     </div>