<?php
use App\Jobs\KHRMSLib;
use App\Models\CRMCall;

$wakka=new KHRMSLib();
$roclientlst=$wakka->clientsReadAccess();
if(isset($_GET['pbcode']))$pbcode=$_GET['pbcode'];
else $pbcode='';

$alist=DB::table('p11086_cop_rlp_pb_base_uat')
    ->select(DB::Raw("*"))
    ->where('pbcode','=',$pbcode)
    ->get();
//print_r($alist);    

?>
<style>#logtable.td{vertical-align:top;}#logtable.tr{height:28px;overflow-y:hidden;}</style>

<div class="layout-app"><!-- row-app -->
	<div class="row row-app">

		<div class="col-md-12">

			<div class="col-separator col-separator-first col-unscrollable box">
				<div style='clear:both;margin:1% 0 0 1%;border: 0px solid #F5F5F5;padding:2%;border-radius: 5px;'>
					<center><h4>RLP PB WISE</center>

					<br> 
					<div class='container'>

						PB CODE:&nbsp;&nbsp;&nbsp;&nbsp;<select id='pb_code' class=select2multi   style="width:20%;" onclick="pbcodeSelect();">
							<?php foreach($roclientlst as $c){$s="";if($c==$pbcode)$s='selected';echo "<option value='$c' $s>$c</option>";} ?>
						</select>
					</div>
				</div>
			</div>	
			<div style='overflow:auto;margin-top: 10px;margin-left: 10px;margin-right:10px;'>
				<table id='logtable' class='footable table table-striped table-bordered table-white table-primary footable-loaded' style='font-size:12px';margin:0; border:2px solid #BBB;>
					<thead> 
					 	<tr>
                			<th style='width:20%';>Product</th>
                			<th style='width:20%';>Opportunity</th>    
                			<th style='width:20%';>Contacted</th>
                			<th style='width:20%';>Pitched</th>
                			<th style='width:20%';>LG</th>
                		</tr>
                	</thead>
					<tr>
					  <td>AL</td> 
					  <td><?php echo $alist[0]->al_opp ?></td> 
					  <td><?php echo $alist[0]->al_called_opp ?></td> 
					  <td><?php echo $alist[0]->al_pitch ?></td> 
					  <td><?php echo $alist[0]->al_lg ?></td>
					</tr>
					<tr>
					  <td>PL/BL</td> 
					  <td><?php echo $alist[0]->pl_opp ?></td> 
					  <td><?php echo $alist[0]->pl_called_opp ?></td> 
					  <td><?php echo $alist[0]->pl_pitch ?></td> 
					  <td><?php echo $alist[0]->pl_lg ?></td>
					</tr>
					<tr>
					  <td>TWL</td> 
					  <td><?php echo $alist[0]->twl_pa_opp ?></td> 
					  <td><?php echo $alist[0]->twl_called_opp ?></td> 
					  <td><?php echo $alist[0]->twl_pitch ?></td> 
					  <td><?php echo $alist[0]->twl_lg ?></td>
					</tr>
					<tr>
					  <td>HL</td> 
					  <td><?php echo $alist[0]->hl_opp ?></td> 
					  <td><?php echo $alist[0]->hl_called_opp ?> </td> 
					  <td><?php echo $alist[0]->hl_pitch ?> </td> 
					  <td><?php echo $alist[0]->hl_lg ?> </td>
					</tr>
					<tr>
					  <td>GL</td> 
					  <td></td> 
					  <td></td> 
					  <td><?php echo $alist[0]->gl_pitch ?> </td> 
					  <td><?php echo $alist[0]->gl_lg ?> </td>
					</tr>
					<tr>
					  <td>LAS</td> 
					  <td><?php echo $alist[0]->las_opp ?></td> 
					  <td><?php echo $alist[0]->las_called_opp ?> </td> 
					  <td><?php echo $alist[0]->las_pitch ?> </td> 
					  <td><?php echo $alist[0]->las_lg ?> </td>
					</tr>
					<tr>
					  <td>LAP</td> 
					  <td><?php echo $alist[0]->lap_opp ?></td> 
					  <td><?php echo $alist[0]->lap_called_opp ?> </td> 
					  <td><?php echo $alist[0]->lap_pitch ?> </td> 
					  <td><?php echo $alist[0]->lap_lg ?> </td>
					</tr>
					<tr>
					  <td>HSL(Unpenetrated)</td> 
					  <td><?php echo $alist[0]->hsl_opp ?></td> 
					  <td><?php echo $alist[0]->hsl_called_opp ?></td> 
					  <td><?php echo $alist[0]->hsl_pitch ?></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Credit Card- New Sourcing</td> 
					  <td><?php echo $alist[0]->cc_eli_new_opp ?></td> 
					  <td><?php echo $alist[0]->cc_called_opp ?></td> 
					  <td><?php echo $alist[0]->cc_pitch ?></td> 
					  <td><?php echo $alist[0]->cc_lg ?></td>
					</tr>
					<tr>
					  <td>Credit Card- LTD Activation on Carded</td> 
					  <td><?php echo $alist[0]->cc_activation_opp ?></td> 
					  <td><?php echo $alist[0]->cc_activation_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Insurance LI</td> 
					  <td><?php echo $alist[0]->li_opp ?></td> 
					  <td><?php echo $alist[0]->li_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>FD</td> 
					  <td><?php echo $alist[0]->fd_opp ?></td> 
					  <td><?php echo $alist[0]->fd_called_opp ?></td> 
					  <td><?php echo $alist[0]->fd_pitch ?></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>LTD Activation-Savings Account</td> 
					  <td><?php echo $alist[0]->ltd_act_saving_opp ?></td> 
					  <td><?php echo $alist[0]->ltd_act_saving_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>NB/MB Activations</td> 
					  <td><?php echo $alist[0]->nb_mb_opp ?></td> 
					  <td><?php echo $alist[0]->nb_mb_called_opp ?></td> 
					  <td><?php echo $alist[0]->nb_mb_pitch ?></td> 
					  <td><?php echo $alist[0]->nb_mb_lg ?></td>
					</tr>
					<tr>
					  <td>Aadhar Seeding</td> 
					  <td><?php echo $alist[0]->aadhaar_opp ?></td>
					   <td><?php echo $alist[0]->aadhaar_called_opp ?></td> 
					   <td><?php echo $alist[0]->aadhaar_pitch ?></td> 
					   <td><?php echo $alist[0]->aadhaar_activation ?></td>
					</tr>
					<tr>
					  <td>Digital Activation</td> 
					  <td><?php echo $alist[0]->digi2_score_opp ?></td>
					  <td><?php echo $alist[0]->digi2_score_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>BillPayments</td> 
					  <td><?php echo $alist[0]->digi_billpay_opp ?></td> 
					  <td><?php echo $alist[0]->digi_billpay_called_opp ?></td> 
					  <td><?php echo $alist[0]->bill_pay_pitch ?></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Financial Transactions(Basic Banking)</td> 
					  <td><?php echo $alist[0]->digi_basic_banking_opp ?></td> 
					  <td><?php echo $alist[0]->digi_basic_banking_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Digital 2.0 Score(Ecom Shopping Inactive)</td> 
					  <td><?php echo $alist[0]->digi_ecom_shopping_opp  ?></td> 
					  <td><?php echo $alist[0]->digi_ecom_shopping_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Digital 2.0 Score(Investment Inactive)</td> 
					  <td><?php echo $alist[0]->digi_investment_opp ?></td> 
					  <td><?php echo $alist[0]->digi_investment_called_opp ?></td> 
					  <td><?php echo $alist[0]->invest_pitch ?></td> 
					  <td></td>
					</tr>
					<tr>
					  <td>Reduction in Physical Transactions</td> 
					  <td><?php echo $alist[0]->digi_physical_opp ?></td> 
					  <td><?php echo $alist[0]->digi_physical_called_opp ?></td> 
					  <td></td> 
					  <td></td>
					</tr>
				</table>
			</div>
			<div id=dialoglog></div>
		</div>
	</div>
</div>
<style>#logtable.td{vertical-align:top;}#logtable.tr{height:28px;overflow-y:hidden;}</style>	
<script>
$(document).ready(function()
{
    if(!$('#dialoglog').hasClass('ui-dialog-content'))
    {
  $('#dialoglog').dialog({
    autoOpen: false,
    width: '70%',
    buttons: {
      "Ok": function() { 
  $(this).dialog("close"); 
      }, 
      "Cancel": function() { 
  $(this).dialog("close"); 
      } 
    }
  });
    }

  waitKeyUpRun("filter",function() { filter2(document.getElementById('filter'), 'logtable') },"2000");
  
});
function pbcodeSelect()
{
	var pbcode=$('#pb_code').val();
	doAjax('rlp?pbcode='+pbcode,'','content','ajax_rlp','singlethis','GET');
}
</script>