';
//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.
';
//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 ' TO : '.$to;
echo ' Sub : '.$sub;
echo ' MSG : '.$msg2;
echo ' HEader : '.$headers;
*/
$result = @mail($to,$sub,$message,$headers);
if($result)
{
//echo '::::: SENT ';
return true;
}
}
function star_p($rows)
{
require_once("../../common_pages/enc.php");
$converter = new Encryption($_SESSION['unique_enc_id']);
$j2 = 1;
$star = '';
while($j2<= $rows['pin_type'])
{
$star.= '';
$j2++;
}
if($rows['pin_type']==0)
{
$task='upgrade_customer';
$star = '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 " ".$qr9;
$re9=mysql_query($qr9);
$rows = mysql_fetch_array($re9);
if($rows['code']>0)
return $rows['customer_code'].' - '.$rows['firstname'].' '.$rows['lastname'];
}
function total_payment_received($code,$other='')
{
$qr9="select sum(amt) as c from consolidate_policy where policy_code='".$code."' ".$other; //='".$mcode."' is_deleted=0";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$rows = mysql_fetch_array($re9);
return $rows['c'];
}
function count_policy($search='',$value='')
{
if($search<>"")
$w = " AND ".$search."='".$value."' ";
$qr9="select count(*) as c from customer_booking where payment_status=2 ".$w; //='".$mcode."' is_deleted=0";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$rows = mysql_fetch_array($re9);
return $rows['c'];
}
function roi_processed($code=0,$date='')
{
if($code>0)
$w = " AND policy_code='".$code."' ";
if($date<>"")
$w .= " AND date<='".date("Y-m-d",strtotime($date))."' ";
$qr9="select sum(amt) as amt from consolidate where 1 ".$w; //='".$mcode."' ";
//echo " ".$qr9;
$re9=mysql_query($qr9);
$rows = mysql_fetch_array($re9);
return $rows['amt'];
}
function place_under_datails($id)
{
$qr9="select s.* from customer c INNER JOIN customer s ON c.code='".$id."' AND c.place_under=s.code "; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$rows = mysql_fetch_array($re9);
if($rows['code']>0)
echo $rows['customer_code'].' - '.$rows['firstname'].' '.$rows['lastname'];
}
function personal_bv($id,$sd='',$ed='')
{
if($sd<>"")
$where = " AND c_date>='".$sd."' AND c_date<='".$ed."' ";
$qr9="select sum(bv) as bv from customer_orders where payment_status=1 and customer_code='".$id."' $where"; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
return (float)$ro['bv'];
}
function shopping_points($id,$sd='',$ed='',$type='',$remarks='')
{
if($sd<>"")
$where = " AND date>='".$sd."' AND date<='".$ed."' ";
if($type<>"")
$where.= " AND type = '".$type."' ";
if($remarks<>"")
$where.= " AND remarks like '%".$remarks."%' ";
$qr9="select sum(amt) as bv from pw_consolidate where userid='".$id."' $where"; //='".$mcode."' ";
echo " ".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
return (float)$ro['bv'];
}
function orders($id)
{
$qr9="select count(*) as bv from customer_orders where payment_status=1 and customer_code='".$id."'"; //='".$mcode."' ";
//echo " ".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
return $ro['bv'];
}
function personal_cum_team_bv($id,$sd='',$ed='')
{
if($sd<>"")
$where = " AND c_date>='".$sd."' AND c_date<='".$ed."' ";
$qr9="select sum(bv) as bv from customer_orders where payment_status=1 and customer_code='".$id."' $where"; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
$qr9="select sum(bv) as bv from customer_orders inner join level ON level.m_code=customer_code where payment_status=1 and under='".$id."' $where"; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$ro2 = mysql_fetch_array($re9);
return ($ro['bv']+$ro2['bv']);
}
function personal_cum_team_bv_binary($id,$sd='',$ed='')
{
if($sd<>"")
$where = " AND c_date>='".$sd."' AND c_date<='".$ed."' ";
$qr9="select sum(bv) as bv from customer_orders o
inner join view_customer c ON c.customer_code='".$id."' and c.code=o.customer_code
where payment_status=1 $where"; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
$qr9="select sum(bv) as bv from customer_orders o
inner join view_customer c ON c.code=o.customer_code
inner join level_binary level
ON level.m_code=c.customer_code where payment_status=1 and under='".$id."' $where"; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
$ro2 = mysql_fetch_array($re9);
return ($ro['bv']+$ro2['bv']);
}
function count_binary($id,$sd='',$ed='')
{
if($sd<>"")
$where = " AND u.c_date>='".$sd."' AND u.c_date<='".date("Y-m-d",strtotime("+1 days",strtotime($ed)))."' ";
$qr9="select * from customer where code='".$id."' "; //='".$mcode."' ";
echo " ".$qr9;
$re9=mysql_query($qr9);
$cust = mysql_fetch_array($re9);
$qr9="SELECT u.*,pt.reward_point,pair_value FROM view_level_customer l INNER JOIN upgrade_pin u ON (l.under='".$cust['code']."' $where and l.customer_code=u.m_code) INNER JOIN pin_type_main pt ON pt.code = old_type";
//echo " ".$qr9;
$re9=mysql_query($qr9);
$xx = array();
$total_reward = 0;$total_pair_value = 0;
while($ro2 = mysql_fetch_array($re9))
{
$xx[$ro2['old_type']]++;
$total_reward+=$ro2['reward_point'];
$total_pair_value+=$ro2['pair_value'];
}
$qr9="SELECT u.*,pt.reward_point,pair_value FROM upgrade_pin u INNER JOIN pin_type_main pt ON m_code='".$cust['customer_code']."' $where AND pt.code = old_type";
//echo " ".$qr9;
$re9=mysql_query($qr9);
//$xx = array();
//$total_reward = 0;$total_pair_value = 0;
while($ro2 = mysql_fetch_array($re9))
{
$xx[$ro2['old_type']]++;
$total_reward+=$ro2['reward_point'];
$total_pair_value+=$ro2['pair_value'];
}
//die();
return ($total_reward.'|'.$total_pair_value.'|'.$xx[1].'|'.$xx[2].'|'.$xx[3]);
}
function personal_cum_upgrade($id,$side,$sd='',$ed='')
{
$ssr = array();
$ssr[3] = '1';
$ssr[2] = '.5';
$ssr[1] = '.25';
$ssr2 = array();
$ssr2[3] = 4;
$ssr2[2] = 2;
$ssr2[1] = 1;
$type_p = array();
$cc = 0;
$cc2 = 0;
if($sd<>"")
$where = " AND usedon>='".$sd."' AND usedon<='".$ed."' ";
/*$qr9="SELECT pt.pin_type,count(*) as c FROM pin p INNER JOIN pin_type pt ON p.type='Y' $where AND p.ptype=pt.code INNER JOIN view_customer c ON c.customer_code=p.user and c.code='".$id."' group by pt.pin_type "; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
while($ro = mysql_fetch_array($re9))
{ $cc+=($ssr[$ro['pin_type']] * $ro['c']);
$cc2+=($ssr2[$ro['pin_type']] * $ro['c']);
}*/
$qr9="SELECT pt.pin_type,count(*) as c FROM pin p INNER JOIN pin_type pt ON p.type='Y' $where AND p.ptype=pt.code INNER JOIN view_customer c ON c.customer_code=p.user INNER JOIN level_binary l ON under='".$id."' and l.side = '".$side."' AND l.m_code=c.customer_code group by pt.pin_type "; //='".$mcode."' ";
// echo " ".$qr9;
$re9=mysql_query($qr9);
while($ro2 = mysql_fetch_array($re9))
{
$cc+=($ssr[$ro2['pin_type']] * $ro2['c']);
$cc2+=($ssr2[$ro2['pin_type']] * $ro2['c']);
$cc1+=($ro2['c']);
$type_p[$ro2['pin_type']] +=$ro2['c'];
}
$c = $cc.'|'.$cc2.'|'.$cc1.'|'.$type_p[1].'|'.$type_p[2].'|'.$type_p[3];
return ($c);
}
function designation($id)
{
$qr9="select max(new_designation) as new_designation from designation_update where m_code='".$id."' order by code desc limit 0,1";
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
if($ro['new_designation']>1)
{
$qr ="select * from designations where code='".$ro['new_designation']."'";
$re =mysql_query($qr);
$rob = mysql_fetch_array($re);
return ''.$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 ' '.$qr9.' R : '.$ro['c'];
return $ro['c'];
}
function designation_status($id)
{
if($id<=0)
die('Error');
?>
';
$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 "