public function show($id)
{
$user = Session::get('user');
$plan = DB::table('PLAN_DTL_VW')->where('PLAN_CODE', $id)->get();
$bundle = DB::table('BUNDLE_DTL_VW')->where('BUNDLE_ID', $plan[0]->bundle_id)->get();
$plans = DB::table('PLAN_DTL_VW')->where('BUNDLE_ID', $bundle[0]->bundle_id)->get();
$i = 1;
foreach ($plans as $plan) {
$soapClient = new SoapClient("http://116.90.227.165/wsnlivebkp/Service/Service.asmx?WSDL");
$sh_param = array('User_id' => 'MQSUPPORT', 'Password' => 'MQSUPPORT', 'ExternalPartyName' => 'MQS');
$headers = new SoapHeader('http://tempuri.org/', 'MQUserNameToken', $sh_param, false);
$soapClient->__setSoapHeaders(array($headers));
$requestXML = '<REQUESTINFO>
<PLANINFO>
<CUSTOMERNBR></CUSTOMERNBR>
<PLANCODE>' . $plan->plan_code . '</PLANCODE>
<EFFECTIVEDATE></EFFECTIVEDATE>
<REGIONCODE></REGIONCODE>
<CURRENCYCODE></CURRENCYCODE>
<CUSTOMERTYPECODE></CUSTOMERTYPECODE>
<BILLFREQCODE></BILLFREQCODE>
<PRODUCTINFO>
<PRODUCTCODE></PRODUCTCODE>
<PRODUCTTYPE></PRODUCTTYPE>
<CHOICENBR></CHOICENBR>
<CHARGEINFO>
<CHARGECOMPONENT></CHARGECOMPONENT>
</CHARGEINFO>
</PRODUCTINFO>
</PLANINFO>
</REQUESTINFO>';
$referenceNo = time() . $i;
//reference number should be unique
$result = $soapClient->GetPlanPrice(array('GetPlanPriceXML' => $requestXML, 'ReferenceNo' => $referenceNo));
$xml_data = $result->GetPlanPriceResult;
$xml = simplexml_load_string($xml_data);
$json = json_encode($xml);
$data_array = json_decode($json);
//echo '<pre>';
//print_r($data_array);
//echo '</pre>';
$i++;
}
//echo '<pre>';
//print_r($plans);
//echo '</pre>';
return View::make('topups.show', compact('plans'));
}
