function UseCase1($google_id, $google_key, $sandbox, $orderid = '', $shipping_check, $digital_check)
{
global $tableprefix, $_SESSION;
$gift_coupon_flag = 0;
$google_id = $google_id;
// Merchant ID
$google_key = $google_key;
// Merchant Key
$google_demo = $sandbox;
// "YES" if in test mode, "NO" if in live mode
$shipping_cost = number_format($_SESSION['SESS_upscost'], 2, ".", "");
$totaltaxrate = number_format($_SESSION['session_taxrate'], 2, ".", "");
$referrer = $_SERVER["HTTP_REFERER"];
if (isset($_SESSION["sess_guest_username"]) && $_SESSION["sess_guest_username"] != '') {
$usertype = 'guest';
} else {
$usertype = 'user';
}
if (!isset($_SESSION['SESS_google_checkout'])) {
$totaltopay = number_format(getCartTotal($_SESSION["sess_userid"]), 2, ".", "");
$hide_shipping_division = hideShipping();
/*-------function call to check whether cart contains digital or gift coupon products so as to hide shipping------*/
$check_shipping_enable = checkShippingEnable();
if ($check_shipping_enable == "Y" && $hide_shipping_division == 1) {
$shipping_cost = $_SESSION['SHIPPING_TOTAL'];
$totaltopay = number_format($totaltopay, 2, ".", "");
$totaltopay = $totaltopay + $shipping_cost;
}
$amountpaid = number_format($_SESSION['amount_paid'], 2, ".", "");
$sql = "INSERT INTO " . $tableprefix . "orders (\n\t\t\t\tuser_id,\n\t\t\t\tbilling_first_name,\n\t\t\t\tbilling_last_name,\n\t\t\t\tbilling_address1,\n\t\t\t\tbilling_address2,\n\t\t\t\tbilling_city,\n\t\t\t\tbilling_state,\n\t\t\t\tbilling_country,\n\t\t\t\tbilling_zip,\n\t\t\t\tbilling_fax,\n\t\t\t\tbilling_email,\n\t\t\t\tbilling_phone,\n\t\t\t\tshipping_first_name,\n\t\t\t\tshipping_last_name,\n\t\t\t\tshipping_address1,\n\t\t\t\tshipping_address2,\n\t\t\t\tshipping_city,\n\t\t\t\tshipping_state,\n\t\t\t\tshipping_country,\n\t\t\t\tshipping_zip,\n\t\t\t\tshipping_fax,\n\t\t\t\tshipping_email,\n\t\t\t\tshipping_phone,\n\t\t\t\tprefered_shippin_method,\n\t\t\t\torder_date,\n\t\t\t\torder_total_price,\n\t\t\t\ttaxrate,\n\t\t\t\torder_status,\n\t\t\t\ttransaction_id,\n\t\t\t\tvorder_currency" . $nameCouponCode . ",\n\t\t\t\tnamount_paid,\n buyer_comments,\n vpayment_status\n\t\t\t\t) VALUES(\n\t\t\t\t'" . addslashes($_SESSION["sess_userid"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingFirstName"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingLastName"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingAddress1"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingAddress2"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingCity"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingState"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingCountry"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingZIP"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingFAX"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingEmail"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessBillingPhone"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingFirstName"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingLastName"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingAddress1"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingAddress2"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingCity"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingState"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingCountry"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingZIP"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingFAX"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingEmail"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingPhone"]) . "',\n\t\t\t\t'" . addslashes($_SESSION["sessShippingDisplayName"]) . "',\n\t\t\t\tnow(),\n\t\t\t\t'" . addslashes($totaltopay) . "',\n\t\t\t\t'" . addslashes($totaltaxrate) . "',\n\t\t\t\t'1',\n\t\t\t\t'" . addslashes($tx_token) . "',\n\t\t\t\t'" . $currency_attributes[2] . "'" . $valueCouponCode . ",\n\t\t\t\t'" . addslashes($amountpaid) . "',\n '" . addslashes($_SESSION["SESS_BUYER_COMMENTS"]) . "',\n 'P'\n\t\t\t\t)";
mysql_query($sql);
$orderid = mysql_insert_id();
// Updating Buying Process using Gift Certificate Code
if ($_SESSION['sess_giftcertificate_code'] != '' && $_SESSION['sess_gift_amount_used'] != '') {
$sql_up = "UPDATE " . $tableprefix . "orders SET vgiftcertificate_code='" . addslashes($_SESSION['sess_giftcertificate_code']) . "',\n\t\t\t\t\t\tnused_gift_amount=(nused_gift_amount + " . $_SESSION['sess_gift_amount_used'] . " )WHERE order_id='" . $orderid . "' ";
$rs_up = mysql_query($sql_up) or die(mysql_error());
$sql_gift = "UPDATE " . $tableprefix . "giftcertificates SET nused_gift_amount=(nused_gift_amount + " . $_SESSION['sess_gift_amount_used'] . " )\n\t\t\t\t\t\t\tWHERE vgift_coupon_code ='" . addslashes($_SESSION['sess_giftcertificate_code']) . "' ";
$rs_gift = mysql_query($sql_gift) or die(mysql_error());
}
// End Gift Certificate Updation
// Store Coupon Code Details to Order Table // Modified By Asha ON 21-02-2011
if ($_SESSION['couponCode_det'] != '') {
// Update Order with Coupon Code Discount
$sql_coupon_update = "UPDATE " . $tableprefix . "orders SET couponCodeDiscount ='" . $_SESSION['couponCode_det']['ccDiscount'] . "', couponCode ='" . $_SESSION['couponCode_det']['ccCode'] . "' where order_id='" . $orderid . "' ";
$rs_update_c = mysql_query($sql_coupon_update) or die(mysql_error());
// End Update
}
// End Coupon Code Modification
$check_shipping_enable = checkShippingEnable();
if ($check_shipping_enable == "Y" && $hide_shipping_division == 1) {
/*---------------inserting the shipping details----------------*/
$select_cart_products = "SELECT c.product_option_id,c.product_id,p.product_name,po.product_shipping_weight FROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n WHERE c.user_id = " . $_SESSION["sess_userid"];
$result_cart_products = mysql_query($select_cart_products) or die(mysql_error());
if (mysql_num_rows($result_cart_products) > 0) {
while ($cart_obj = mysql_fetch_object($result_cart_products)) {
if (isset($_SESSION["SHIPPING_DETAILS"][$cart_obj->product_option_id]['preffered_shipping'])) {
$product_name = $cart_obj->product_name;
$optionVal = getProductOptionsName($cart_obj->product_option_id);
$shipping_name = $_SESSION["SHIPPING_DETAILS"][$cart_obj->product_option_id]['preffered_shipping'];
$shipping_cost = $_SESSION["SHIPPING_DETAILS"][$cart_obj->product_option_id]['rate'];
$product_shipping_weight = $cart_obj->product_shipping_weight;
$ship_product_option_id = $cart_obj->product_option_id;
$product_name .= $optionVal;
$insert_shipping = "INSERT INTO " . $tableprefix . "shipping_details\n (\n norder_id,\n vshipping_currency,\n dshipped_date,\n nshp_status,\n user_id,\n nshp_productid,\n nproduct_option_id,\n nshp_productname,\n vshipping_name,\n nshipping_cost,\n nshipping_weight\n )\n VALUES\n (\n " . $orderid . ",\n '" . $currency_attributes[2] . "',\n now(),\n 'C',\n '" . addslashes($_SESSION["sess_userid"]) . "',\n " . $cart_obj->product_id . ",\n " . $ship_product_option_id . ",\n '" . addslashes($product_name) . "',\n '" . addslashes($shipping_name) . "',\n '" . $shipping_cost . "',\n '" . $product_shipping_weight . "'\n )\n ";
mysql_query($insert_shipping) or die(mysql_error());
}
}
// end while
}
// end if
}
// end of shipping if
/************************** Affilate payment block*********************************************/
$sql = "select * from " . $tableprefix . "users where user_id='" . addslashes($_SESSION["sess_userid"]) . "'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if ($row["affiliate_id"] != "" && $row["affiliate_id"] != "0" && $row["vaff_type"] != "paid") {
$aid = $row['affiliate_id'];
$userid = $row['user_id'];
$txtUserName = $row['user_name'];
$txtFirstName = $row['first_name'];
$txtEmail = $row['email'];
$txtorderdamount = $totaltopay;
$sql1 = "SELECT * FROM " . $tableprefix . "settings ";
$result1 = mysql_query($sql1);
if (mysql_num_rows($result1) != 0) {
$row1 = mysql_fetch_array($result1);
/*referral charge calculation based on the currency type*/
$txtReferralCharge = $row1["referral_charge"];
}
$var_aff_comm = $txtorderdamount * $txtReferralCharge / 100;
$sql2 = "INSERT INTO " . $tableprefix . "affiliate_registrations (\n\t\t\t\t\t\t\t\t\t\t\taffiliate_id,\n\t\t\t\t\t\t\t\t\t\t\tuser_id,\n\t\t\t\t\t\t\t\t\t\t\torder_id,\n\t\t\t\t\t\t\t\t\t\t\tuser_name ,\n\t\t\t\t\t\t\t\t\t\t\tuser_first_name,\n\t\t\t\t\t\t\t\t\t\t\tuser_last_name,\n\t\t\t\t\t\t\t\t\t\t\tuser_email,\n\t\t\t\t\t\t\t\t\t\t\treferral_charge,\n\t\t\t\t\t\t\t\t\t\t\tregistration_date,\n\t\t\t\t\t\t\t\t\t\t\tuser_totalpurchasedamount\n\t\t\t\t\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($aid) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($userid) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($orderid) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($txtUserName) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($txtFirstName) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($txtLastName) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($txtEmail) . "',\n\t\t\t\t\t\t\t\t\t\t\t'" . addslashes($var_aff_comm) . "',\n\t\t\t\t\t\t\t\t\t\t\tnow(),'{$totaltopay}'\n\t\t\t\t\t\t\t\t\t\t\t)";
mysql_query($sql2);
$sql3 = " update " . $tableprefix . "users set vaff_type='paid' where user_id='" . addslashes($_SESSION["sess_userid"]) . "'";
$result3 = mysql_query($sql3);
}
// end if Affiliate Registraion
/************************** Affilate payment block*********************************************/
//echo "sql==".$sql."<br><br>";
$product_download_details = "Product Download Details\r\n";
$product_download_details .= "-----------------------\r\n";
$product_download_flag = 0;
$download_link = "";
$sql = "SELECT c.*,(p.product_price+po.additional_price) AS product_price,p.product_name,p.product_code,p.product_artist_id,po.discount,\n\t\t\t\t\t\tp.vdigital_product,ar.commission\n\t\t\t\tFROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n INNER JOIN " . $tableprefix . "artists ar ON ar.artist_id = p.product_artist_id\n\t\t\t\tWHERE c.user_id = '" . addslashes($_SESSION["sess_userid"]) . "' ";
$res = mysql_query($sql);
$product_commission_amt = 0;
$gift_coupon_flag = 0;
$artists = array();
if (mysql_num_rows($res) != 0) {
$i = 0;
while ($row = mysql_fetch_array($res)) {
$productid = $row["product_id"];
$product_option_id = $row["product_option_id"];
$quantity = $row["quantity"];
/*product price is calculated based on currency type*/
$converted_price = $row["product_price"];
$productprice = number_format($converted_price, 2, ".", "");
//$productprice = $row["product_price"];
$productname = $row["product_name"];
$optionVal = getProductOptionsName($product_option_id);
$productname .= $optionVal;
$productcode = $row["product_code"];
$productdiscount = $row["discount"];
$artistid = $row["product_artist_id"];
/*========================================Gift Certificate Section=================================*/
$select_gift_code = "SELECT vgift_coupon_code,ngift_coupon_amount\n\t\t\t\t\t FROM " . $tableprefix . "giftcoupon_master\n\t\t\t\t\t WHERE ngift_product_id = " . $productid;
$result_gift_code = mysql_query($select_gift_code) or die(mysql_error());
if (mysql_num_rows($result_gift_code) > 0) {
// start of first if
$gift_coupon_product_id = $productid;
while ($gift_code_row = mysql_fetch_array($result_gift_code)) {
// start of while 2
/*--------------------creating random gift coupon code and updating the database-----------------------*/
$gift_coupon_code = "GC" . randomGiftCouponKey();
$giftamount = $productprice * $quantity;
$insert_coupon_code = "INSERT INTO " . $tableprefix . "giftcertificates(vgift_coupon_code,ngift_product_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tngift_order_id,ngift_coupon_amount,user_id,seller_id)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES('" . $gift_coupon_code . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $row["product_id"] . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $orderid . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $giftamount . ",'" . $userid . "','" . $artistid . "')";
mysql_query($insert_coupon_code) or die(mysql_error());
}
$gift_coupon_flag = 1;
}
// end of mysql number of rows check
//=======================End Gift Certificate Section ===================================
if ($row['vdigital_product'] == "Y") {
$digital_product_id = $row["product_id"];
$select_product_digital_code = "SELECT vdigital_product_name,vdigital_product_code,ndownload_try,ndownload_expiry,ndownload_expiry_days\n\t\t\t\t\t\t\t\t\t\tFROM " . $tableprefix . "digital_product\n\t\t\t\t\t\t\t\t\t\tWHERE ndigital_productid = " . $row["product_id"] . " AND ndigital_orderid =0 ";
$result_product_digital_code = mysql_query($select_product_digital_code);
if (mysql_num_rows($result_product_digital_code) > 0) {
while ($product_digital_code_row = mysql_fetch_array($result_product_digital_code)) {
/*--------------------creating random product download code and updating the database-----------------------*/
$digital_product_code = randomDigitalProduct();
$expiry_days = $product_digital_code_row['ndownload_expiry_days'];
$valid_date_upto = date("Y-m-d H:s:m", mktime(date("H"), date("i"), date("s"), date("m"), date("d") + $expiry_days, date("Y")));
/*-------Calculating the download expiry days----------*/
/*$update_product_digital_code = "UPDATE ".$tableprefix."digital_product
SET vdigital_product_code = '".$digital_product_code."',
ndigital_orderid = ".$orderid.",
ndownload_expiry = '".$valid_date_upto."'
WHERE ndigital_productid = ".$row["product_id"];
mysql_query($update_product_digital_code) or die(mysql_error());*/
/*---------selecting the download try and download expiry date-----------*/
$select_digital_product_details = "SELECT ndownload_try,ndownload_expiry\n\t\t\t\t\t\t\t\t\t\t\t\t\t \t\t\t\t FROM " . $tableprefix . "digital_product WHERE ndigital_productid = " . $productid;
$result_digital_product_details = mysql_query($select_digital_product_details) or die(mysql_error());
$digital_product_details_row = mysql_fetch_assoc($result_digital_product_details);
$product_download_try = $digital_product_details_row["ndownload_try"];
$download_expiry_date = $digital_product_details_row["ndownload_expiry"];
/*---------selecting the download try and download expiry date-----------*/
$select_digital_count = "SELECT ndigital_id FROM " . $tableprefix . "digital_product WHERE ndigital_orderid = " . $orderid;
$result_digital_count = mysql_query($select_digital_count) or die(mysql_error());
//echo "digital count = ".mysql_num_rows($result_digital_count)."\n";
//echo "order count = ".$row["quantity"];
for ($i = 1; $i <= $row["quantity"]; $i++) {
/*-------Calculating the download expiry days----------*/
$expiry_days = $product_digital_code_row['ndownload_expiry_days'];
$valid_date_upto = date("Y-m-d H:s:m", mktime(date("H"), date("i"), date("s"), date("m"), date("d") + $expiry_days, date("Y")));
/*-------Calculating the download expiry days----------*/
$digital_product_code = randomDigitalProduct();
$insert_product_digital_code = "INSERT INTO " . $tableprefix . "digital_product(vdigital_product_name,ndigital_productid,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tndigital_orderid,vdigital_product_code,ndownload_try,ndownload_count,ndownload_expiry,ndownload_expiry_days,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tndownload_status)VALUES('" . addslashes($product_digital_code_row['vdigital_product_name']) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $row["product_id"] . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $orderid . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $digital_product_code . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . $product_digital_code_row['ndownload_try'] . ",0,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'" . $valid_date_upto . "'," . addslashes($product_digital_code_row['ndownload_expiry_days']) . ",0)";
mysql_query($insert_product_digital_code) or die(mysql_error());
}
// end for loop
//exit;
}
// end ehile
}
// emd if number of rows check
$product_download_flag = 1;
}
// end digital product check
/*----------------------------------End check Digital Products--------------------------------------------------
/*----------------------------------Updating Gift Products----------------------------------------------------------*/
$product_tax = $_SESSION["TAX_DETAILS"][$product_option_id];
// Product Based Commission Calculation
$price_amt = $productprice * $quantity;
if ($row['discount'] != 0) {
$discountprice = $productprice - $productprice * $row["discount"] / 100;
$discountprice = number_format($discountprice, 2, ".", "");
$discount_amount = $discountprice * $quantity;
} else {
$discount_amount = $price_amt;
}
$product_commission_amt = $discount_amount * $row["commission"] / 100;
// Product Based Commission Calculation End
$sql = "INSERT INTO " . $tableprefix . "order_details (\n\t\t\t\torder_id,\n\t\t\t\tproduct_id,\n\t\t\t\tproduct_name,\n\t\t\t\tproduct_code,\n\t\t\t\tproduct_price,\n\t\t\t\tproduct_quantity,\n\t\t\t\tproduct_discount,\n\t\t\t\tartist_id,\n\t\t\t\titem_status,\n\t\t\t\tartist_payment_status,\n product_tax,\n product_option_id,\n product_commission_amount\n\t\t\t\t)VALUES(\n\t\t\t\t'" . addslashes($orderid) . "',\n\t\t\t\t'" . addslashes($productid) . "',\n\t\t\t\t'" . addslashes($productname) . "',\n\t\t\t\t'" . addslashes($productcode) . "',\n\t\t\t\t'" . addslashes($productprice) . "',\n\t\t\t\t'" . addslashes($quantity) . "',\n\t\t\t\t'" . addslashes($productdiscount) . "',\n\t\t\t\t'" . addslashes($artistid) . "',\n\t\t\t\t'1',\n\t\t\t\t'0',\n '" . $product_tax . "',\n '" . $product_option_id . "',\n '" . $product_commission_amt . "'\n\t\t\t\t)";
mysql_query($sql);
//echo "sql==".$sql."<br><br>";
$artists[$i] = $artistid;
$i++;
$sql = "";
if ($product_download_flag == 1) {
$update_order_details = "UPDATE " . $tableprefix . "order_details\n\t\t\t\t\t\tSET item_status = 4\n\t\t\t\t\t\tWHERE order_id = " . $orderid . " AND product_id = " . $digital_product_id;
mysql_query($update_order_details) or die(mysql_error());
}
$reorderlevelcheck = checkSellerStock($product_option_id, $quantity);
if ($reorderlevelcheck == 1) {
// Send Stock Reorder Mail To Seller
sendStockreordermail($product_option_id, $quantity);
}
}
// end while
}
// end number of rows
isset($_SESSION['SESS_orderid']) ? session_unregister('SESS_orderid') : session_register('SESS_orderid');
$_SESSION['SESS_orderid'] = $orderid;
if ($gift_coupon_flag == 1) {
if (isset($_SESSION['SESS_digital_product']) && $_SESSION['SESS_digital_product'] != '') {
session_unregister($_SESSION['SESS_digital_product']);
}
$update_order_details = "UPDATE " . $tableprefix . "order_details\n\t\t\t\t\t\t\t\t\t SET item_status = 4\n\t\t\t\t\t\t\t\t\t WHERE order_id = " . $orderid . " ";
mysql_query($update_order_details) or die(mysql_error());
}
// end if gift flag
if ($product_download_flag == 1) {
$update_order_details = "UPDATE " . $tableprefix . "order_details\n\t\t\t\t\t\t\t\t\t\t SET item_status = 4\n\t\t\t\t\t\t\t\t\t\t WHERE order_id = " . $orderid . " AND product_id = " . $digital_product_id;
mysql_query($update_order_details) or die(mysql_error());
}
if ($product_download_flag == 1) {
isset($_SESSION['SESS_digital_product']) ? session_unregister('SESS_digital_product') : session_register('SESS_digital_product');
$_SESSION['SESS_digital_product'] = 1;
}
// Send Giftcertificate Mails
/* if($gift_coupon_flag == 1)
{
sendgiftCertificateMail_Buyer($orderid,$_SESSION["sess_userid"],$usertype);
sendgiftCertificateMail_Seller($orderid,$_SESSION["sess_userid"]);
sendgiftCertificateMail_Admin($orderid,$_SESSION["sess_userid"]);
}
//Send Digital Certificate Mails
if($product_download_flag == 1)
{
sendDigitalCertificateMail_Buyer($orderid,$_SESSION["sess_userid"],$usertype);
sendDigitalCertificateMail_Seller($orderid,$_SESSION["sess_userid"]);
sendDigitalCertificateMail_Admin($orderid,$_SESSION["sess_userid"]);
}
if($product_download_flag!=1 && $gift_coupon_flag!=1)
{
//sendBuyerEmail($orderid,$_SESSION["sess_userid"],$usertype);
//sendSellerEmail($orderid,$_SESSION["sess_userid"]);
//sendAdminEmail($orderid,$_SESSION["sess_userid"]);
}*/
}
// end of first if condition
//$cost = $total_amount_topay; // price
$currency = getSettingsValue("admin_currency");
if ($google_demo == "YES") {
$server_type = "sandbox";
} else {
$server_type = "checkout";
}
// Create a new shopping cart object
$cart = new GoogleCart($google_id, $google_key, $server_type, $currency);
$total = 0;
$cartitems = "";
$price = 0;
$sql = "SELECT c.*,(p.product_price+po.additional_price) AS product_price,p.product_name,p.product_description,p.product_code,p.product_artist_id,po.discount,p.vdigital_product,po.product_option_id\n\t\t\t\tFROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n\t\t\t\tWHERE c.user_id = '" . $_SESSION["sess_userid"] . "' ";
$res = mysql_query($sql);
$cart_id = 1;
$discountstr = "";
$unit_price = 0;
$shipping_cost = 0;
$product_tax = 0;
if (mysql_num_rows($res) > 0) {
while ($rw = mysql_fetch_array($res)) {
$cart_no = "item_" . $cart_id;
$ship_no = "ship_" . $cart_id;
$restriction_no = "restriction_" . $cart_id;
$product_option_id = $rw["product_option_id"];
$productname = $rw["product_name"];
$rate = $rw["product_price"];
$qty = $rw["quantity"];
$price = $qty * $rate;
if ($rw["discount"] != "0") {
$price = $price - $price * $rw["discount"] / 100;
//$discountstr="<br>discount(".$rw["discount"]."%)";
}
$check_shipping_enable = checkShippingEnable();
$hide_shipping_division = hideShipping();
if ($check_shipping_enable == "Y" && $hide_shipping_division == 1) {
if (!empty($_SESSION["SHIPPING_DETAILS"])) {
$shipping_cost = $_SESSION["SHIPPING_DETAILS"][$product_option_id]['rate'];
}
}
if (!empty($_SESSION["TAX_DETAILS"])) {
$product_tax = $_SESSION["TAX_DETAILS"][$product_option_id];
}
$unit_price = $price + $shipping_cost + $product_tax;
$cart_no = new GoogleItem($productname, $rw["product_description"], 1, $unit_price);
// Unit price
$cart->AddItem($cart_no);
$cart_id++;
}
}
$_SESSION['google_order_id'] = '';
$_SESSION['gift_coupon_flag'] = '';
$_SESSION['product_download_flag'] = '';
$_SESSION['google_order_id'] = $orderid;
$_SESSION['gift_coupon_flag'] = $gift_coupon_flag;
$_SESSION['product_download_flag'] = $product_download_flag;
$merchantdata = $orderid . "@" . $gift_coupon_flag . "@" . $product_download_flag;
$cart->SetMerchantPrivateData($merchantdata);
// continue link page
$cart->SetContinueShoppingUrl(SITE_URL . "/google_checkout_payment.php?google_check=1");
$cart->AddRoundingPolicy("HALF_UP", "PER_LINE");
// Display XML data
// Display Google Checkout button
echo $cart->CheckoutButtonCode("LARGE");
//$_SESSION["SHIPPING_DETAILS"] = array();
//$_SESSION['SHIPPING_TOTAL'] = 0;
}
$product_commission_amt = $discount_amount * $row["commission"] / 100;
// Product Based Commission Calculation End
$sql = "INSERT INTO " . $tableprefix . "order_details (\n\t\t\t\torder_id,\n\t\t\t\tproduct_id,\n\t\t\t\tproduct_name,\n\t\t\t\tproduct_code,\n\t\t\t\tproduct_price,\n\t\t\t\tproduct_quantity,\n\t\t\t\tproduct_discount,\n\t\t\t\tartist_id,\n\t\t\t\titem_status,\n\t\t\t\tartist_payment_status,\n product_tax,\n product_option_id,\n product_commission_amount\n\t\t\t\t)VALUES(\n\t\t\t\t'" . addslashes($orderid) . "',\n\t\t\t\t'" . addslashes($productid) . "',\n\t\t\t\t'" . addslashes($productname) . "',\n\t\t\t\t'" . addslashes($productcode) . "',\n\t\t\t\t'" . addslashes($productprice) . "',\n\t\t\t\t'" . addslashes($quantity) . "',\n\t\t\t\t'" . addslashes($productdiscount) . "',\n\t\t\t\t'" . addslashes($artistid) . "',\n\t\t\t\t'1',\n\t\t\t\t'0',\n '" . $product_tax . "',\n '" . $product_option_id . "',\n '" . $product_commission_amt . "'\n\t\t\t\t)";
mysql_query($sql);
//echo "sql==".$sql."<br><br>";
$artists[$i] = $artistid;
$i++;
$sql = "";
if ($product_download_flag == 1) {
$update_order_details = "UPDATE " . $tableprefix . "order_details\n\t\t\t\t\t\tSET item_status = 4\n\t\t\t\t\t\tWHERE order_id = " . $orderid . " AND product_id = " . $digital_product_id;
mysql_query($update_order_details) or die(mysql_error());
}
$reorderlevelcheck = checkSellerStock($product_option_id, $quantity);
if ($reorderlevelcheck == 1) {
// Send Stock Reorder Mail To Seller
sendStockreordermail($product_option_id, $quantity);
}
}
// end while
}
// end number of rows
$message = "Your order has placed successfully";
if ($orderid != '') {
$sql = "SELECT distinct p.product_artist_id,a.paypalemail,a.commission\n FROM " . $tableprefix . "cart c INNER JOIN " . $tableprefix . "products p ON c.product_id = p.product_id\n INNER JOIN " . $tableprefix . "artists a ON a.artist_id=p.product_artist_id\n WHERE c.user_id = '" . addslashes($_SESSION["sess_userid"]) . "' ";
$res = mysql_query($sql) or die(mysql_error());
//fore each vendor
while ($rsObj = mysql_fetch_object($res)) {
$select_cart_details = "SELECT c.*, p.product_name,(p.product_price+po.additional_price) AS product_price,po.discount,p.product_artist_id\n\t\t\t\t\tFROM " . $tableprefix . "cart c\n INNER JOIN " . $tableprefix . "product_options po ON po.product_option_id = c.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = po.product_id\n\t\t\t\t\tWHERE c.user_id = '" . addslashes($_SESSION["sess_userid"]) . "' AND p.product_artist_id ='" . $rsObj->product_artist_id . "' ";
//echo '<br>'. $select_cart_details;
$result_cart_details = mysql_query($select_cart_details) or die(mysql_error());
$product_price = 0;