Error: '.$rows99['order_no'].' have only Rs. '.$rmmm.' and you are trying to use Rs. '.$data['policy'][$policy_code].'
';
return;
}
$data['discount_name'][]=$rows99['order_no'].' '.$v;
}
$rm+=$v;
}
}
//print_r($re2);
if($data['promotional_wallet']>0)
{
$sql99 = "Select sum(amt) as amt from pw_consolidate where userid = '".trim($re2['code'])."' ";
$res99 = mysql_query($sql99);
$rows99 = mysql_fetch_assoc($res99);
if($data['promotional_wallet']>$rows99['amt'])
{
echo 'Error: You have only '.$rows99['amt'].' Promotional Wallets & you are trying to use '.$data['promotional_wallet'].'
';
return;
}
$discount_name_p ='Promotional Wallets '.$data['promotional_wallet'];
$data['discount_name'][]=$discount_name_p;
//$rm+=$data['promotional_wallet'];
}
if(trim($data['state'])=='')
{
echo 'Error: Sorry one of Product in Cart is already soldout, Please select another one
';
return;
}
$a1 = daily_diamond_rate($result['diamond_type_default']);
$a=$a1*$result['diamond_total_weight'];
if($result['diamond_discount_percentage']>0)
{
$a_before_discount = $a;
$da= round(($a*$result['diamond_discount_percentage'])/100,2);
$a = $a - $da;
}
$b1 = daily_metal_rate($result['metal_type_default']);
$b=$b1*$result['metal_weight'];
if($result['metal_discount_percentage']>0){
$b_before_discount = $b;
$da= round(($b*$result['metal_discount_percentage'])/100,2);
$b = $b - $da;
}
$c=gem_rate($result['product_id'],$result['gems_type_default']);
if($result['stone_discount_percentage']>0)
{
$c_before_discount = $c;
$da= round(($c*$result['stone_discount_percentage'])/100,2);
$c = $c - $da;
}
if($result['making_charges']>0)
$d=$result['making_charges'];
else
$d=($result['metal_weight']*900);
if($result['making_charges_discount_percentage']>0){
$d_before_discount = $d;
$da= round(($d*$result['making_charges_discount_percentage'])/100,2);
echo $d = $d - $da;
}
$total_making+=$d;
$t = ($a+$b+$c+$d);
if($result['discount_percantage']>0)
{
$dis = round(($t*$result['discount_percantage'])/100);
$t2 = $t - $dis;
//echo $text.= 'Rs. '.number_format($rem,2).' '.$pmode.'
';
return;
}
if($data['payment']=='other')
{
if(trim($_REQUEST['payment_mode'])=="")
{
echo 'Enter Payment Mode Please
';
return;
}
if(trim($_REQUEST['dd_no'])=="")
{
echo 'Enter Ch/DD/Bank Number Please
';
return;
}
}
//echo '0|0|';
$k = array();
//unset($_SESSION["b"]);
$s = "INSERT INTO customer_orders ";
$s .= "SET customer_code ='".$data['customer_code']."'";
$s .= ",billing_email ='".trim($data['email'])."'";
$s .= ",billing_name ='".trim($data['name'])."'";
$s .= ",billing_mobile ='".trim($data['mobile'])."'";
$s .= ",billing_add_1 ='".trim($data['add_1'])."'";
$s .= ",billing_add_2 ='".trim($data['add_2'])."'";
$s .= ",billing_city ='".trim($data['city'])."'";
$s .= ",billing_state ='".trim($data['state'])."'";
$s .= ",billing_country ='".trim($data['country'])."'";
$s .= ",billing_pin_code ='".trim($data['postal_code'])."'";
if($data['shipping_same']==1)
{
$data['shipping_name'] = $data['name'];
$data['shipping_mobile'] = $data['mobile'];
$data['shipping_add_1'] = $data['add_1'];
$data['shipping_add_2'] = $data['add_2'];
$data['shipping_city'] = $data['city'];
$data['shipping_state'] = $data['state'];
$data['shipping_country'] = $data['country'];
$data['shipping_postal_code'] = $data['postal_code'];
}
// echo '';
// print_r($data);
/*$country = display_feild('bm_countries_for_ip','countries_name','code',$data['country']);
$state = display_feild('bm_states','state_name','code',$data['state']);
$city = $data['city'];
*/
$s .= ",shipping_same ='".trim($data['shipping_same'])."'";
$s .= ",shipping_name ='".trim($data['shipping_name'])."'";
$s .= ",shipping_mobile ='".trim($data['shipping_mobile'])."'";
$s .= ",shipping_add_1 ='".trim($data['shipping_add_1'])."'";
$s .= ",shipping_add_2 ='".trim($data['shipping_add_2'])."'";
$s .= ",shipping_country ='".trim($data['shipping_country'])."'";
$s .= ",shipping_state ='".trim($data['shipping_state'])."'";
$s .= ",shipping_city ='".trim($data['shipping_city'])."'";
$s .= ",shipping_pin_code ='".trim($data['shipping_postal_code'])."'";
$dispatch_details = "Name : ".$data['shipping_name'].'\n ';
$dispatch_details.= "Contact Number : ".$data['shipping_mobile'].'\n ';
$dispatch_details.= "".$data['shipping_add_1'].'\n ';
$dispatch_details.= "".$data['shipping_add_2'].'\n ';
$dispatch_details.= "".$data['shipping_city'].','.$data['shipping_state'].','.$data['shipping_city'].'\n ';
$dispatch_details.= "".$data['shipping_postal_code'].'\n ';
$s .= ",admin_id ='".$_SESSION['admin_code']."'";
//$s .= ",customer_type ='".trim($data['customer_type'])."'";
$s .= ",total_amount ='".trim($data['order_total'])."'";
$s .= ",t_cgst ='".$tt_cgst2."'";
$s .= ",t_sgst ='".$tt_sgst2."'";
$s .= ",t_igst ='".$tt_igst2."'";
$s .= ",cgst ='".$cgst."'";
$s .= ",sgst ='".$sgst."'";
$s .= ",igst ='".$igst."'";
$s .= ",promotional_wallet ='".trim($data['promotional_wallet'])."'";
$s .= ",discount ='".($data['promotional_wallet'])."'";//$t_discount
$s .= ",discount_name ='".$discount_name_p."'";
$s .= ",policy_code ='".trim($data['policy_code'])."'";
$s .= ",policy_amount ='".trim($rm)."'";
$s .= ",policy_remarks ='".trim(implode(",",$data['discount_name']))."'";
$s .= ",product_taking_for ='".trim($data['product_taking_for'])."'";
$s .= ",receiver_name ='".trim($data['receiver_name'])."'";
$s .= ",receiver_mobile ='".trim($data['receiver_mobile'])."'";
$s .= ",otp ='".trim($data['otp'])."'";
// if($data['shipping_option']=='ship')
// $s .= ",shiping_status ='0'";
// else
// {
$s .= ",shiping_status ='1'";
$s .= ",shiping_remarks ='Products delivered (Picked From Office)'";
//}
$s .= ",net_amount ='".trim($total)."'";
$s .= ",paid_after_did ='".trim($rem)."'";
$s .= ",coupon_code ='".trim('')."'";
$s .= ",tax_p ='3'";
$s .= ",tax ='".$total_tax."'";
$s .= ",making ='".$total_making."'";
$s .= ",payment_type ='".trim($data['payment'])."'";
$s .= ",payment_mode ='".trim($data['payment_mode'])."'";
$s .= ",dd_no ='".trim($data['dd_no'])."'";
$s .= ",remarks ='".mysql_real_escape_string(trim($data['remarks']))."'";
$s .= ",order_in ='1'";
$s .= ",ip ='".getRealIpAddr()."'";
$s .= ",c_date ='".date("Y-m-d")."'";
// echo '0|0|'.$s;die();
//$total = $_SESSION['order']['total'];
if(@mysql_query($s))
{
$order_id = mysql_insert_id();
$order_no_text = "JS/".date("mY")."/S/".$order_id;
$s = "update customer_orders SET order_no='".$order_no_text."' where code='".$order_id."' ";
mysql_query($s);
if($data['promotional_wallet']>0)
{
$s = "INSERT INTO pw_consolidate SET userid = '".$re2['code']."' ,amt='-".$data['promotional_wallet']."', date='".date("Y-m-d")."', remarks='Promotional Wallet used against order number ".$order_id."'";
mysql_query($s);
}
//
if($data['product_taking_for']=='other')
{
$sql = "update mobile_confirm_sale SET used = 1 where code='".$ro_code['code']."' ";
$rr = mysql_query($sql);
}
if($rm>0)
{
if(count($data['policy'])>0)
foreach($data['policy'] as $policy_code=>$v)
{
if($v>0)
{
$sql = "INSERT INTO consolidate_policy_used SET policy_code='".$policy_code."', remarks='"."".$order_no_text."', paid='1', date='".date("Y-m-d")."',amt='".$v."'";
mysql_query($sql);
}
}
}
if($rem>0)
{
$sql = "INSERT INTO payment_collection
SET policy_code='".$data['policy_code']."',
customer_code='".$data['customer_code']."',
order_no='"."".$order_no_text."',
order_no_no='"."".$order_id."',
remarks='"."Payment Received for ".$order_id."', ";
if($data['payment']=='cash')
$sql.= "p_type='Cash', ";
else
$sql.= "p_type='Cheque/DD',";
$sql.= "cheque_no='".$data['dd_no']."',";
$sql.= "cheque_remarks='".$data['payment_mode']."',";
$sql.= "admin_id='".$_SESSION['admin_code']."',";
$sql.= " paid='1', date='".date("Y-m-d")."',amt='".$rem."'";
mysql_query($sql);
}
$sql = "INSERT INTO product_dispatch SET m_code='".$data['customer_code']."', order_no='"."".$order_no_text."', entery_type='Online', dispatch_address='".mysql_real_escape_string(trim($dispatch_details))."'";
if($data['shipping_option']=='self')
{
$sql .= ",status='1'";
$sql .= ",dispatching_notes='Products delivered (Picked From Office)'";
}
mysql_query($sql);
$dispatch_id = mysql_insert_id();
$i = 1;
$j = 1;
foreach($pro as $det)
{
$s = "INSERT INTO customer_order_items ";
$s .= "SET order_no ='".$order_id."'";
$s .= ",c_code ='".$data['customer_code']."'";
$s .= ",product_code ='".$det['code']."'";
$s .= ",certificate_number ='".$det['certificate_number']."'";
$s .= ",product_name ='".$det['name']."'";
$s .= ",product_size ='".$det['size']."'";
$s .= ",product_sku ='".$det['sku']."'";
$s .= ",purchase_price ='".$det['total']."'";
$s .= ",our_price ='".$det['total']."'";
$s .= ",mrp ='".$det['total']."'";
$s .= ",diamond_name ='".$det['diamond_name']."'";
$s .= ",diamond_total_weight ='".$det['diamond_total_weight']."'";
$s .= ",diamond_rate ='".$det['diamond_rate']."'";
$s .= ",diamond_total ='".$det['diamond_total']."'";
$s .= ",metal_name ='".$det['metal_name']."'";
$s .= ",metal_total_weight ='".$det['metal_total_weight']."'";
$s .= ",metal_rate ='".$det['metal_rate']."'";
$s .= ",metal_total ='".$det['metal_total']."'";
$s .= ",gem_name ='".$det['gem_name']."'";
$s .= ",gem_total_weight ='".$det['gem_total_weight']."'";
$s .= ",gem_rate ='".$det['gem_rate']."'";
$s .= ",gem_total ='".$det['gem_total']."'";
$s .= ",making_charges ='".$det['making_charges']."'";
$s .= ",tax ='".$det['tax']."'";
$s .= ",net_amount ='".$det['total_all']."'";
$s .= ",offer_price ='".$det['total']."'";
$s .= ",discount_amt ='".$det['discount_amt']."'";
$s .= ",discount_type ='".$det['discount']."'";
$s .= ",rsp ='".$det['rsp']."'";
$s .= ",qty ='".$det['qty']."'";
$s .= ",t_cgst ='".$det['t_cgst']."'";
$s .= ",t_sgst ='".$det['t_sgst']."'";
$s .= ",t_igst ='".$det['t_igst']."'";
$s .= ",cgst ='".$det['cgst']."'";
$s .= ",sgst ='".$det['sgst']."'";
$s .= ",igst ='".$det['igst']."'";
//echo 'Error : in Updation!! ';
return true;
}
}else{
echo 'Error : Can\'t Delete record provide valid deletion reason!!';
}
}else{
echo 'Error : Can\'t Delete record invalid sales id!! ';
}
}
break;
};
}
function create_log($table_name,$data,$code='code')
{
$response = array();
$sql_x1 = "select * from ".$table_name." where ".$code."='".$data['id']."'";
$r_x1 = mysql_query($sql_x1);
while($currect_d = mysql_fetch_assoc($r_x1))
{
$i = 0;
$text = 'INSERT INTO '.$table_name.' SET ';
$sql_x = "DESCRIBE ".$table_name." ";
$r_x = mysql_query($sql_x);
while($row_x=mysql_fetch_assoc($r_x))
{
if($i>0)
$text.=',';
$text.= $row_x['Field']."='".$currect_d[$row_x['Field']]."'";
$i++;
}
$s2 = "INSERT INTO log_users SET
admin_code='".$_SESSION['admin_code']."'
,admin_name='".$_SESSION['admin_name']."'
,admin_ip='".$_SERVER['REMOTE_ADDR']."'
,log_data='".mysql_real_escape_string($text)."'
,table_name='".$data['id']."'
,action_taken='".$msg."'
";
// echo $s2;
mysql_query($s2);
}
}
function fetch_products2($code)
{
$sql = "SELECT *,ps.code as code FROM product p INNER JOIN product_sizes ps ON p.code=ps.product_code and p.status=1 and ps.status=1 and ps.code='".$code."' ";
$result = mysql_query($sql);
$rows = mysql_fetch_assoc($result);
return $rows;
}
function getRealIpAddr()
{
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
return $ip;
}
?>
0)
{
?>
