0 $where order by p.code desc ";
if(is_numeric($_REQUEST['page']) && $_REQUEST['page']>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'] = 'Pw_requestDetails';
$p['div'] = 'main_result_div';
$p['response_file'] = 'response_pw_request';
$i =0;
$key = array_keys($_REQUEST);
$n = count($_REQUEST);
while($i<=($n))
{
if($key[$i]<>"page" && $key[$i]<>"task" && $key[$i]<>"task2" )
$p['ext_q'] .= "&".$key[$i]."=".$_REQUEST[$key[$i]]."";
$i++;
}
//echo $q;
$q .= " LIMIT ".$p['Page_Start'].",".$p['Per_Page']." ";
//end of Pageing
$qr = mysql_query($q) or die('Error: '.mysql_error());
?>
(+) Add Promotional Wallets
| Date |
MCode |
Name |
Mobile |
Promotional Wallet |
Remark |
Admin Remarks |
>
|
|
|
|
|
|
|
|
Pagination Finish
}
break;
case 'add_edit':
{
require_once("index.class.php");
$objpl=new Pw_request();
$objpl->add_edit(fetch_details('ewallet','code',$_REQUEST['id']));
}
break;
#-------------------------->>>>>>>>>>>>>>>>>>>>>>
case 'save_key':
{
$data = $_POST;
$i = 0;
if($_REQUEST['task2']=='Add')
{
$sql = "select * FROM customer WHERE member_code='".$_REQUEST['member_code']."' or mobile = '".$_REQUEST['member_code']."' ";
$r = mysql_query($sql);
$ro = mysql_fetch_assoc($r);
if($ro['code']<=0)
{
echo 'Error Wrong member code or Mobile!!';
return true;
}
$s = "INSERT INTO pw ";
$s .= "SET admin_app_date='".date("Y-m-d")."'";
$s .= ",admin_id='".$_SESSION['admin_code']."'";
$s .= ",admin_status='".($data['admin_status'])."'";
$s .= ",userid='".$ro['code']."'";
$s .= ",amt='".($data['amt'])."'";
$s .= ",remark='".($data['remark'])."'";
$s .= ",mode='".($data['mode'])."'";
$s .= ",admin_user_name='".($_SESSION['name'])."'";
$s .= ",admin_remark='".$data['admin_remark']."'";
//$s .= " where code='".$data['id']."'";
}else
{
$s = "UPDATE pw ";
$s .= "SET admin_app_date='".date("Y-m-d")."'";
$s .= ",admin_id='".$_SESSION['admin_code']."'";
$s .= ",admin_status='".($data['admin_status'])."'";
$s .= ",admin_remark='".$data['admin_remark']."'";
$s .= " where code='".$data['id']."'";
}
if(mysql_query($s))
{
$ii = mysql_insert_id();
if($data['id']<=0)
$data['id'] = $ii;
$sql = "SELECT * FROM pw where code='".$data['id']."' ";
$re = mysql_query($sql);
$rows = mysql_fetch_assoc($re);
$s = "INSERT INTO pw_consolidate ";
$s .= " SET amt = '".($rows['amt'])."'";
$s .= " ,remarks = 'Promotional Wallet - ".$rows['remark']."'";
$s .= " ,userid = '".trim($rows['userid'])."'";
$s .= " ,vno = '".trim($rows['code'])."'";
$s .= " ,status = '1'";
$s .= " ,date = '".date("Y-m-d")."'";
mysql_query($s);
/*}elseif($data['admin_status']==3)
{
$sql2 = "SELECT * FROM pw_consolidate where userid = '".trim($rows['userid'])."' AND remarks=' E-Wallet Request Approved RNO ".$rows['code']."'";
$re2 = mysql_query($sql2);
$rows2 = mysql_fetch_assoc($re2);
if($rows2['code']>0)
{ $s = "INSERT INTO pw_consolidate ";
$s .= " SET amt = '-".($rows['amt'])."'";
$s .= " ,remarks = 'E-Wallet Request REJECTED RNO ".$rows['code']."'";
$s .= " ,userid = '".trim($rows['userid'])."'";
$s .= " ,date = '".date("Y-m-d")."'";
mysql_query($s);
}
}*/
echo 'Request Submitted successfully!!';
}
else
{
echo 'Error while Saving Try Again!! '.mysql_error();
}
}
break;
case 'delete_row':
{
if($_REQUEST['id']>0)
{
$sql = "DELETE FROM sssewallet WHERE code='".$_REQUEST['id']."' and admin_status='0'";
if(mysql_query($sql))
{ echo 'Record Deleted successfully!!';
return true;
}
else
{ echo ' Error : in Updation! ';
return true;
}
}
echo 'Error : Can\'t Delete record!!';
}
break;
case 'member_code':
{
if($_REQUEST['member_code']>0)
{
$sql = "select * FROM customer WHERE member_code='".$_REQUEST['member_code']."' or mobile = '".$_REQUEST['member_code']."' ";
$r = mysql_query($sql);
$ro = mysql_fetch_assoc($r);
if($ro['code']>0)
{
echo $ro['name'].'|'.$ro['mobile'];
return true;
}
}
echo 'wrong Member Code|--';
}
break;
};
}
?>