';
?>
Promotional Wallet ()
';
}
}
break;
case 'mobile_number':
{
if(!is_numeric($_REQUEST['mobile_number']))
{
echo 'Enter a Valid Mobile Number Please
';
return;
}
if(strlen($_REQUEST['mobile_number'])<>10)
{
echo 'Enter a Valid 10 Digits Mobile Number Please
';
return;
}
$q = "SELECT * FROM customer where mobile='".$_REQUEST['mobile_number']."' ";
$qr = mysql_query($q);
$re2 = mysql_fetch_assoc($qr);
if($re2['code']>0)
{
echo '
Sorry Mobile Number Seems already Registered!!
';
}
else
{
echo '
Congratulations! You are eligible to join.
';
}
}
break;
case'GeneralDetails':
{
//print_r($_REQUEST);
$searchtext = mysql_real_escape_string($_REQUEST['searchtext']);
//$prtstatus = $_REQUEST['status'];
//$prtcat = $_REQUEST['instructions'];
$searchtext = trim($searchtext);
$where = '';
$fields = array('o.order_no','name','net_amount','email','mobile','customer_code','billing_name','billing_mobile');
if(!empty($searchtext))
{
foreach($fields as $field)
{
if($where=="")
$where = ' AND ( ';
else
$where .= ' OR ';
$where .= $field." LIKE '%".$searchtext."%' ";
}
$where .=')';
}
/* if($_SESSION['access_type']<2)
$where.= " and (sale_employee_code_new='".$_SESSION['admin_code']."' or cc_admin_id='".$_SESSION['admin_code']."')";
*/
/*if($_REQUEST['s_mtype']<>"")
{
$where .= " and mtype='".$_REQUEST['s_mtype']."'";
}
if($_REQUEST['s_team']<>"")
{
$where .= " and team='".$_REQUEST['s_mtype']."'";
}
if($_REQUEST['s_se']>0)
{
$where .= " and sale_employee_code<=0 ";
}
if($_REQUEST['s_sale_employee_code']>0)
{
$where .= " and sale_employee_code='".$_REQUEST['s_sale_employee_code']."'";
}
if($_REQUEST['s_status_c']>0)
{
$where .= " and customer_calling_status='".$_REQUEST['s_status_c']."'";
}
if($_REQUEST['s_sms']<>"")
{
$where .= " and sms='".$_REQUEST['s_sms']."'";
}
*/
$where .= " and o.c_date >='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and o.c_date <='".date("Y-m-d",strtotime($_REQUEST['s_date_to']))."' ";
$q = "SELECT c.*,o.*,o.code as code FROM customer_orders o Left Join members c ON c.code=o.customer_code WHERE o.is_deleted=0 $where ORDER BY o.code desc ";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
Sr. #
Order Number
Order Date
Customer Code
Name
Email
Mobile
Amount
Created By
Shiping Status
>
Pending';
else
echo 'Done';?>
0)
{
?>
Pagination Finish
}
break;
case 'add_edit':
{
$i =3;
$key = array_keys($_REQUEST);
$n = count($_REQUEST);
while($i<=($n))
{
$s = $s."&".$key[$i]."=".$_REQUEST[$key[$i]]."";
$i++;
}
require_once("index.class.php");
$objpl=new General();
$objpl->add_edit(fetch_details(TABLE_NAME,'code',$_REQUEST['id']),$_REQUEST);
}
break;
case 'send_otp':
{
$data = $_REQUEST;
/* echo '';
print_r($_REQUEST);
echo ' ';*/
if($data['policy']<=0)
{
echo 'Please select a customer and his/her associated Policy ';
return;
}
if(trim($data['receiver_name'])=="")
{
echo 'Please Enter Receiver Name ';
return;
}
if($data['t_amount']<=0 or $data['order_total_payable']<=0 )
{
echo 'Please Select Product! ';
return;
}
$sql99 = "Select * from customer_booking cb where code = '".trim($data['policy'])."' and cb.payment_status=2 ";
$res99 = mysql_query($sql99);
$rows99 = mysql_fetch_assoc($res99);
if($rows99['code']<=0)
{
echo 'Error: Wrong Policy Selected
';
return;
}
//Work Stoped
$auth_code = find_ID_ran();
/*$sql = "Select * from mobile_confirm_sale where m_to='".$rows99['customer_code']."' and m_for='".$rows99['code']."' and t_amount='".$data['t_amount']."',order_total_payable='".$data['order_total_payable']."' and used='' order by code desc limit 0,1";
$rr = mysql_query($sql);
$old_d = mysql_fetch_assoc($rr);
if($old_d['code']>0)
{
$d1 = $old_d['date_b'];
$d2 = date("Y-m-d H:i:s",strtotime("-2 minutes"));
if($d1>$d2)
{
echo 'Auth code already sent to mobile no '.$data['mobile'].' please wait for at least 2 minutes. ';
return;
}
}*/
$sql = "Insert into mobile_confirm_sale SET mobile='".$data['mobile']."', auth_code='".$auth_code."',m_to='".$rows99['customer_code']."',m_for='".$rows99['code']."',t_amount='".$data['t_amount']."',order_total_payable='".$data['order_total_payable']."' ";
if(mysql_query($sql))
{
sms_jshine($rows999['customer_code'],$data['mobile'],"Hello, Mr. ".$data['receiver_name']." want to receive a product for youe Policy Number ".$rows99['order_no'].", Your Sale Total is : Rs. ".$data['t_amount'].", where you have to pay Rs. ".$data['order_total_payable'].", Your OTP is ".$auth_code.", kindly do not share this code with unauthorized or unknown person.");
//echo $curl_scraped_page;
echo 'OTP sent to mobile no '.$data['mobile'].' ';
}
}break;
case 'save_key':
{
$data = $_POST;
$data['confirm'] = $_REQUEST['confirm'];
if($data['customer_type']=='new')
{
$q = "SELECT * FROM customer where mobile='".trim($data['mobile'])."' ";
$qr = mysql_query($q);
$re2 = mysql_fetch_assoc($qr);
if($re2['code']>0)
{
echo '0|0|Error: Mobile Number is already registered!
';
return;
}
else
{
if($data['confirm']>0)
{
$mce = '9'.substr(time(),3,11);
$ss = "INSERT INTO customer SET
name ='".$data['name']."'
,mobile ='".trim($data['mobile'])."'
,add_1 ='".trim($data['add_1'])."'
,add_2 ='".trim($data['add_2'])."'
,password ='".(rand(2323,234234))."'
,member_code ='".$mce."'
,status ='1'
,country ='".display_feild('bm_countries_for_ip','code','countries_name',trim($data['country']))."'
,state ='".display_feild('bm_states','code','state_name',trim($data['state']))."'
,city ='".display_feild('bm_districts','code','district_name',trim($data['city']))."'
,pin_code ='".trim($data['pin_code'])."'
";
//echo $ss;
if(mysql_query($ss))
$data['customer_code'] = $mce;
else
{
echo '0|0|Error: while Saving new Customer
';
return;
}
}
//
}
}
if($data['confirm']>0)
{
}
$q = "SELECT * FROM customer where member_code='".$data['customer_code']."' ";
$qr = mysql_query($q);
$customer_details = $re2 = mysql_fetch_assoc($qr);
if($re2['code']<=0)
{
echo '0|0|Error: Wrong Customer Code
';
return;
}
//echo '0|0|';
//print_r($data);
$dis = 0;
$rm = 0;
$data['discount_name'] = array();
if(count($data['policy'])>0)
foreach($data['policy'] as $policy_code=>$v)
{
if($v>0)
{
$sql99 = "Select cb.* from customer_booking cb,customer c where cb.code = '".trim($policy_code)."' and cb.payment_status=2 AND c.member_code='".$data['customer_code']."' AND cb.customer_code = c.code ";
$res99 = mysql_query($sql99);
$rows99 = mysql_fetch_assoc($res99);
if($rows99['code']<=0)
{
echo '0|0|Error: Wrong Policy Selected
';
return;
}else{
$rmmm = value_remaining($rows99['code']);
//echo 'R : '.$rm;
if($v>$rmmm)
{
echo '0|0|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 '0|0|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 '0|0|Error: Please Select State
';
return;
}
$cgst = 0;
$sgst = 0;
$igst = 0;
if(strtolower(trim($data['state']))=='punjab')
{
$cgst = 1.5;
$sgst = 1.5;
}else
$igst = 3;
$total = 0;
$total_tax = 0;
$total_making = 0;
$mastet_t = 0;
$t_discount = 0;
$i = 1;
$p = array();
$pro = array();
while($i<=10)
{
if($data['product_code_'.$i]>0 and $data['product_qty_'.$i]>0 and $data['product_price_'.$i]>0 and $data['product_total_'.$i]>0)
{
$total+=($data['product_qty_'.$i] * $data['product_price_'.$i]);
if (in_array($data['product_code_'.$i], $p))
{
echo '0|0|Error: You can not order same product twice
';
return;
}
if($data['product_qty_'.$i]<>1)
{
echo '0|0|Error: Product Quantity can only be 1
';
return;
}
$p[] = $data['product_code_'.$i];
$sql = "SELECT p.*,dt.title as d_name,mt.name as m_name ,gt.title as g_name,p.product_id FROM product p
INNER JOIN diamond_type dt ON product_id ='".$data['product_code_'.$i]."' AND dt.code=diamond_type_default
INNER JOIN metal_type mt ON mt.code=metal_type_default
LEFT JOIN gems_type gt ON gt.code=gems_type_default
WHERE product_sale_inside=1 and p.is_deleted =0 ORDER BY product_name ";
$query = mysql_query($sql);
$result = mysql_fetch_assoc($query);
if($result['product_id']<=0)
{
echo '0|0|Error: Please reselect the product seems wrong product selected
';
return;
}
if($result['product_sold_out']==1)
{
echo '0|0|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.= 'Discount ('.$result['discount_percantage'].'%) = '.number_format($dis,2).' --- '.$t.' ';
}else
$t2 = $t;
$discount_amt = $dis;
$t_discount+=$discount_amt;
$t_cgst = round(($t*$cgst)/100,2);
$t_sgst = round(($t*$sgst)/100,2);
$t_igst = round(($t*$igst)/100,2);
$tax = ($t_cgst+$t_sgst+$t_igst);
$tt_cgst+=$t_cgst;
$tt_sgst+=$t_sgst;
$tt_igst+=$t_igst;
$t_cgst2 = round(($t2*$cgst)/100,2);
$t_sgst2 = round(($t2*$sgst)/100,2);
$t_igst2 = round(($t2*$igst)/100,2);
$tax2 = ($t_cgst2+$t_sgst2+$t_igst2);
$tt_cgst2+=$t_cgst2;
$tt_sgst2+=$t_sgst2;
$tt_igst2+=$t_igst2;
$mastet_t+= $t;
$total_tax+=$tax2;
$total_bd = round($t + $tax);
$total = round($t2 + $tax2);
$total_total+=$total;
$pro[] = array(
'code'=>$result['product_id']
,'name'=>$result['product_name']
,'size'=>$result['product_size_default']
,'sku'=>$result['product_ccode']
,'certificate_number'=>$result['certificate_number']
,'diamond_name'=>$result['d_name']
,'diamond_total_weight'=>$result['diamond_total_weight']
,'diamond_rate'=>$a1
,'diamond_total'=>$a
,'diamond_total'=>$a
,'metal_name'=>$result['m_name']
,'metal_total_weight'=>$result['metal_weight']
,'metal_rate'=>$b1
,'discount'=>$result['discount_percantage']
,'discount_amt'=>$discount_amt
,'gem_name'=>$result['g_name']
,'gem_total_weight'=>$result['gems_size']
,'gem_rate'=>$c
,'gem_total'=>$c
,'making_charges'=>$d
,'tax'=>$tax
,'t_cgst'=>$t_cgst2
,'t_sgst'=>$t_sgst2
,'t_igst'=>$t_igst2
,'cgst'=>$cgst
,'sgst'=>$sgst
,'igst'=>$igst
,'total'=>$t
,'total_all'=>($t*$data['product_qty_'.$i])
,'qty'=>($data['product_qty_'.$i])
);
if($total<>round($data['product_price_'.$i]))
{
echo '0|0|Error: Please reselect the product seems there is change in product price. Total ='.$total.' & Product price is = '.round($data['product_price_'.$i]).'
';
return;
}
}$i++;
}
$total = $total_total;
if($total<=0)
{
echo 'Error: Please select Products
';;
return;
}
if($total<$rm)
{
echo 'Error: Can not use Policy credit more than Order total
';;
return;
}
//NEw Total
//echo 'Error: '.$total.'
';;
$tt_cgst2 = 0;
$tt_sgst2 = 0;
$tt_igst2 = 0;
if($cgst>0)
$tt_cgst2 = round($tax2/2,2);
if($sgst>0)
$tt_sgst2 = round($tax2/2,2);
if($igst>0)
$tt_igst2 = round($tax2,2);
$total = ($total_bt);
//die();
/*echo 'Error: '.$tt_igst2.'
';die();
*/
$rem = $total;
if($data['payment']=='cash')
$pmode= 'by CASH';
else
$pmode= ' via DD/Cheque';
if($data['product_taking_for']=='other')
{
echo $sql = "select * FROM mobile_confirm_sale where mobile='".$data['mobile']."' AND auth_code='".$data['otp']."' AND m_to='".$rows99['customer_code']."' AND m_for='".$rows99['code']."' AND t_amount='".$rem."' AND order_total_payable='".$total."' ";
$rr = mysql_query($sql);
$ro_code = mysql_fetch_assoc($rr);
if($ro_code['code']>0 and $ro_v['used']=="")
{
}else
{
echo 'Error: Wrong auth Code
';;
return;
}
}
if($data['confirm']<=0)
{
//echo '0|99|Rs. '.number_format($rem+$tax2,2).' '.$pmode.'
echo '0|99|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 .= ",shiping ='".trim($data['shipping'])."'";
$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 '