'.$rows['order_no'].' isNew '.$isNew;
// die('****');
$sql33 = "select * FROM consolidate_policy where policy_code='".$rows['code']."' and paid=1 order by code desc limit 0,1";
$r8 = mysql_query($sql33);
$payment =array();
while($payment_re = mysql_fetch_assoc($r8))
{
$payment['last_date'] = $payment_re['rec_date'];
if($payment_re['received_by']>0 or $payment_re['received_by_name']=='' or $payment_re['payment_type']=='' or $payment_re['payment_type']=='cash')
$mode = 'Cash';
elseif($payment_re['received_by_name']=='eWallet' or $payment_re['received_by_name']=='ew')
$mode = 'E-Wallet';
elseif($payment_re['received_by_name']=='Bank')
$mode = $payment_re['received_by_name'].'-'.$payment_re['bank_name'];
else
$mode = $payment_re['received_by_name'];
$payment['last_payment_mode'] = $mode;
$payment['last_paid_ins'] = $payment_re['ins'];
$payment['last_amt'] = $payment_re['amt'];
$payment['last_rec'] = $payment_re['received_by_name'];
$payment['last_date_cp'] = $payment_re['rec_date'];
}
/* echo '';
print_r($payment);
echo ' '; */
$sql = "select * from draw where draw_date<='".date("Y-m-d")."' and not m_code=0 order by code desc limit 0,1";
$r = mysql_query($sql);
$ro = mysql_fetch_assoc($r);
//echo '';
$out .='--Select-- ';
$out .='Root ';
while($result=mysql_fetch_array($res))
{
$diabbled = '';
//echo '__'.$result[$displayName].' ';
else
$out .='__'.$result[$displayName].' ';
$qry2 = "SELECT * FROM ".$table." WHERE parent_id='".$result[$value]."' and is_deleted=0 and panel_2=1 order by sort_id";
// echo '_____'.$result2[$displayName].' ';
else
$out .='_____'.$result2[$displayName].' ';
}
}
$out .= ' ';
return $out;
}
function find_sort_id_max_gn($tb)
{
$sql = "SELECT max(sort_id) as mm from $tb";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
if($rows['mm'])
return $rows['mm'];
else
return 0;
}
function add_sale_team($sale_emp,$policy_code,$table,$col)
{
//ini_set('memory_limit', '-1');
if($sale_emp['admin_id']>0)
{
$s= "INSERT INTO ".$table." SET
designation_code='".$sale_emp['designation']."'
,admin_id='".$sale_emp['admin_id']."'
,admin_name='".$sale_emp['name']."'
,".$col."='".$policy_code."'";
mysql_query($s);
$sql = "SELECT s.*,designation_name FROM admin_users s INNER JOIN designation b ON s.is_deleted=0 and s.admin_id = '".$sale_emp['designation_reporting']."' and b.code=s.designation";
//echo '-->'.$sql;
$res = mysql_query($sql);
$sale_emp = mysql_fetch_assoc($res);
if($sale_emp['admin_id']>0)
{
//add_sale_team($sale_emp,$policy_code,$table,$col);
}
}
}
// fuction created by kantsverma on 241221 to avoid conflict in bookin for 500 errro due to stuck in loop
function booking_add_sale_team($sale_emp,$policy_code,$table,$col)
{
if($sale_emp['admin_id']>0)
{
$s= "INSERT INTO ".$table." SET designation_code='".$sale_emp['designation']."'
,admin_id='".$sale_emp['admin_id']."'
,admin_name='".$sale_emp['name']."'
,".$col."='".$policy_code."'";
//echo ''.$d.'
';
}
function bill_status($pid)
{
$sql = "SELECT * from consolidate_policy_used where policy_code='".$pid."'";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
if($rows['code']>0)
return 'Billed
';
else
return 'Unbilled
';
}
function booking_status($status)
{
if($status=='9'){
$style = "background-color:#39b055";
}else if($status=='1'){
$style = "background-color:#2980B9";
}else if($status=='2'){
$style = "background-color:#8E44AD";
}else if($status=='3'){
$style = "background-color:#FFC300";
}else if($status=='4'){
$style = "background-color:#FF5733";
}else if($status=='5'){
$style = "background-color:#f80606";
}else if($status=='6'){
$style = "background-color:#17A2B8";
}else{
$style = "background-color:#f80606";
}
$d = display_feild('booking_status','name','code',$status);
echo ''.$d.'
';
}
function create_log($table_name,$data,$code='code')
{
$response = array();
if($data['task']=='delete_row')
$msg = 'Record Deleted';
else
{
if($data['task2']=="Add")
$msg = 'New Record';
else
$msg = 'Record Updated';
}
$sql_x1 = "select * from ".$table_name." where ".$code."='".$data['id']."'";
$r_x1 = mysql_query($sql_x1);
$currect_d = mysql_fetch_assoc($r_x1);
$text = '';
$sql_x = "DESCRIBE ".$table_name." ";
$r_x = mysql_query($sql_x);
while($row_x=mysql_fetch_assoc($r_x))
{
$text.= $row_x['Field'].'='.$currect_d[$row_x['Field']].',';
}
$s2 = "INSERT INTO log_users SET
admin_code='".$_SESSION['admin_code']."'
,admin_name='".$_SESSION['admin_name']."'
,admin_ip='".$_SERVER['REMOTE_ADDR']."'
,log_data='".$text."'
,table_name='".$table_name."'
,action_taken='".$msg."'
";
//echo '';
print_r($result);
echo ' ';
//echo '------------';
//$result2 = json_decode($result,true);
//print_r($result2 );*/
$remarks_gateway = 'Amazon';
//die();
}else
{
$remarks_gateway = 'smsdukan';
//$url = 'http://sms.smsdukan.in/app/smsapi/index.php?key=258FB210510A42&campaign=189&routeid=100344&type=text&contacts='.$sms_Mobile.'&senderid='.$sender_id.'&msg='.$encoded_message;
if (function_exists('curl_init')) {
$api_key = '258FB210510A42';
$contacts = $sms_Mobile;
$from = $sender_id;
$sms_text = $encoded_message;
$template_id = $templateid;
$url = "http://sms.smsdukan.in/app/smsapi/index.php?key=".$api_key."&campaign=189&routeid=100344&type=text&contacts=".$contacts."&senderid=".$from."&msg=".$sms_text."&template_id=".$template_id;
//Submit to server
$response = file_get_contents( $api_url);
// initialize a new curl resource
$ch = curl_init();
// set the url to fetch
curl_setopt($ch, CURLOPT_URL, $url);
// don't give me the headers just the content
curl_setopt($ch, CURLOPT_HEADER, 0);
// return the value instead of printing the response to browser
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// use a user agent to mimic a browser
//curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0');
$content = curl_exec($ch);
//$content;
// remember to always close the session and free all resources
curl_close($ch);
} else {
// curl library is not installed so we better use something else
echo 'OOPS! Your SMS Server doesnot support the required parameters, for more information contact Your Administration. ';
}
}
if($save==1)
{
$s = "INSERT INTO sms_details ";
$s .= "SET mobile_no='".$mobile."'";
$s .= ",m_code='".($cust_id)."'";
$s .= ",sender_id='".($sender_id)."'";
$s .= ",remarks_gateway='".($remarks_gateway)."'";
$s .= ",text_message='".mysql_real_escape_string(trim($msg))."'";
$s .= ",sent_date_time='".date('Y-m-d H:i:s',time())."'";
mysql_query($s);
}
}
}
function sms_jshine($cust_id,$mobile,$msg,$save=1,$sender_id='jshine')
{
$sender_id='jshine';
$sms_Mobile = trim($mobile);
$sms_Msg = urldecode(str_replace(' ','',$msg));
/* $s = "INSERT INTO sms_details ";
$s .= "SET mobile_no='".$mobile."'";
$s .= ",m_code='".($cust_id)."'";
$s .= ",sender_id='".($sender_id)."'";
$s .= ",text_message='".mysql_real_escape_string(trim($msg))."'";
mysql_query($s);
*/
if (!empty($sms_Mobile) && !empty($sms_Msg)) {
$encoded_message = urlencode($sms_Msg);
$sql_x1 = "select * from sms_gateway order by code desc limit 0,1";
$r_x1 = mysql_query($sql_x1);
$sms_gateway = mysql_fetch_assoc($r_x1);
if($sms_gateway['gateway']=='amazon')
{
$no = '+91'.$sms_Mobile;
$option = array('version' => 'latest','region' => 'ap-south-1','debug'=>false,
'credentials' => array(
'key' => 'AKIARHXW6OMERXM6KMRQ',
'secret' => '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',
)
);
$client = new PinpointClient($option);
$result = $client->sendMessages(array(
'ApplicationId' => '554899cd7d584b36b63cc182116b9972',
'MessageRequest' => array(
'Addresses' => array(
$no=> array(
'ChannelType'=> 'SMS'
)
)
,
'MessageConfiguration' => array(
'SMSMessage' => array(
'Body' => $sms_Msg,
'MessageType' => 'TRANSACTIONAL'
)
)
)
));
echo '';
print_r($result);
echo ' ';
//echo '------------';
//$result2 = json_decode($result,true);
//print_r($result2 );*/
$remarks_gateway = 'Amazon';
//die();
}else
{
$remarks_gateway = 'smsdukan';
$url = 'http://sms.smsdukan.in/app/smsapi/index.php?key=258FB210510A42&campaign=189&routeid=100344&type=text&contacts='.$sms_Mobile.'&senderid='.$sender_id.'&msg='.$encoded_message;
if (function_exists('curl_init')) {
// initialize a new curl resource
$ch = curl_init();
// set the url to fetch
curl_setopt($ch, CURLOPT_URL, $url);
// don't give me the headers just the content
curl_setopt($ch, CURLOPT_HEADER, 0);
// return the value instead of printing the response to browser
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// use a user agent to mimic a browser
//curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0');
$content = curl_exec($ch);
//$content;
// remember to always close the session and free all resources
curl_close($ch);
} else {
// curl library is not installed so we better use something else
echo 'OOPS! Your SMS Server doesnot support the required parameters, for more information contact Your Administration. ';
}
}
if($save==1)
{
$s = "INSERT INTO sms_details ";
$s .= "SET mobile_no='".$mobile."'";
$s .= ",m_code='".($cust_id)."'";
$s .= ",sender_id='".($sender_id)."'";
$s .= ",remarks_gateway='".($remarks_gateway)."'";
$s .= ",text_message='".mysql_real_escape_string(trim($msg))."'";
$s .= ",sent_date_time='".date('Y-m-d H:i:s',time())."'";
mysql_query($s);
}
}
}
function sms_jshine1($cust_id,$mobile,$msg,$save=1,$sender_id='JSHINE')
{
$sms_Mobile = trim($mobile);
$sms_Msg = urldecode(str_replace(' ','',$msg));
if (!empty($sms_Mobile) && !empty($sms_Msg)) {
$encoded_message = urlencode($sms_Msg);
$sql_x1 = "select * from sms_gateway order by code desc limit 0,1";
$r_x1 = mysql_query($sql_x1);
$sms_gateway = mysql_fetch_assoc($r_x1);
if($sms_gateway['gateway']=='amazon')
{
$no = '+91'.$sms_Mobile;
$option = array('version' => 'latest','region' => 'ap-south-1','debug'=>false,
'credentials' => array(
'key' => 'AKIARHXW6OMERXM6KMRQ',
'secret' => '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',
)
);
$client = new PinpointClient($option);
$result = $client->sendMessages(array(
'ApplicationId' => '554899cd7d584b36b63cc182116b9972',
'MessageRequest' => array(
'Addresses' => array(
$no=> array(
'ChannelType'=> 'SMS'
)
)
,
'MessageConfiguration' => array(
'SMSMessage' => array(
'Body' => $sms_Msg,
'MessageType' => 'TRANSACTIONAL'
)
)
)
));
$remarks_gateway = 'Amazon';
}else
{
$remarks_gateway = 'smsdukan';
$url = 'http://sms.smsdukan.in/app/smsapi/index.php?key=258FB210510A42&campaign=189&routeid=100344&type=text&contacts='.$sms_Mobile.'&senderid='.$sender_id.'&msg='.$encoded_message;
// echo urldecode($url);
if (function_exists('curl_init')) {
// initialize a new curl resource
$ch = curl_init();
// set the url to fetch
curl_setopt($ch, CURLOPT_URL, $url);
// don't give me the headers just the content
curl_setopt($ch, CURLOPT_HEADER, 0);
// return the value instead of printing the response to browser
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// use a user agent to mimic a browser
curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0');
$content = curl_exec($ch);
// echo $content;
// remember to always close the session and free all resources
curl_close($ch);
}
}
if($save==1)
{
$s = "INSERT INTO sms_details ";
$s .= "SET mobile_no='".$mobile."'";
$s .= ",m_code='".($cust_id)."'";
$s .= ",sender_id='".($sender_id)."'";
$s .= ",remarks_gateway='".($remarks_gateway)."'";
$s .= ",text_message='".mysql_real_escape_string(trim($msg))."'";
mysql_query($s);
}
}
}
function auto_email($sub,$to,$msg,$from,$customer_code)
{
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
$headers .= "From: JShine<".$from.">\r\n";
$msg = str_replace("Â",'',$msg);
$msg = str_replace("http://http:",'http:',$msg);
$message = '
'.$msg.'
';
$s = "INSERT INTO email_log";
$s .= " SET email_address='".$to."'";
//$s .= ",customer_code='".($customer_code)."'";
$s .= ",subject='".($sub)."'";
$s .= ",email_from='".($from)."'";
$s .= ",c_date='".date("Y-m-d H:i:s")."'";
$s .= ",msg='".mysql_real_escape_string(trim($message))."'";
mysql_query($s);
/*echo 'Upgrade Now ';
}
return $star;
}
function sponsor_datails($id)
{
$qr9="select s.* from customer c INNER JOIN customer s ON c.code='".$id."' AND c.actual_sponsor=s.code "; //='".$mcode."' ";
// echo "'.$rob['designation'].' ';
}
else
return 'Customer ';
}
function designation_under($id,$designation)
{
$qr9="select count(*) as c from customer c,level l where designation_code='".$designation."' AND under='".$id."' and l.m_code=c.code ";
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
return $ro['c'];
}
function designation_under_direct($id,$designation)
{
$qr9="select count(*) as c from customer c where designation_code='".$designation."' AND sponsor_code='".$id."' ";
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
//echo '
Rank
Target
Status
How I can achive?
'.$rob['designation'].'';?>
=$i)?'
".($rob['rtarget']-$pbv)." BVs more";
}else
echo '".($rob['rtarget']-$pbv)." TBVs more ";
}else
echo '".($rob['rtarget']-$pbv)." ".$r_6['designation']." more ";
}else
echo '
Note:- BVs = Personal BVs, TBVs = Personal/Team BVs
0)
{?>
Code :
Name :
Total Order(s) :
Rank :
Personal BV(s) :
Star (PIN) :
Personal/Team BV(s) :
0)
{
$sh = 0;
$i=1;
foreach($_SESSION['a'] as $s)
{
$s['product_id'] = $s['id'];
//product_details_custom($id,$size='',$metal='',$diamond='',$gem='');
$t=($s['qty']*$s['price']); $tv+=($s['qty']*$s['vat']);
$total+=$t;
$i++;
}
$price['vat'] = $tv;
$price['coupon_value'] = $_SESSION['coupon_value'];
$price['shipping'] = $_SESSION['shipping'];
$price['total'] = $total-$_SESSION['coupon_value'];
}
return $price;
}
function status_today_g_find($id)
{
$sql = "select level from member_level where m_code='".$id."' order by code desc limit 0 , 1";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
return $result['level'];
}
function total_ewallet($id)
{
$sql = "select sum(amt) as amt from ewallet_consolidate where userid='".$id."' ";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
return (int)$result['amt'];
}
function value_remaining($id)
{
$sql = "select sum(amt) as amt,count(*) as c from consolidate_policy where policy_code='".$id."' and paid=1";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
$sql = "select sum(amt) as amt,count(*) as c from consolidate_policy_used where policy_code='".$id."' and paid=1";
$res = mysql_query($sql);
$result2 = mysql_fetch_assoc($res);
return ($result['amt'] - $result2['amt']);
}
function value_remaining_gala($id)
{
$sql = "select sum(amt) as amt,count(*) as c from consolidate_policy where policy_code='".$id."' and paid=1";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
$sql = "select sum(amt) as amt,count(*) as c from gala_consolidate_policy_used where policy_code='".$id."' and paid=1";
$res = mysql_query($sql);
$result2 = mysql_fetch_assoc($res);
return ($result['amt'] - $result2['amt']);
}
function payment_first($policy_booklet_no,$payment_update_info)
{
$q = "SELECT * FROM consolidate_policy WHERE policy_booklet_no = '".$policy_booklet_no."' and ins=1 and paid=0";
$res = mysql_query($q);
$r = mysql_fetch_assoc($res);
$sql2 = "SELECT * FROM customer_booking WHERE code='".$r['policy_code']."'";
$ro2 = mysql_query($sql2);
$booking = $r2 = mysql_fetch_assoc($ro2);
$sql2 = "SELECT * FROM customer WHERE code='".$r2['customer_code']."'";
$ro_c2 = mysql_query($sql2);
$customer = mysql_fetch_assoc($ro_c2);
$sql_nn2 = " SELECT * FROM consolidate_policy where policy_booklet_no = '".$policy_booklet_no."' and ins=1 and paid=0 ";
//echo '||'.$sql_nn2;die;
$rc_nn2 = mysql_query($sql_nn2);
while($cust_d2 = mysql_fetch_assoc($rc_nn2))
{
$s1 = "INSERT INTO consolidate_payment ";
$s1 .= " SET remarks = '".$cust_d2['remarks']."'";
$s1 .= " , policy_code = '".$cust_d2['vno']."' ";
$s1 .= " , receipt_number = '".$cust_d2['receipt_number']."' ";
$s1 .= " , receipt_number2 = '".$cust_d2['receipt_number2']."' ";
//$s1 .= " , ins = '".($nn)."' ";
$s1 .= " , ins = '1' ";
$s1 .= " , paid = '1' ";
$s1 .= " , amt = '".round($cust_d2['amt'],2)."' ";
$s1 .= " , policy_booklet_no = '".$cust_d2['policy_booklet_no']."' ";
$s1 .= " , type = 'INS' ";
$s1 .= " , p_type = 'Auto Genrated333' ";
$s1 .= " , vno = '".($cust_d2['vno'])."' ";
$s1 .= " , received_by_name = '".$cust_d2['received_by_name']."' ";
$s1 .= " , date = '".date("Y-m-d")."' ";
$s1 .= " , rec_date = '".date("Y-m-d")."' ";
$s1 .= " , remarks_admin = '".$cust_d2['remarks_admin']."' ";
mysql_query($s1);
$pid = mysql_insert_id();
}
$data['receipt_number'] = '';
/*$s = "Update consolidate_policy ";
$s .= "SET rec_date='".date("Y-m-d")."'";
$s .= ",remarks_admin='Payment received ".$r2['payment_remark']."'";
$s .= ",receipt_number='".$data['receipt_number']."'";
$s .= ",received_by=''";
$s .= ",received_by_name='".$r2['payment_type']."'";
$s .= ", paid='1'";
$s .= " WHERE code='".$r['code']."'";
if(mysql_query($s))
{*/
$s = "Update consolidate_payment ";
$s .= "SET date='".date("Y-m-d")."'";
$s .= ",remarks_admin='Payment received ".$payment_update_info['payment_remark']."'";
//$s .= ",receipt_number='".$data['receipt_number']."'";
$s .= ",receipt_number='".$r['receipt_number']."'";
$s .= ",admin_id='".$payment_update_info['admin_id']."'";
if($payment_update_info['payment_type']=='Cash')
{
$s .= ",received_by='".$payment_update_info['admin_id']."'";
$s .= ",received_by_name='".$payment_update_info['admin_name']."'";
}
else
{//$s .= ",received_by='".ucwords($data['payment_type'])."'";
$s .= ",received_by_name='".ucwords($payment_update_info['payment_type'])."'";
$s .= ",paytm_transaction_no='".$payment_update_info['paytm_transaction_no']."'";
$s .= ",bank_transaction_no='".$payment_update_info['bank_transaction_no']."'";
$s .= ",bank_name='".$payment_update_info['bank_name']."'";
$s .= ",bank_t_type='".$payment_update_info['bank_t_type']."'";
}
$s .= ",payment_type='".$payment_update_info['payment_type']."'";
$s .= ", paid='1'";
$s .= " WHERE code='".$pid."'";
mysql_query($s);
if($r['receipt_number']=="")
{
$pre_fix = 'R/'.date("my").'/';
$sql44 = "SELECT max(receipt_number2) as consolidate_payment FROM consolidate_payment WHERE receipt_number like '".$pre_fix."%'";
$ro44 = mysql_query($sql44);
$r44 = mysql_fetch_assoc($ro44);
$next = ($r44['consolidate_payment']+1);
//if($data['receipt_number']<=20000)
$data['receipt_number'] = $pre_fix.$next;
$s = "Update consolidate_payment ";
$s .= "SET receipt_number='".$data['receipt_number']."'";
$s .= ",receipt_number2='".$next."'";
$s .= " WHERE code='".$pid."'";
//echo $s;
mysql_query($s);
update_payment_for_policy_new($pid);
$sql = "select * from sms_template where code='9' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
$ro_4['template'] = str_replace("[CUSTOMER_ID]",$customer['member_code'],$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",ucwords($booking['bookfor_name']),$ro_4['template']);
$ro_4['template'] = str_replace("[BOOKING_AMOUNT]",$booking['net_amount'],$ro_4['template']);
$ro_4['template'] = str_replace("[BOOKING_NO]",$booking['order_no'],$ro_4['template']);
$ro_4['template'] = str_replace("[PAYMENT_RECEIPT_NO]",$data['receipt_number'],$ro_4['template']);
$ro_4['template'] = str_replace("[TOTAL_BOOKING_PAYMENT]",total_payment_policy($booking['code']),$ro_4['template']);
$ro_4['template'] = str_replace("[P_POINTS]",total_points_customer($customer['code']),$ro_4['template']);
$sql441 = "SELECT scheme_name FROM schemes WHERE code = ".$booking['scheme'];
$ro441 = mysql_query($sql441);
$r441 = mysql_fetch_assoc($ro441);
$scheme_name = $r441['scheme_name'];
$ro_4['template'] = str_replace("[SCHEME_NAME]",$scheme_name,$ro_4['template']);
$templateId = $ro_4['templateid'];
// //echo '1|1|'.$customer['code'].' '.$customer['mobile'].' '.$ro_4['template'].' '.$ro_4['sender_id'];exit();
// sms_jshine_with_templateid($customer['code'],$customer['mobile'],$ro_4['template'],1,$ro_4['sender_id'],$templateId);
// if($customer['mobile']<>$r2['bookfor_mobile'])
// sms_jshine_with_templateid($customer['code'],$r2['bookfor_mobile'],$ro_4['template'],1,$ro_4['sender_id'],$templateId);
sms_jshine_with_templateid($customer['code'],$customer['mobile'],$ro_4['template'],1,$ro_4['sender_id'],$templateId);
if($booking['bookfor_mobile']<>$customer['mobile'])
sms_jshine_with_templateid($customer['code'],$booking['bookfor_mobile'],$ro_4['template'],1,$ro_4['sender_id'],$templateId);
}
return 'Receipt Number : '.$data['receipt_number'];
/*}*/
}
function total_points_customer($id)
{
$s = "select sum(amt) as amt from pw_consolidate where userid='".$id."'";
$r = mysql_query($s);
$ro = mysql_fetch_assoc($r);
return round($ro['amt'],2);
}
function total_payment_policy($id)
{
$s = "select sum(amt) as amt from consolidate_payment where policy_code='".$id."' and paid=1";
$r = mysql_query($s);
$ro = mysql_fetch_assoc($r);
return $ro['amt'];
}
/**
* Function: update_payment_detail_for_old_policy() used to avoid the duplicate or overide old entry of policy
* Date: 06-09-22
* Author: kantsverma
* @return \Illuminate\Http\Response
*/
function update_payment_detail_for_old_policy($payment_id)
{
//echo '';
//print_r($payment['code']);
//echo '';
// paymentId $payment['code']
//die();
$rno = $payment['receipt_number'];
$sql = "select sum(payment_amount) as amt from consolidate_policy where policy_code='".$payment['policy_code']."' and payment_id='".$payment['code']."' and paid=1 ";
//echo ''.$status.'
';
}else{
return 'Unbilled
';
}
}
/*#############################
# Method: getRewardPoints() is used to get total no of reward points of customer by customer id
# Author: Kantsverma
# Date: 09-10-22
################################*/
function getRewardPoints($customerId)
{
$sql = "SELECT code, vno, date, userid, amt, type, remarks, status, created_at FROM pw_consolidate WHERE userid='".$customerId."'";
$result = mysql_query($sql);
$totalRewards = 0;
while ($rows=mysql_fetch_array($result))
{
//echo 'Welcome To Jshine Jewellery
For what reason would it be advisable for me to think about business content? That might be little bit risky to have crew member like them.
Welcome to Jshine Souk Pvt. Ltd.
".$msg."
Best regards,
We have wide range of uniqe design.
SCO. 53-54, Ground Floor, Sector-66A,
";
//echo ' 
';
$j2++;
}
if($rows['pin_type']==0)
{
$task='upgrade_customer';
$star = '
':'';?>
';
}
elseif($rob['rtype']=='T')
{
$pbv = personal_cum_team_bv($id);
if($pbv<=$rob['rtarget'])
{
echo "You required ".($rob['rtarget']-$pbv)." TBVs more";
}else
echo '
'.$rr['wb_name'];
}
}
function find_position_most_depth2($id,$p)
{
$qr9="select m_code FROM level where under='".$id."' and side='".$p."' and depth = 1";
// echo "
