"")
{
$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']."'";
}
*/
if($_REQUEST['s_sms']<>"")
{
$where .= " and sms='".$_REQUEST['s_sms']."'";
}
//LEFT JOIN admin_users e ON sale_employee_code=e.admin_id
$q = "SELECT c.*,e.name as employee_name
,countries_name as country_name, district_name as city_name,state_name,c.c_date as joing_date,se.name as ssale
FROM customer c
LEFT JOIN sale_employee e ON sale_employee_code=e.code
LEFT JOIN admin_users se ON sale_employee_code_new=se.admin_id
LEFT JOIN bm_countries_for_ip ccc ON ccc.code=c.country
LEFT JOIN bm_districts dd ON dd.code=c.city
LEFT JOIN bm_states sss ON sss.code=c.state
WHERE c.is_deleted =0 and (c.c_date >='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and c.c_date<='".date("Y-m-d",strtotime("+1 days",strtotime($_REQUEST['s_date_to'])))."') $where ORDER BY c.name ";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
| Sr. # |
Bookings |
Reg.Date |
Cust ID |
Name |
Mobile |
SMS |
Area |
City |
Sales By |
Refferer |
|
>
|
|
|
|
|
|
 |
|
|
|
"98989898" and $rows['sponsor_code']<>"989898" and $rows['sponsor_code']<>0)?$rows['sponsor_code']:''; ?> |
|
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 'save_key':
{
$data=$_POST;
// echo '1|0|';
// print_r($data);echo '
';
if($data['mobile']<>'9888864504')
{
if(!check_duplicate(TABLE_NAME,'mobile',trim($data['mobile']),$data['id'],'code'," "))
{
echo '1|0|Error : Mobile Number already exist!!';
return;
}
}else
{
$data['sponsor_code'] = 0;
}
if(trim($data['email'])<>"")
{
if(!check_duplicate(TABLE_NAME,'email',trim($data['email']),$data['id'],'code'," "))
{
echo '1|0|Error : Email already exist!!';
return;
}
}
if(!check_duplicate(TABLE_NAME,'mobile',trim($data['mobile']),$data['id'],'code'," "))
{
echo '1|0|Error : Mobile Number already exist!!';
return;
}
$n = count($data);
$i = 0;
$key = array_keys($data);
$j=1;
while($i<=($n))
{
if($key[$i]<>"id" AND $key[$i]<>"photoimg" AND $key[$i]<>"id" AND $key[$i]<>"upload_pic" AND $key[$i]<>"task2" AND $key[$i]<>"task_n" AND $key[$i]<>"task" AND $key[$i]<>"picture" AND $key[$i]<>"" AND $key[$i]<>"code" AND $key[$i]<>"group_specification" AND $key[$i]<>"sponsor_name" AND $key[$i]<>"sponsor_code" AND $key[$i]<>"menu_category" AND substr($key[$i],0,5)<>"cat__" AND substr($key[$i],0,4)<>"mce_")
{
if($j==1)
{ $s = " SET $key[$i] = '".trim($data[$key[$i]])."' ";
$j=2;
}
else
$s = $s.",$key[$i] = '".mysql_real_escape_string(trim($data[$key[$i]]))."' ";
}
$i++;
}
$sql = "SELECT s.*,designation_name FROM admin_users s
INNER JOIN designation b ON s.is_deleted=0 and s.admin_id = '".trim($data['sale_employee_code_new'])."' and b.code=s.designation ";
$res = mysql_query($sql);
$sale_emp = mysql_fetch_assoc($res);
if($sale_emp['admin_id']<=0)
{
echo '1|0|Select Sale Employee!';
return;
}
// $s = $s.",code = '".$_SESSION['code']."' ";
if($data['task2']<>"Add" and $_SESSION['access_type']<2)
{
echo '1|0|Access Denied!';
return;
}
if($_REQUEST['sponsor_code']<>"")
{
$sql = "Select * from customer where status=1 and (member_code='".$_REQUEST['sponsor_code']."' or mobile='".$_REQUEST['sponsor_code']."') ";
$rr = mysql_query($sql);
$spo_row = mysql_fetch_assoc($rr);
if($spo_row['code']<=0)
{
echo "0|0|Not seems a valid Referrer Code/Referrer Mobile";return;
}else
$sponsor_code = $spo_row['member_code'];
}
if($sponsor_code>0)
{
$s = $s.",sponsor_code = '".$sponsor_code."' ";
}
if($data['task2']=="Add")
{
$data['pass'] = rand(9999,99999);
$s = $s.",cc_admin_id = '".$_SESSION["admin_code"]."' ";
$s = $s.",c_date = '".date("Y-m-d H:i:s")."' ";
$s = $s.",password = '".$data['pass']."' ";
$i =1;
$rm_code = randomPrefix_new(8);
while($i==1)
{
$qry = "SELECT * from customer where member_code='".$rm_code."' ";
$result = mysql_query($qry);
$rows = mysql_fetch_assoc($result);
if($rows['code']>0)
{
$rm_code = randomPrefix_new(7);
$i = 1;
}
else
$i = 0;
}
$s = $s.",member_code = '".$rm_code."' ";
$s = $s.",admin_id = '0' ";
$s = $s.",ip = '' ";
$s = $s.",hear_about = '0' ";
$s = $s.",hear_about_details = '' ";
$s = $s.",building_number = '' ";
$s = $s.",bob2 = '' ";
$s = $s.",landmark = '' ";
$s = $s.",street = '' ";
$s = $s.",admin_notes = '' ";
$s = $s.",pan_card = '' ";
$s = $s.",mtype = '' ";
$s = $s.",place_under = '0' ";
$s = $s.",placement_side = '0' ";
$s = $s.",side = '0' ";
$s = $s.",wb_name = '' ";
$s = $s.",wb_mobile = '' ";
$s = $s.",we_joining = '0' ";
$s = $s.",wb_password = '".rand(0,9999)."' ";
$s = $s.",we_joining_date = '".date("Y-m-d h:i:s")."' ";
$s = $s.",team = '' ";
$s = $s.",sale_employee_code = '0' ";
$s = $s.",data_source = '0' ";
$s = $s.",customer_calling_status = '0' ";
$s = $s.",d1 = '0' ";
$s = $s.",d2 = '0' ";
$s = $s.",d3 = '0' ";
$s = $s.",d4 = '0' ";
$s = $s.",d5 = '0' ";
$s = "INSERT INTO ".TABLE_NAME." ".$s;
// echo '1|0|Error : in Updation!!'.$s;
}
else
{
$s = "UPDATE ".TABLE_NAME." ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
// echo $s; die();
if(mysql_query($s))
{
$id= mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
// update customer id to new column Id
$custId = "UPDATE ".TABLE_NAME." SET id ='".$id."' WHERE code=".$id;
mysql_query($custId);
// create same user in WP database
$wpuser = "INSERT INTO js_users (user_login, user_pass, user_email, display_name,user_registered) VALUES ('".trim($data['mobile'])."', '".md5($data['pass'])."', '".trim($data['email'])."', '".trim($data['name'])."', '".date('Y-m-d H:i:s')."')";
mysql_query($wpuser);
if($data['task2']=="Add")
{
$data['id'] = $id;
//entery2top($id,$data['sponsor_code'],1,1,$pt);
add_sale_team($sale_emp,$data['id'],'customer_new_designation','customer_code');
//pw_consolidate
$points = (!empty(JSHINE_VOUCHERS) ? JSHINE_VOUCHERS : 4000);
if($points>0)
{
$s = "INSERT INTO pw_consolidate SET userid='".$id."',amt='".$points."',remarks='You have received ".$points." promotional wallets on signup',date='".date("Y-m-d")."' ";
mysql_query($s);
/*$sql = "select * from sms_template where code='5' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
$ro_4['template'] = str_replace("[CUSTOMER_ID]",$rm_code,$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",ucwords($data['name']),$ro_4['template']);
$ro_4['template'] = str_replace("[P_POINTS]",$points,$ro_4['template']);
sms_jshine($id,$data['mobile'],$ro_4['template'],1,$ro_4['sender_id']);*/
}
$sql = "select * from sms_template where code='4' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
$ro_4['template'] = str_replace("[CUSTOMER_ID]",$rm_code,$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",ucwords($data['name']),$ro_4['template']);
$ro_4['template'] = str_replace("[PASSWORD]",$data['pass'],$ro_4['template']);
$ro_4['template'] = str_replace("[P_POINTS]",$points,$ro_4['template']);
//require_once("../../common_pages/sms1.php");
$sender_id = 'JSHINE';
$sms_Mobile = trim($data['mobile']);
$sms_Msg = urldecode(str_replace(' ','',$ro_4['template']));
$encoded_message = urlencode($sms_Msg);
$templateid = $ro_4['templateid'];
sms_jshine_with_templateid($id,$data['mobile'],$ro_4['template'],1,$sender_id,$templateid);
//echo "1|0|Error : $id , ".$data['mobile']." , ".$ro_4['template']." , 1 , ".$ro_4['sender_id'];exit();
//sms_jshine1($id,$data['mobile'],$ro_4['template'],1,$ro_4['sender_id']);
/* if($spo_row['code']>0)
{
$s = "INSERT INTO pw_consolidate SET userid='".$spo_row['code']."',amt='1000',remarks='You have received 1000 promotional wallets for referring ".$data['mobile']."', type='RF',date='".date("Y-m-d")."' ";
mysql_query($s);
}
*/
}
$response = create_log(TABLE_NAME,$data,'code');
if($data['picture']<>"")
{
$sql = "Select * from raw_pictures where code = '".$data['picture']."'";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
$pic = $rows['image'];
$iid = $rows['code'];
copy('../ajaximage/uploads/'.$pic,'../../../ref_doc/'.$pic);
unlink('../ajaximage/uploads/'.$pic);
$sql33 = " Update ".TABLE_NAME." SET ref_doc='".$pic."' where code = '".$id."' ";
mysql_query($sql33);
//echo $sql33;
$sql = "Delete FROM raw_pictures where code = '".$iid."' or date <= '".date("Y-m-d",strtotime("-2 Days"))."'";
mysql_query($sql);
$new_col[] = 'ref_doc';
$new_val[] = $pic;
}
/*$sql = "select * from sms_template where code='4' ";
$r = mysql_query($sql);
$ro_4 = mysql_fetch_assoc($r);
$ro_4['template'] = str_replace("[CUSTOMER_ID]",$rm_code,$ro_4['template']);
$ro_4['template'] = str_replace("[NAME]",ucwords($data['name']),$ro_4['template']);
$ro_4['template'] = str_replace("[PASSWORD]",$data['pass'],$ro_4['template']);
$ro_4['template'] = str_replace("[P_POINTS]",$points,$ro_4['template']);
require_once("../../common_pages/sms1.php");
sms_jshine1($id,$data['mobile'],$ro_4['template'],1,$ro_4['sender_id']); */
if($data['task2']=="Add")
echo '1|1|Customer Created successfully with customer ID : '.$rm_code.'';
else
echo '1|1|Record Updated successfully!!';
}
else
echo '1|0|Error : in Updation!!'.$s;
}
break;
case 'delete_row':
{
//print_r($_REQUEST);
if($_REQUEST['id']>0)
{
$sql = "Select * from ".TABLE_NAME." where code = '".$_REQUEST['id']."'";
$res = mysql_query($sql);
$rows = mysql_fetch_assoc($res);
if($_SESSION['access_type']<2)
{
echo '1|0|Access Denied!';
return;
}
if(isdelete('customer_booking',"customer_code",$rows['code'],$where=' '))
{
$sql = "update ".TABLE_NAME." SET is_deleted=1 WHERE code='".$_REQUEST['id']."' ";
if(mysql_query($sql))
{
create_log(TABLE_NAME,$_REQUEST,'code');
echo '1|1|Record Deleted';
return true;
}
else
{ echo '0|0|Error : while deleting this record!!';
return true;
}
}
}
echo '0|0|Error : Can\'t Delete record!!';
}
break;
};
}
?>