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