"") { $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']."'"; } */ $q = "SELECT s.* FROM ".TABLE_NAME." s $where order by code desc "; ?> 1) $_SESSION['page'] = $_REQUEST['page']; else $_SESSION['page'] = 1; //echo $q; //Paging New Script // if($_REQUEST['s_all_records']==1) $p = paging_prepare($q,$_SESSION['page'],999999999); else $p = paging_prepare($q,$_SESSION['page']); $p['task'] = 'GeneralDetails'; $p['div'] = 'main_result_div'; $p['response_file'] = 'response_index'; $i =0; //echo $q; $q .= " LIMIT ".$p['Page_Start'].",".$p['Per_Page']." "; //end of Pageing $qr = mysql_query($q) or die('Error: '.mysql_error()); $i = ($p['Page_Start']+1); $status_array = array(); $status_array[0] = '

Pending

'; $status_array[1] = '

Sent

'; while ($rows=mysql_fetch_array($qr)) { ?> >

SrNo	Name	Mobile Number	Message	Submitted @	Schedule Date/Time	Status	Gateway
			<?=$rows['text_message']; ?>

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': { if(strlen(trim($_REQUEST['mobile_no']))<=9) { echo '1|0|Error : Please enter 10 digits Mobile Number!!'; return; } if(trim($_REQUEST['template'])=="") { echo '1|0|Error : Please enter Message!!'; return; } $s = "select * from customer where mobile='".$_REQUEST['mobile_no']."'" ; $r = mysql_query($s); $customer = mysql_fetch_assoc($r); sms_jshine($customer['code'],trim($_REQUEST['mobile_no']),$_REQUEST['template'],1,$_REQUEST['sender_id']); echo '1|1|SMS Sent Successfully'; // print_r($_REQUEST); } 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(isdelete('policy_list',"customer_code",$rows['customer_code'],$where=' and is_deleted=0 ')) { $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; }; } ?>