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')); }