"")
{
$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']."'";
}
*/
//$_REQUEST['emp_code']
$q = "SELECT c.*,p.*,scheme_name, bs.name as booking_status,au.name as sale_emp,district_name as city_name FROM customer c
INNER JOIN ".TABLE_NAME." p ON p.payment_status=2 and c.sale_employee_code_new='".$_REQUEST['emp_code']."' and (p.c_date >='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and p.c_date<='".date("Y-m-d",strtotime($_REQUEST['s_date_to']))."') and c.code=p.customer_code
INNER JOIN schemes s ON s.code=p.scheme
INNER JOIN booking_status bs ON bs.code=booking_status_code
LEFT JOIN admin_users au ON au.admin_id=sale_employee_code_new
LEFT JOIN bm_districts dd ON dd.code=c.city
WHERE c.is_deleted=0 $where order by p.code desc";
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
| Sr. # |
Cust ID |
DHS Date |
Booking ID |
Name |
Mobile |
Plan |
EN # |
Received Amt |
Balance Amt |
Ins. Received |
Sale Employee |
>
|
|
|
|
$rows['name'])?'
Booking For : '.$rows['bookfor_name']:''; ?>
|
$rows['mobile'])?'
Booking For : '.$rows['bookfor_mobile']:''; ?>
|
|
|
|
|
|
|
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($data['mobile']<>"9888864504")
{
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($data['task2']=="Add")
{
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'];
}
$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 = "INSERT INTO ".TABLE_NAME." ".$s;
}
else
{
$s = "UPDATE ".TABLE_NAME." ".$s;
$s = $s." WHERE code='".$data['id']."'";
}
// echo $s;
if(mysql_query($s))
{
$id= mysql_insert_id();
if($data['id']>0)
$id = $data['id'];
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');
$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']);
sms_jshine($id,$data['mobile'],$ro_4['template'],1,$ro_4['sender_id']);
//pw_consolidate
$points = 1000;
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']);
}
/* 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;
}
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;
};
}
?>