fetchAssoc(); $result_co_id = db_query("SELECT co_id FROM vri_master_country WHERE co_code ='".$country."' "); $temp_data = $result_co_id->fetchAssoc(); $co_id = $temp_data['co_id']; $sql_select = db_query("SELECT vs_id ,vs_name FROM vri_master_states WHERE vs_active=1 AND vs_country='".$co_id."' ORDER BY vs_name "); while ($row = $sql_select->fetchAssoc()) { if($cust_data['du_state'] == $row['vs_id']) { $select = 'selected'; } else { $select = ''; } $select_state_data .= ''; } $state = ''; $city =''; echo json_encode(array('state'=>$state,'city'=>$city)); } exit; } if($_REQUEST['change_state_dropdown']==1) { $vc_state = trim($_REQUEST['vc_state']); if($vc_state!="") { $cust_id = $_SESSION['customer_id']; $cust_result=db_query("select * from customer where customer_id = '".$cust_id."'"); $cust_data = $cust_result->fetchAssoc(); $sql_select = db_query("SELECT mc_id ,mc_name FROM vri_master_city WHERE mc_active=1 AND mc_state='".$vc_state."' ORDER BY mc_name "); while ($row = $sql_select->fetchAssoc()) { if($cust_data['du_city'] == $row['mc_id']) { $select = 'selected'; } else { $select = ''; } $select_city_data .= ''; } echo ''; } exit; } $max1=count($_SESSION['cart']); if($max1 == 0 || $max1 == "") { drupal_goto(''); } $cust_id = $_SESSION['customer_id']; if( is_array($cust_id)) { $cid = $cust_id['customer_id']; } else { $cid = $cust_id; } if($cid > 0) { $cust_result=db_query("select * from customer where customer_id = '".$cid."'"); $cust_data = $cust_result->fetchAssoc(); $sql_select = db_query("SELECT co_code ,co_name FROM vri_master_country WHERE co_active=1 ORDER BY co_name "); while ($row = $sql_select->fetchAssoc()) { if($cust_data['du_country'] == $row['co_code']) { $select = 'selected'; } else { $select = ''; } $country .= ''; } $cont_result=db_query("select co_id from vri_master_country where co_code = '".$cust_data['du_country']."'"); $cont_data = $cont_result->fetchAssoc(); $sql_select = db_query("SELECT vs_id ,vs_name FROM vri_master_states WHERE vs_active=1 AND vs_country='".$cont_data['co_id']."' ORDER BY vs_name "); while ($row = $sql_select->fetchAssoc()) { if($cust_data['du_state'] == $row['vs_id']) { $select = 'selected'; } else { $select = ''; } $select_state_data .= ''; } $sql_select = db_query("SELECT mc_id ,mc_name FROM vri_master_city WHERE mc_active=1 AND mc_state='".$cust_data['du_state']."' ORDER BY mc_name "); while ($row = $sql_select->fetchAssoc()) { if($cust_data['du_city'] == $row['mc_id']) { $select = 'selected'; } else { $select = ''; } $select_city_data .= ''; } $btn1 = ''; $table1='
Billing Details
'.$btn1.'
'; } else { $btn = '

or
'; $btn .= ' '; } if($_REQUEST["login"] == 1) { $valid_user = 0; $email = trim($_REQUEST['mail']); $pwd = md5(trim($_REQUEST['pass'])); $user_query = db_query("Select customer_id from customer where email like '".$email."' and password like '".$pwd."' limit 1"); $valid_user = $user_query->fetchAssoc(); if($valid_user > 0) { $_SESSION['customer_id'] = $valid_user; $invalid_user_msg = 0; } else { $invalid_user_msg = 1; } echo $invalid_user_msg; exit; } if($_REQUEST["register"] == 1) { $name = trim($_REQUEST['name']); $email = trim($_REQUEST['email']); $cno1 = trim($_REQUEST['cno1']); $cno2 = trim($_REQUEST['cno2']); $pwd = md5(trim($_REQUEST['pwd'])); $add = trim($_REQUEST['add']); $sql_email_check = "SELECT customer_id FROM customer WHERE email = '".$email."' "; $result_cust_id = db_query($sql_email_check); $result_cust_id = $result_cust_id->fetchAssoc(); if($result_cust_id['customer_id']>0) { echo json_encode(array("err"=>0,"msg"=>"You are already registerd. Click on forgot password to reset your password.")); } else { $field['customer_name']=$name; $field['email']=$email; $field['contact_no1']=$cno1; if($cno2 != "") { $field['contact_no2']=$cno2; } $field['password']=$pwd; $field['address']=$add; $query = db_insert("customer"); $query->fields($field); $customer_id = $query->execute(); $_SESSION['customer_id'] = $customer_id; echo json_encode(array("err"=>1,"msg"=>"Account created successfully.")); //======#################################### Email on Sign up ############################################ $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; // More headers $sql_from_id = "select type_val from vri_type_details where td_key ='VIPASSANA-FROM-EMAIL' AND active ='1' "; $result_email = db_query($sql_from_id); $email_data = $result_email->fetchAssoc(); //===================== $sql_mail_template = "SELECT mt_template , mt_subject from vri_mailer_template WHERE mt_template_key ='SIGN-UP-TEMPLATE' AND mt_active ='1' "; $result_mail_template = db_query($sql_mail_template); $mail_template = $result_mail_template->fetchAssoc(); $email_body = $mail_template['mt_template']; $subject = $mail_template['mt_subject']; //REPLCAE MEARGE CODE======== $email_body = str_replace("[CUSTOMER_NAME]",$name,$email_body); $email_body = str_replace("[CUSTOMER_EMAIL]",$email,$email_body); $email_body = str_replace("[SITE_NAME]","Vipassana Research Institute",$email_body); $email_body = str_replace("[SITE_LOGO]",$GLOBALS['base_url'].'/sites/all/themes/vri/images/vri_logo.png',$email_body); $email_body = str_replace("[SITE_URL]",$GLOBALS['base_url'],$email_body); //REPLCAE MEARGE CODE======== $headers .= 'From: <'.$email_data['type_val'].'>' . "\r\n"; $to = $email; //$subject = "Vipassana Research Institute Reset Password"; //$email_body = "Your password ".$user_pass['password']; if(trim($email_body)!="") { mail($to,$subject,$email_body,$headers); } } exit; } $curr = $_SESSION['curr']; if($curr == "") { $_SESSION['curr'] = "INR"; } $currency_array = array("AUD"=>"$", "BRL"=>"R$", "CAD"=>"$", "CZK"=>"Kc", "DKK"=>"kr", "EUR"=>"€", "HKD"=>"$", "HUF"=>"Ft", "ILS"=>"?", "JPY"=>"¥", "MXN"=>"?", "NOK"=>"kr", "NZD"=>"$", "PHP"=>"?", "PLN"=>"zl", "GBP"=>"£", "SGD"=>"$", "SEK"=>"kr", "CHF"=>"?", "TWD"=>"$", "THB"=>"?", "TRY"=>"£", "USD"=>"$", "INR"=>"Rs" ); $symbol = $currency_array[$curr]; function convertCurrency1($amount, $from, $to) { $url = "https://www.google.com/finance/converter?a=" . $amount . "&from=" . $from . "&to=" . $to; $ch = curl_init(); $timeout = 0; curl_setopt ($ch, CURLOPT_URL, $url); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $rawdata = curl_exec($ch); curl_close($ch); $matches = array(); preg_match_all("|(.*)|U", $rawdata, $matches); $result = explode(" ", $matches[1][0]); return round($result[0], 2); } function get_order_total1() { $max=count($_SESSION['cart']); $sum=0; for($i=0;$i<$max;$i++) { $pid=$_SESSION['cart'][$i]['productid']; $q=$_SESSION['cart'][$i]['qty']; $price=get_price1($pid); $sum+=$price*$q; } return $sum; } function remove_product1($pid) { $pid=intval($pid); $max=count($_SESSION['cart']); for($i=0;$i<$max;$i++) { if($pid==$_SESSION['cart'][$i]['productid']) { unset($_SESSION['cart'][$i]); break; } } $_SESSION['cart']=array_values($_SESSION['cart']); } function get_product_quant1($pid) { $result=db_query("select mp_quantity from vri_master_product where mp_id=$pid"); $row = $result->fetchAssoc(); return $row['mp_quantity']; } function get_product_name1($pid) { $result=db_query("select mp_product_name from vri_master_product where mp_id=$pid"); $row = $result->fetchAssoc(); return $row['mp_product_name']; } function get_price1($pid) { $result=db_query("select mp_price from vri_master_product where mp_id=$pid"); $row = $result->fetchAssoc(); return $row['mp_price']; } if($_REQUEST['place_my_order']==1) { //=== $json_data = $_REQUEST['json_data']; $err_flag = 0; if(!empty($json_data)) { $cust_id = $_SESSION['customer_id']; if( is_array($cust_id)) { $cid = $cust_id['customer_id']; } else { $cid = $cust_id; } parse_str($_REQUEST['form_data'],$submit_data); $od_number = rand() ; $field['od_customer_id'] = $cid; $field['od_number'] = $od_number; $field['od_name'] = trim($submit_data['txt_name']); $field['od_email'] = trim($submit_data['txt_email']); $field['od_contact1'] = trim($submit_data['contact_no1']); $field['od_contact2'] = trim($submit_data['contact_no2']); $field['od_billing_address'] = trim($submit_data['shipping_address']); $field['od_shipping_address'] = trim($submit_data['shipping_address']); $field['od_order_on'] = date('Y-m-d H:i:s'); $field['od_local_currency'] = $_SESSION['curr']; $field['od_country'] = $submit_data['country321']; $field['od_state'] = $submit_data['state321']; $field['od_city'] = $submit_data['city321']; $field['od_zip'] = $submit_data['txt_zip']; $query = db_insert("vri_order_detail"); $query->fields($field); $order_id = $query->execute(); //ORDER TRACKING == $field_tracking['ot_order_id'] = $order_id; $field_tracking['ot_status'] = 1; $field_tracking['ot_update_on'] = date('Y-m-d H:i:s'); $query_track = db_insert("vri_order_tracking"); $query_track->fields($field_tracking); $query_track->execute(); $total_amount = 0; $local_total_amount = 0; //========================================== foreach ($json_data as $i => $arr) { $product = substr($arr['product'],3); $sql_stock_quantity = "SELECT mp_quantity, mp_product_name FROM vri_master_product WHERE mp_id='".$product."' "; $stock_quantity = db_query($sql_stock_quantity); $stock_q = $stock_quantity->fetchAssoc(); if($stock_q['mp_quantity']=="" || $stock_q['mp_quantity']==0) { $err_msg .= $stock_q['mp_product_name']." Out of stock
"; $err_flag = 1; } else if($stock_q['mp_quantity'] < $arr['quantity']) { $err_msg .= "Only ".$stock_q['mp_quantity']." product(s) available for ".$stock_q['mp_product_name']."
" ; $err_flag = 1; } } //========================================== if($err_flag==1) { $url = $err_msg; } else { foreach ($json_data as $i => $arr) { $pro_amt = 0; $quantity = $arr['quantity']; $product = substr($arr['product'],3); if(is_numeric($quantity) && is_numeric($product)) { $sql_product_amount = "SELECT mp_price FROM vri_master_product WHERE mp_id ='".$product."' "; $result_product_amount = db_query($sql_product_amount); $data = $result_product_amount->fetchAssoc(); $product_amount = $data['mp_price']; $pro_amt = $quantity * $product_amount; $total_amount = $total_amount + $pro_amt; // if($_SESSION['curr'] != "INR") { $local_product_amount = convertCurrency1($product_amount, 'INR', $_SESSION['curr']); $local_pro_amt = $quantity * $local_product_amount; $local_total_amount = $local_total_amount + $local_pro_amt; } else { $local_product_amount = $product_amount; $local_pro_amt = $quantity * $local_product_amount; $local_total_amount = $local_total_amount + $local_pro_amt; } // $field_product['op_order_id'] = $order_id; $field_product['op_product_id'] = $product; $field_product['op_product_quantity'] = $quantity; $field_product['op_product_amount'] = $product_amount; $field_product['op_product_total_amount'] = $pro_amt; $field_product['op_local_product_amount'] = $local_product_amount; $field_product['op_product_local_total_amount'] = $local_pro_amt; $query1 = db_insert("vri_order_product"); $query1->fields($field_product); $query1->execute(); unset($query1); } } unset($_SESSION['cart']); $amout_result=db_query("select sum(op_product_total_amount) as total from vri_order_product where op_order_id = '".$order_id."' group by op_order_id"); $total = $amout_result->fetchAssoc(); $tot = $total['total']; $url = "/node/120?ord=$order_id"; } } else { $err_flag = '1'; $url = "No product(s) found."; } echo $err_flag."@@".$url; exit; } $content .='
'; $max=count($_SESSION['cart']); for($i=0;$i<$max;$i++) { $pid=$_SESSION['cart'][$i]['productid']; $q=$_SESSION['cart'][$i]['qty']; $pname=get_product_name1($pid); if($q==0) continue; $ser = $i+1; $image_path = "/".conf_path()."/files/"; $img_result=db_query("select pi_image_path from vri_product_images where pi_prodict_id = $pid and pi_default_image = 1"); $img_row = $img_result->fetchAssoc(); if($img_row['pi_image_path'] == "") { $prod_image = "/sites/all/themes/vri/css/images/no_image.jpg"; } else { $prod_image = $image_path.''.$img_row['pi_image_path']; } $ava_result=db_query("select * from vri_master_product where mp_id= $pid"); $ava_data = $ava_result->fetchAssoc(); if($ava_data['mp_quantity'] > 0) { $sta = "In stock"; } else { $sta = "Out of stock"; } $content .= ' '; } /* cal_price1('.$pid.'); removed from on key up*/ $t_total = $curr != "INR"?convertCurrency1(get_order_total1(), "INR", $curr):get_order_total1(); if ( $t_total > 200 ) { $shipping = 0; } else $shipping = 55; $t_total += $shipping; $content .= ' '; $content .='
ProductQuantityPriceTotal
'.$pname.'
Status: '.$sta.'
'.$symbol.' '.($curr != "INR"?convertCurrency1(get_price1($pid), "INR", $curr):get_price1($pid)).'
'.$symbol.'  '.($curr != "INR"?convertCurrency1(get_price1($pid), "INR", $curr):get_price1($pid))*$q.'
Shipping Charges  '.$symbol.' '.($curr != "INR"?convertCurrency1($shipping, "INR", $curr):$shipping).'
'.$symbol.' '.($curr != "INR"?convertCurrency1(get_order_total1(), "INR", $curr):get_order_total1()).'
'.$btn.'
'; $content .= ' '.$table1.' '; echo $content; ?>