Months : '.$scheme['max_months']; echo '
Start Date : '.date("d M, Y",strtotime($data['start_date'])); echo '
Amount : '.number_format($scheme['min_amount'],2); echo '
'; $i = 0; echo ''; echo ' '; $sql = "select * from draw where draw_date<='".$date_first_payment."' and m_code>0 order by code desc limit 0,1"; $r = mysql_query($sql); $ro = mysql_fetch_assoc($r); //echo '
Draw Date : '.$ro['draw_date']; if(date("Y-m",strtotime($ro['draw_date']))==date("Y-m",strtotime($date_first_payment))) { $month = 2; }else $month = 1; $date = $date_first_payment; $total = 0; $ins = 1; while($ins<=$scheme['max_months']) { $total+=$scheme['min_amount']; echo ' '; $date = date('Y-m-10',strtotime("+ ".$month." Months",strtotime($date))); $month = 1; $ins++; } echo '
Ins. Due Date Amount
'.$ins.' '.date("d M, Y",strtotime($date)).' '.number_format($scheme['min_amount'],2).'
Total : '.number_format($total,2).'
'; } 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('c.name','c.mobile', 'net_amount','order_no','c.member_code','scheme_name','bs.name','district_name','area','wc_no','au.name','last_payment_mode'); if(!empty($searchtext)) { foreach($fields as $field) { if($where=="") $where = ' AND ( '; else $where .= ' OR '; $where .= $field." LIKE '%".$searchtext."%' "; } $where .=')'; } /*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']."'"; } */ if($_SESSION['access_type']<2) $where.= " and (sale_emp_code='".$_SESSION['admin_code']."' or c_admin_id='".$_SESSION['admin_code']."')"; if($_REQUEST['type_report']==0 or $_REQUEST['type_report']=='') { $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 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 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']))."') $where order by p.code desc"; $qr = mysql_query($q) or die('Error: '.mysql_error()); //LEFT JOIN designation da ON da.code=au.designation //and payment_status=2 //echo $q; // echo TABLE_NAME.'MMMMMMM'; ?> >
Sr. # Cust ID DHS Date Booking ID Name Mobile Area City Plan EN # Received Amt Balance Amt LRD MOP Sale Employee Status Type
$rows['name'])?'
Booking For : '.$rows['bookfor_name']:''; ?> 		$rows['mobile'])?'
Booking For : '.$rows['bookfor_mobile']:''; ?> 		"0000-00-00")?date("d-M-Y",strtotime($rows['last_payment_date'])):''; ?>
='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and p.c_date<='".date("Y-m-d",strtotime($_REQUEST['s_date_to']))."') $where order by p.code desc"; $qr = mysql_query($q) or die('Error: '.mysql_error()); //LEFT JOIN designation da ON da.code=au.designation ?> >
Cust ID Name Mobile Booking Plan WB # LRD MOP IN Sales by Sale Employee Status
$rows['name'])?'
Booking For : '.$rows['bookfor_name']:''; ?> 		$rows['mobile'])?'
Booking For : '.$rows['bookfor_mobile']:''; ?>
='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and p.c_date<='".date("Y-m-d",strtotime($_REQUEST['s_date_to']))."') $where order by p.code desc"; $qr = mysql_query($q) or die('Error: '.mysql_error()); //LEFT JOIN designation da ON da.code=sale_designation //da.designation_name, ?> >
Cust ID Name Mobile Booking Plan WB # LRD MOP IN Bill Status Sales by Sale Employee Status
$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|There is a problem while creating Booking'; // print_r($data);echo ''; $s = "select * from customer where member_code = '".trim($data['sponsor_code'])."' or mobile = '".trim($data['sponsor_code'])."' and is_deleted=0"; $r = mysql_query($s); $customer = mysql_fetch_assoc($r); if($customer['code']<=0) { echo '1|0|Error : Wrong Customer Code!'; return; } if($customer['status']<=0) { echo '1|0|Error : Customer Code is not enabled yet!'; return; } $data['bookfor_mobile']= str_replace(" ",'',$data['bookfor_mobile']); if(strlen($data['bookfor_mobile'])<10) { echo '1|0|Error : Booking for Mobile Number Must be 10 digits!'; return; } $sql = "Select * from schemes where status=1 and code = '".trim($_REQUEST['scheme'])."' "; $res = mysql_query($sql); $plan = mysql_fetch_assoc($res); if($plan['code']<=0) { echo '1|0|Select Scheme Please!'; return; } if($data['amount']<>$plan['min_amount']) { echo '1|0|Please Check Amount must be '.$plan['min_amount'].'!'; return; } $sql = "SELECT s.*,designation_name FROM admin_users s INNER JOIN designation b ON s.is_deleted=0 and s.admin_id = '".trim($_REQUEST['sale_emp_code'])."' 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; } if($data['payment_mode']=='Bank') { if(trim($data['bank_name'])=='') { echo '1|0|Please enter bank name!'; return; }elseif(trim($data['bank_t_type'])=='') { echo '1|0|Please check Type please!!'; return; }else{ $sq = "Select * from bank_master where is_deleted=0 and bank_name='".trim($data['bank_name'])."'"; $r1 = mysql_query($sq); $d2 = mysql_fetch_assoc($r1); if($d2['code']<=0) { echo '1|0|Bank name does not match with Company bank name!'; return; } } if(trim($data['bank_transaction_no'])=='') { echo '1|0|Please enter Bank Transaction Number!'; return; } else{ /*$sq = "Select * from consolidate_payment where bank_transaction_no='".trim($data['bank_transaction_no'])."'"; $r1 = mysql_query($sq); $d2 = mysql_fetch_assoc($r1); if($d2['code']>0) { echo 'Please check Bank Transaction Number is alreay associated with another payment!!'; return; }*/ } }else { $data['bank_name'] = ''; $data['bank_transaction_no'] = ''; } if($data['payment_mode']=='Cheque') { if(trim($data['bank_name'])=='') { echo '1|0|Please enter bank name from where check issued!'; return; } if(trim($data['cheque_number'])=='') { echo '1|0|Please enter Cheque Number!'; return; } else{ /*$sq = "Select * from consolidate_payment where bank_transaction_no='".trim($data['bank_transaction_no'])."'"; $r1 = mysql_query($sq); $d2 = mysql_fetch_assoc($r1); if($d2['code']>0) { echo 'Please check Bank Transaction Number is alreay associated with another payment!!'; return; }*/ } }else { //$data['paytm_transaction_no'] = ''; //$data['paytm_transaction_no'] = ''; } if($data['payment_mode']=='Paytm') { if(trim($data['paytm_transaction_no'])=='') { echo '1|0|Please enter Paytm Transaction Number!!'; return; } else{ /*$sq = "Select * from consolidate_payment where paytm_transaction_no='".trim($data['paytm_transaction_no'])."'"; $r1 = mysql_query($sq); $d2 = mysql_fetch_assoc($r1); if($d2['code']>0) { echo 'Please check Paytm Transaction Number is alreay associated with another payment!!'; return; }*/ } }else { $data['paytm_transaction_no'] = ''; } if($data['payment_mode']=='Cash') { /*$sq = "Select * from multipul_payments where is_deleted=0 and payment_done = 0 and code ='".$data['payment_mode']."'"; $r1 = mysql_query($sq); $d2 = mysql_fetch_assoc($r1); if($d2['code']<=0) { echo 'Wrong payment Option Please refresh and try again!!'; return; } else { $sq2 = "Select sum(amt) as amt from consolidate_payment where reference='".$id."' and paid=1"; $r2 = mysql_query($sq2); $used = mysql_fetch_assoc($r2); $balance = $d2['amount'] - $used['amt']; if($balance<$r7['amt']) { echo 'You must have balance more than '.$r7['amt'].'. Try another payment type!!'; return; } }*/ } if($_SESSION['payment_approval']==2) $msg = " and Payment will be proccessed Direct "; else $msg = " and Payment need approval"; if($data['agree']<=0) { echo '1|99|Please agree that, Yes me going to receive Rs. '.number_format($data['amount']).$msg.'|'; 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++; } // $s = $s.",code = '".$_SESSION['code']."' "; // echo '1|0|There is a problem while creating Booking'; // return; /*if($data['task2']=="Add") { }else { echo '1|0|This Action is not possible here'; return; } */ //unset($_SESSION["b"]); $s = "INSERT INTO customer_booking "; $s .= "SET customer_code ='".$customer['code']."'"; $s .= ",bookfor_mobile ='".trim($data['bookfor_mobile'])."'"; $s .= ",bookfor_name ='".trim($data['bookfor_name'])."'"; $s .= ",billing_name ='".trim($customer['name'])."'"; $s .= ",billing_mobile ='".trim($customer['mobile'])."'"; //$s .= ",bookfor_name ='".trim($customer['name'])."'"; //$s .= ",bookfor_mobile ='".trim($customer['mobile'])."'"; $s .= ",total_amount ='".trim($plan['min_amount'])."'"; $s .= ",net_amount ='".trim($plan['min_amount'])."'"; $s .= ",payment_type ='".trim($data['payment_mode'])."'"; $s .= ",payment_mode ='".trim($data['payment_mode'])."'"; $s .= ",bank_name ='".trim($data['bank_name'])."'"; $s .= ",bank_t_type ='".trim($data['bank_t_type'])."'"; $s .= ",bank_transaction_no ='".trim($data['bank_transaction_no'])."'"; $s .= ",paytm_transaction_no ='".trim($data['paytm_transaction_no'])."'"; $s .= ",scheme ='".trim($plan['code'])."'"; $s .= ",payment_plan ='".trim($plan['code'])."'"; $s .= ",receipt_number =''"; $s .= ",payment_details_customer =''"; //Sale Employee $s .= ",sale_emp_code ='".trim($sale_emp['admin_id'])."'"; $s .= ",sale_designation ='".trim($sale_emp['designation'])."'"; $s = $s.",c_admin_id = '".$_SESSION['admin_code']."' "; $s .= ",booking_created_from ='Admin Panel'"; $s .= ",pyment_pay ='".trim($plan['min_amount'])."'"; $s .= ",first_insallment ='".trim(round($plan['min_amount'],2))."'"; $s .= ",c_date ='".date("Y-m-d")."'"; $s .= ",date_time_f ='".date("Y-m-d H:i:s")."'"; $s .= ",discount ='0'"; $s .= ",shiping ='0'"; $s .= ",shipping_details =''"; $s .= ",shipping_date='1000-01-01'"; $s .= ",payment_option=''"; $s .= ",payment_details=''"; $s .= ",billing_email =''"; $s .= ",billing_country =''"; $s .= ",billing_state =''"; $s .= ",billing_city =''"; $s .= ",billing_add_1 =''"; $s .= ",billing_add_2 =''"; $s .= ",billing_pin_code =''"; $s .= ",shipping_name =''"; $s .= ",shipping_mobile =''"; $s .= ",shipping_add_1 =''"; $s .= ",shipping_add_2 =''"; $s .= ",shipping_country =''"; $s .= ",shipping_state =''"; $s .= ",shipping_city =''"; $s .= ",shipping_pin_code =''"; $s .= ",shipping_landmark =''"; $s .= ",status ='1'"; $s .= ",admin_id ='0'"; $s .= ",sort_id ='0'"; $s .= ",client_id ='0'"; $s .= ",details =''"; $s .= ",ip =''"; $s .= ",browser =''"; $s .= ",coupon_code =''"; $s .= ",payment_remarks =''"; $s .= ",order_no =''"; $s .= ",wc_no =''"; $s .= ",ewallet_op ='1'"; $s .= ",ewallet_op_otp =''"; $s .= ",other_otp =''"; $s .= ",receipt_number2 =''"; $s .= ",call_status ='0'"; $s .= ",response_code ='0'"; $s .= ",assign_to_user ='0'"; $s .= ",last_user ='0'"; $s .= ",last_call ='0'"; $s .= ",book_status ='1'"; $s .= ",delivery =''"; $s .= ",delivery_date ='1000-01-01'"; $s .= ",product_code ='0'"; $s .= ",product_style_code ='0'"; $s .= ",response_code_p ='0'"; $s .= ",call_status_p ='0'"; $s .= ",assign_to_user_p ='0'"; $s .= ",last_user_p ='0'"; $s .= ",payment_missed ='0'"; $s .= ",payment_missed_consuctive ='0'"; $s .= ",last_payment_date ='".date("Y-m-d")."'"; $s .= ",created_by ='0'"; $s .= ",created_name =''"; $s .= ",last_payment_mode =''"; $s .= ",last_paid_ins ='0'"; $s .= ",approved_by ='0'"; $s .= ",sponsor_code_policy ='0'"; $s .= ",tax ='0'"; //echo '0|0|'.$s; $total = $plan['min_amount']; echo $s.'
'; if(mysql_query($s)) { $order_id = mysql_insert_id(); $order_no_text = $order_id; $s = "update customer_booking SET order_no='".$order_no_text."' where code='".$order_id."' "; mysql_query($s); add_sale_team($sale_emp,$order_id,'customer_booking_designation','policy_code'); $data['total_order'] = $plan['min_amount']; $data['total_order_payable'] = $plan['min_amount']; $rem = $plan['min_amount'] - $plan['min_amount']; $date = date("Y-m-d",time()); $s1 = "INSERT INTO consolidate_policy_new "; $s1 .= " SET remarks = 'Initial/First Payment'"; $s1 .= " , policy_code = '".($order_id)."' "; $s1 .= " , ins = '1' "; $s1 .= " , amt = '".round($plan['min_amount'],2)."' "; $s1 .= " , policy_booklet_no = '".($order_no_text)."' "; $s1 .= " , type = 'INS' "; $s1 .= " , p_type = 'Auto Genrated333' "; $s1 .= " , vno = '".($order_id)."' "; $s1 .= " , date = '".date("Y-m-d",strtotime($date))."' "; mysql_query($s1); $s1 = "INSERT INTO consolidate_policy "; $s1 .= " SET remarks = 'Initial/First Payment'"; $s1 .= " , vno = '".($order_id)."' "; $s1 .= " , date = '".$date."' "; $s1 .= " , policy_code = '".($order_id)."' "; $s1 .= " , ins = '1' "; $s1 .= " , amt = '".round($plan['min_amount'],2)."' "; $s1 .= " , policy_booklet_no = '".($order_no_text)."' "; $s1 .= " , type = 'INS' "; $s1 .= " , s_code = '0' "; $s1 .= " , paid = '0' "; $s1 .= " , direct_sponser = '0' "; $s1 .= " , received_by = '0' "; $s1 .= " , received_by_name = '' "; $s1 .= " , receipt_number = '' "; $s1 .= " , remarks_admin = '' "; $s1 .= " , rec_date = '1000-01-01' "; $s1 .= " , receipt_number2 = '' "; $s1 .= " , alert1 = '0' "; $s1 .= " , alert2 = '0' "; $s1 .= " , reference = '0' "; $s1 .= " , transfered_pay = '0' "; $s1 .= " , used_for = '0' "; $s1 .= " , used_for_remarks = '' "; $s1 .= " , p_type = 'Auto Genrated333' "; $s1 .= " , payment_type = '".($data['payment_mode'])."' "; $s1 .= ",bank_name ='".trim($data['bank_name'])."'"; $s1 .= ",bank_transaction_no ='".trim($data['bank_transaction_no'])."'"; $s1 .= ",paytm_transaction_no ='".trim($data['paytm_transaction_no'])."'"; mysql_query($s1); $j = 1; $s = "Select * from customer where code = '".$_SESSION['customer_id']."'"; $r = mysql_query($s); $cust_d = mysql_fetch_assoc($r); $temp = 1; if($_SESSION['payment_approval']==2) { $pre_fix = 'DH/'.date("my").'/'; $sql44 = "SELECT max(receipt_number2) as receipt_number FROM customer_booking WHERE order_no like '".$pre_fix."%'"; $ro44 = mysql_query($sql44); $r44 = mysql_fetch_assoc($ro44); $next = ($r44['receipt_number']+1); $order_no_text =$pre_fix.$next; $temp = 0; $s = "update customer_booking SET order_no='".$order_no_text."' ,payment_status=2, receipt_number2='".$next."' where code='".$order_id."' "; mysql_query($s); $s = "update consolidate_policy SET policy_booklet_no='".$order_no_text."' where policy_booklet_no='".$order_id."' "; mysql_query($s); $s = "update consolidate_policy_new SET policy_booklet_no='".$order_no_text."' where policy_booklet_no='".$order_id."' "; mysql_query($s); /*$sql = "select * from customer_booking where code = '".."' "; $rr = mysql_query($sql); $r2 = mysql_fetch_assoc($r2);*/ $payment_update_info = array(); $payment_update_info['admin_id'] = $_SESSION['admin_code']; $payment_update_info['admin_name'] = $_SESSION['admin_name']; //$s .= ",received_by='".ucwords($data['payment_type'])."'"; $payment_update_info['payment_type'] = ($data['payment_type']); $payment_update_info['paytm_transaction_no'] = $data['paytm_transaction_no']; $payment_update_info['bank_transaction_no'] = $data['bank_transaction_no']; $payment_update_info['bank_name'] = $data['bank_name']; $payment_update_info['bank_t_type'] = $data['bank_t_type']; $payment_update_info['payment_type'] = $data['payment_mode']; $payment_x = payment_first($order_no_text,$payment_update_info); customer_payment_status_update($order_id); } /*if($data['ewallet_op_otp']=="manual") { $_SESSION['manual_approval']= 1; $sms = "Temporary Reference Number : ".$order_no_text.", the booking process is now complete."; $msg_red = "You have requested to ".ucwords($row['name'])." (".$row['member_code'].") to approve your payment for Diamond Harvest Scheme. Whenever your payment gets approved you will get a confirmation message on your registered email and mobile number along with payment receipt number."; $sms = "Temporary Reference Number : ".$order_no_text.", the booking process is now complete. ".$msg_red; //sms_jshine($_SESSION['customer_id'],$_SESSION['mobile'],$sms); //payment_first($order_no_text,$payment_update_info); }else { $payment_x = payment_first($order_no_text,$payment_update_info); $q = "SELECT * FROM consolidate_policy WHERE policy_booklet_no = '".($order_no_text)."' and ins=1 and paid=1"; $res = mysql_query($q); $r = mysql_fetch_assoc($res); if($data['ewallet_op_otp']=="OTP") $msg_red = "Dear ".ucwords($cust_d['name']).", we have received ".CUR_SYMBOL.$r['amt']." with reference number ".$order_no_text." from your e-wallet account. Please note your receipt number ".$r['receipt_number']."."; else $msg_red = "Dear ".ucwords($cust_d['name']).", we have received ".CUR_SYMBOL.$r['amt']." with reference number ".$order_no_text." from the account of Mr. ".$row['name']." (".$row['member_code']."). Please note your receipt number ".$r['receipt_number']."."; //$msg = "Dear ".ucwords($cust_d['name']).", we would like to say thanks for showing your interest in JShine jewelry. We also offer an opportunity to win exciting prize in the reward program powered by Winning Basket. You will receive your reward program enrollment number in next 24 to 48 hours."; //sms($cust_d['code'],$cust_d['mobile'],$msg); fix_under_level($cust_d['member_code'],$cust_d['sponsor_code'],$cust_d['placement_side']); }*/ } else { echo '1|0|This Action is not possible here'; return; } // echo $s; if(mysql_query($s)) { $id= mysql_insert_id(); if($data['id']>0) $id = $data['id']; $data['start_date'] = date("Y-m-d",strtotime($data['start_date'])); $response = create_log(TABLE_NAME,$data,'code'); $i = 1; //echo '1|0|
'.$data['start_date']; $j = 1; $tp = 0; $ti = 0; $tt = 0; 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($temp==1) echo '1|1|Booking created with Temporary Reference Number '.$order_no_text.''; else echo '1|1|Booking created with Booking Number '.$order_no_text.''; } else echo '1|0|Error : in Updation!!'.$s; } break; case 'delete_row': { //print_r($_REQUEST); if($_REQUEST['id']>0) { //if(isdelete('admin_users',"user_type",$_REQUEST['id'],$where=' and is_deleted=0 ')) //{ $sql = "update ".TABLE_NAME." SET is_deleted=1 WHERE code='".$_REQUEST['id']."' and start_date>'".date("Y-m-d")."' "; 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; }; } ?>