<nav class="large-3 medium-4 columns" id="actions-sidebar">
      <?= $this->element('admin_sidebar') ?>
</nav>
<div class="ipos index large-9 medium-8 columns content">
    <h3><?= __('Reports IPO') ?></h3>
    <div class="search-wrapper">  
        <div class="btn-link">
        <?= $this->Html->link(__('Excel Export'), [
           'controller' => 'Reports', 'action' => 'iporeports',
           '?' =>['applicationno'=> $applicationno,
            'fapplicantname'=> $fapplicantname,
            'panno' => $panno,   
            'datedform'=> $datedform,
            'datedto'=> $datedto,
            'banks'=> $banks,
            'customerid'=>$customerid]],['class'=>'green-btn']); ?></div> 
             <fieldset class="fieldset2"> 
      <div class="search-filter"><?= $this->Search->filterForm($searchFilters) ?></div>       
            </fieldset> 
  
    <table class="tbl-wrapper" cellpadding="0" cellspacing="0">
        <thead>
            <tr>
                <th style="width:40px;" scope="col"><?= $this->Paginator->sort('id') ?></th> 
                 <th scope="col"><?= $this->Paginator->sort('Application No') ?></th> 
                <!-- <th scope="col"><?= $this->Paginator->sort('company_id') ?></th>
                <th scope="col"><?= $this->Paginator->sort('branch_id') ?></th>
                <th scope="col"><?= $this->Paginator->sort('user_id') ?></th> -->
                <th scope="col"><?= $this->Paginator->sort('Bidder Name') ?></th>
               <!--  <th scope="col"><?= $this->Paginator->sort('bidderaddress') ?></th>
                <th scope="col"><?= $this->Paginator->sort('bidderemail') ?></th>
                <th scope="col"><?= $this->Paginator->sort('biddertelephoneno') ?></th>
                <th scope="col"><?= $this->Paginator->sort('bidderpanno') ?></th> -->
               <!--  <th scope="col"><?= $this->Paginator->sort('depositoryaccount') ?></th>
                <th scope="col"><?= $this->Paginator->sort('depositoryaccountno') ?></th> -->
                <!-- <th scope="col"><?= $this->Paginator->sort('bidoption1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1noofequityshare') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1noofequitysharebid') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1bidprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1bidprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1bidprice3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1discountprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1discountprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt1discountprice3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('bidorioption2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2noofequityshare') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2noofequitysharebid') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2bidprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2bidprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2bidprice3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2discountprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2discountprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt2discountprice3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('bidorioption3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3noofequityshare') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3noofequitysharebid') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3bidprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3bidprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3bidprice3') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3discountprice1') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3discountprice2') ?></th>
                <th scope="col"><?= $this->Paginator->sort('opt3discountprice3') ?></th> -->
                <th scope="col"><?= $this->Paginator->sort('Payment Option') ?></th>
                <th scope="col"><?= $this->Paginator->sort('Amount') ?></th>
               <!--  <th scope="col"><?= $this->Paginator->sort('asbabankaccountno') ?></th> -->
                <th scope="col"><?= $this->Paginator->sort('Bank Name') ?></th>
                <th scope="col"><?= $this->Paginator->sort('Bank Branch') ?></th>
               
            </tr>
        </thead>
        <tbody>
            <?php foreach ($ipos as $ipo): ?>
            <tr>
              <td style="width:40px;"><?= $this->Number->format($ipo->id) ?></td> 
                 <td><?= h($ipo->applicationno) ?></td>
               <!--  <td><?= $ipo->has('company') ? $this->Html->link($ipo->company->company, ['controller' => 'Companies', 'action' => 'view', $ipo->company->id]) : '' ?></td> 
                <td><?= $ipo->has('branch') ? $this->Html->link($ipo->branch->branchname, ['controller' => 'Branches', 'action' => 'view', $ipo->branch->id]) : '' ?></td>
                <td><?= $ipo->has('user') ? $this->Html->link($ipo->user->id, ['controller' => 'Users', 'action' => 'view', $ipo->user->id]) : '' ?></td> -->
                <td><?= h($ipo->biddername) ?></td>
                <!-- <td><?= $this->Number->format($ipo->bidderaddress) ?></td>
                <td><?= $this->Number->format($ipo->bidderemail) ?></td>
                <td><?= $this->Number->format($ipo->biddertelephoneno) ?></td>
                <td><?= $this->Number->format($ipo->panno) ?></td> -->
               <!--  <td><?= h($ipo->depositoryaccount) ?></td>
                <td><?= h($ipo->depositoryaccountno) ?></td> -->
               <!--  <td><?= $this->Number->format($ipo->bidoption1) ?></td>
                <td><?= $this->Number->format($ipo->opt1noofequityshare) ?></td>
                <td><?= $this->Number->format($ipo->opt1noofequitysharebid) ?></td>
                <td><?= $this->Number->format($ipo->opt1bidprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt1bidprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt1bidprice3) ?></td>
                <td><?= $this->Number->format($ipo->opt1discountprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt1discountprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt1discountprice3) ?></td>
                <td><?= $this->Number->format($ipo->bidorioption2) ?></td>
                <td><?= $this->Number->format($ipo->opt2noofequityshare) ?></td>
                <td><?= $this->Number->format($ipo->opt2noofequitysharebid) ?></td>
                <td><?= $this->Number->format($ipo->opt2bidprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt2bidprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt2bidprice3) ?></td>
                <td><?= $this->Number->format($ipo->opt2discountprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt2discountprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt2discountprice3) ?></td>
                <td><?= $this->Number->format($ipo->bidorioption3) ?></td>
                <td><?= $this->Number->format($ipo->opt3noofequityshare) ?></td>
                <td><?= $this->Number->format($ipo->opt3noofequitysharebid) ?></td>
                <td><?= $this->Number->format($ipo->opt3bidprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt3bidprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt3bidprice3) ?></td>
                <td><?= $this->Number->format($ipo->opt3discountprice1) ?></td>
                <td><?= $this->Number->format($ipo->opt3discountprice2) ?></td>
                <td><?= $this->Number->format($ipo->opt3discountprice3) ?></td> -->
                <td><?= h($ipo->paymentoption) ?></td>
                <td><?= $this->Number->format($ipo->amount) ?></td>
                <!-- <td><?= $this->Number->format($ipo->asbabankaccountno) ?></td> -->
                <td><?= $ipo->has('bank') ? $this->Html->link($ipo->bank->banks, ['controller' => 'Banks', 'action' => 'view', $ipo->bank->id]) : '' ?></td>
                <td><?= $ipo->has('bankbranch') ? $this->Html->link($ipo->bankbranch->branchaddress, ['controller' => 'Bankbranchs', 'action' => 'view', $ipo->bankbranch->id]) : '' ?></td>
               
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
    <div class="paginator">
        <ul class="pagination">
           <?= $this->Paginator->first(__('First', true), array('class' => 'disabled')); ?>
            <?= $this->Paginator->prev('< ' . __('previous',true), array('class' => 'disabled')) ?>
            <?= $this->Paginator->numbers() ?>
            <?= $this->Paginator->next(__('next' . ' >',true), array('class' => 'disabled')) ?>
		 <?=  $this->Paginator->last(__('Last', true), array('class' => 'disabled')); ?>
        </ul>
        <p><?= $this->Paginator->counter() ?></p>
    </div>
</div>
