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', 'c.member_code'); 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']."')"; $q = "SELECT c.member_code,name,mobile,sum(if(amt>0,amt,0)) as amount,sum(if(amt<0,amt,0)) as amount_u,sum(amt) as amount_bal FROM customer c ,pw_consolidate p WHERE c.code=p.userid $where group by userid having amount>0 "; $qr = mysql_query($q) or die('Error: '.mysql_error()); //and payment_status=2 //echo $q; ?> >
Sr. # Cust ID Name Mobile PW Used Balance
date("Y-m-d")) { ?>
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; } $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; } 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; } }*/ } $sq = "Select * from customer_booking where code ='".$data['id']."'"; $r1 = mysql_query($sq); $policy = mysql_fetch_assoc($r1); if($policy['code']<=0) { echo '1|0|Wrong Booking Option Please refresh and try again.'; return; } if($policy['payment_status']==2) { echo '1|0|Payment Seems already paid, Please refresh and try again!'; return; } $sq = "Select * from consolidate_policy where policy_code ='".$policy['code']."' and ins=1"; $r1 = mysql_query($sq); $consolidate = mysql_fetch_assoc($r1); if($consolidate['code']<=0) { echo '1|0|Wrong Booking Option Please refresh and try again..'; return; } if($consolidate['paid']==1) { echo '1|0|Payment Seems already paid, Please refresh and try again!'; return; } if($data['agree']<=0) { echo '1|99|I have cross checked everything and I have received Rs. '.number_format($data['amount']).' by payment mode : '.$data['payment_mode'].'|'; 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") { echo '1|0|This Action is not possible here'; return; }else { } $total = $data['amount']; $order_id = $policy['code']; $order_no_text = $order_id; $j = 1; $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."',approved_by='".$_SESSION['admin_code']."' 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); echo '1|1|Booking created with Booking Number '.$order_no_text.''; } 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; }; } ?>