mysql_query($sql); }else{ $sales = 1;$commision = 20;$unpaid = 20; $sql = "INSERT INTO affsale SET sales=". $sales .",commission=". $commision .",unpaid=". $unpaid .", affId = ".$affid; mysql_query($sql); } header("Location: app/signup.html?cust_id=$cust_id&subs_id=$subs_id"); //header("Location: http://tabluu.applicationcraft.com/app#/app?cust_id=$cust_id&subs_id=$subs_id"); } $db->db_disconnect(); }else{ */ if (isset($_REQUEST['cust_id']) && isset($_REQUEST['subs_id']) && isset($_REQUEST['ref'])) { $db->db_connect(); $cust_id = $_REQUEST['cust_id']; $url = '/customers/' . $cust_id . '/subscriptions.xml'; $result = $connector->sendRequest($url, $format = 'xml', $method = 'GET', $data = ''); if ($result->code == 200) { $objxml = simplexml_load_string($result->response); $state = $objxml->subscription->state; $expiry = $objxml->subscription->current_period_ends_at; $subs_id = $_REQUEST['subs_id']; $fname = $objxml->subscription->customer->first_name; $lname = $objxml->subscription->customer->last_name; $email = $objxml->subscription->customer->email; $productId = $objxml->subscription->product->id; $cust_id = $_REQUEST['cust_id']; $date = date('Y-m-d h:i:s'); $gId = $_REQUEST['ref']; $_SESSION['newcreated'] = time(); mysql_query("UPDATE businessUserGroup SET chargify_cust_id ={$cust_id}, subscription_id ={$subs_id} , email='{$email}',state='{$state}',addLoc=0,productId={$productId},expiration='{$expiry}' WHERE gId={$gId}"); $result = mysql_query("SELECT id FROM businessUsers WHERE userGroupId={$gId} AND permission = 0") or die(mysql_error());
$data = array(); switch ($opt) { case 'vanitylink': $placeId = $_REQUEST['placeId']; $result = mysql_query("SELECT link FROM businessvanitylink WHERE placeId = {$placeId}"); //check if source is existed if (mysql_num_rows($result)) { // existed update it $row = mysql_fetch_object($result); echo $row->link; } break; case 'getTransaction': $subscription_id = $_REQUEST['subsId']; $url = '/subscriptions/' . $subscription_id . '/transactions.xml?per_page=30'; $result = $connector->sendRequest($url, $format = 'json', $method = 'GET', $data = ''); $array = array(); if ($result->code == 200) { $objxml = simplexml_load_string($result->response); for ($i = 0; $i < count($objxml->transaction); $i++) { $array[$i]['id'] = (int) $objxml->transaction[$i]->id; $date = new DateTime((string) $objxml->transaction[$i]->created_at); $array[$i]['created'] = $date->format('m/d/Y h:i:s A'); $array[$i]['type'] = (string) $objxml->transaction[$i]->type; $array[$i]['memo'] = (string) $objxml->transaction[$i]->memo; $array[$i]['amount'] = (int) $objxml->transaction[$i]->amount_in_cents / 100; $array[$i]['balance'] = (int) $objxml->transaction[$i]->ending_balance_in_cents / 100; } $array = array_merge(array('response' => $array, 'code' => $result->code)); } else { $array = array('response' => $result->response, 'code' => $result->code);