public function paypalpost()
{
/*
$package_data = $db->getRows('SELECT * FROM packages WHERE id IN ('.implode(",",$array_pack_id).')');
print_r($package_data);
foreach ($package_data as $package_data) {
$query = "INSERT INTO orders (user_id,order_id,order_data,order_total) VALUES ('".$_SESSION['agent']['user_id']."','".$_POST['txn_id']."','".$package_data['title']."','".$package_data['price']."')";
mysql_query($query);
}
*/
/*
$name= Input::get("name");
$sql="INSERT INTO test (name) VALUES ('".$name."')";
$status= DB::INSERT(DB::raw($sql));
if ($status=1)
return "Records insterted successfully". $status;
else
return "problem inserting records in DB";
*/
$agent_id = Input::get('agent_id');
$package_id = Input::get('package_id');
$txn_id = Input::get("txn_id");
$purchasedPacks = null;
$values = explode(',', $package_id);
$packages = packages::whereIn('id', $values)->get();
foreach ($packages as $pack) {
$purchasedPacks = $purchasedPacks . $pack['package'] . "<BR>";
}
return 'Agent_id is ' . $agent_id . ' Packages Bought are <BR>' . $purchasedPacks . ' based on Transaction_id ' . $txn_id;
//AFTER RETREIVING VALUES NOW YOU NEED SEARCH CORRECT PACKAGE TITLE AND PRICE AND INSERT INTO ORDERS TABLE WITH
//CORRECT TXN_IDS AND AGENT_ID
//User will pass $array_pack_id, $_SESSION['agent']['user_id'],$_POST['txn_id'],$package_data['title'],$package_data['price']
}
