Viewing file:  payoutdetails.php (24.75 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('session.php');
?>
<script type="text/javascript">
function changeValue(){
var option=document.getElementById('filter').value;
if(option=="A"){
document.getElementById('field').value="A Selected";
}
else if(option=="B"){
document.getElementById('field').value="B Selected";
}
}
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Account Create</title>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<style type="text/css">
table {
border: 1px solid green;
border-collapse: collapse;
width:100%;
}
table td {
border: 1px solid green;
}
table td.shrink {
white-space:nowrap
}
table td.expand {
width: 99%
}
}
</style>
<script language="JavaScript" type="text/javascript">
<!--
function Toggle(obj){
var val=obj.value;
if (!obj.m){ obj.m=''; }
if (!obj.m.match(val)){ obj.m+=','+val+','; }
var hide=obj.m.split(',');
for (var zxc0=0;zxc0<hide.length;zxc0++){
if (document.getElementById(hide[zxc0])){
document.getElementById(hide[zxc0]).style.display='none';
}
}
var show=val.split(',');
for (var zxc1=0;zxc1<show.length;zxc1++){
if (document.getElementById(show[zxc1])){
document.getElementById(show[zxc1]).style.display='';
}
}
}
//-->
</script>
</head>
<center>
<body>-
<table width="953" border="0" bgcolor="#FFFFFF">
<tr>
<td colspan="2"><?php include('header.php'); ?></td>
</tr>
<tr>
<td colspan="2">
<table width="945" border="0">
<tr>
<td colspan="3" bgcolor="#CCCCCC"><?php include('menubar.php'); ?></td>
</tr>
<tr>
<td width="210" bgcolor="#6699CC">Welcome: Mr.<?php echo $user ?></td>
<td width="335" bgcolor="#6699CC"><a href="logout.php">Logout</a></td>
<td width="386" bgcolor="#6699CC"><?php echo "Today is " . date("d/m/y") . "<br>";?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="421">
<form action="" method="get" name="form">
<table width="800" border="1" cellspacing="10" cellpadding="10">
<tr>
<td>Enter Member Code:
<form action="" method="get" name="form">
<?php
// Create connection
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno())
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
} else {
echo "We are connected.";
}
$result = mysqli_query($con,"SELECT ID, membercode FROM addmember ");
?> <select name="q" id="q" >
<?
while($row = mysqli_fetch_array($result))
{
echo "<option value='" . $row['membercode'] . "'>" .$row['membercode']. "</option>";
}
?>
</select>
</select>
</td>
<td> Month: <select name="month" id="month">
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
</td>
<td><select name="cyear" size="1" id="cyear">
<option><?php echo date("Y") ?></option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
</select>
<input type="submit" name="Submit" value="Search" />
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td> </tr>
<tr>
<td colspan="2">
<td width="0"></td>
<?php
// Create connection
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno())
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
} else {
echo "We are connected.";
}
$var = @$_GET['q'] ;
$trimmed = trim($var);
$result = mysqli_query($con,"SELECT ID, rank FROM addmember where membercode like \"$trimmed\" " );
while($row = mysqli_fetch_array($result))
{
$ranks=$row['rank'];
}
?>
<form id="form1" name="form1" method="post" action="memberupdate.php" enctype="multipart/form-data">
<?php
// Get the search variable from URL
$var = @$_GET['q'] ;
$trimmed = trim($var);
$mvar = @$_GET['month'] ;
$trimmedm = trim($mvar);
$yvar = @$_GET['cyear'] ;
$trimmedy = trim($yvar);
//trim whitespace from the stored variable
// rows to return
$limit=100000;
// check for an empty string and display a message.
if ($trimmed == "")
{
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p></p>";
exit;
}
mysql_connect("localhost","sarkmicr_user","rb!sar838"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("sarkmicr_data") or die("Unable to select database"); //select which database we're using
$field = 'agentcode';
$month='jmonth';
$year='jyear';
$sum='0';
$tc=$trimmedc;
$mo=$month;
// Build SQL Query
$query = "select * from create_receipt where $field like \"$trimmed\" AND $month like \"$trimmedm\" AND $year like \"$trimmedy\"
order by $field"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// begin to show results set
echo "<table width='1000' border=\"1\" bg bgcolor='#FF9900' llspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <tr>\n";
echo " <td>MEMBER CODE :$trimmed </td>\n";
echo " <td>RANK :$ranks </td>\n";
echo " <td>Month :$trimmedm </td>\n";
echo " <td>Year :$trimmedy </td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
echo "<table width='800' border=\"1\" bgcolor='#FFFFFF' cellspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <col width='100'/>";
echo"<col width='160'/>";
echo"<col width='210'/>";
echo "<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo " <tr>\n";
echo " <td>Receipt No</td>\n";
echo " <td>Name</td>\n";
echo " <td >Account No</td>\n";
echo " <td >No of Installment</td>\n";
echo " <td>Branch Name</td>\n";
echo " <td > Amount</td>\n";
echo " <td >Plan</td>\n";
echo " <td >Plan Time</td>\n";
echo " <td >Commission</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$pname=$row['planname'];
$rank=$ranks;
$plantime=$row['plantime'];
IF($row['planname']==RD)
{
IF($rank==1)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==2)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==3)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==4)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==5)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==6)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==7)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==8)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==9)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==10)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==11)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==12)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
IF($rank==13)
{
if($plantime==12)
{
$comm=3;
}
if($plantime==24)
{
$comm=4;
}
if($plantime==36)
{
$comm=5;
}
if($plantime==48)
{
$comm=10;
}
if($plantime==60)
{
$comm=18;
}
if($plantime==72)
{
$comm=20;
}
}
$tot=($row['amount']*$comm)/100;
}
IF($row['planname']==FD)
{
IF($rank==1)
{
if($plantime==3.4)
{
$comm=6;
}
if($plantime==5.6)
{
$comm=8;
}
if($plantime==8.3)
{
$comm=10;
}
if($plantime==11)
{
$comm=11;
}
if($plantime==15)
{
$comm=12;
}
}
IF($rank==2)
{
if($plantime==3.4)
{
$comm=2;
}
if($plantime==5.6)
{
$comm=2;
}
if($plantime==8.3)
{
$comm=2;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==3)
{
if($plantime==3.4)
{
$comm=1.5;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=2;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==4)
{
if($plantime==3.4)
{
$comm=1.5;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=2;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==5)
{
if($plantime==3.4)
{
$comm=1.5;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=1.75;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==6)
{
if($plantime==3.4)
{
$comm=1.5;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=1.75;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==7)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=1.75;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==8)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1.5;
}
if($plantime==8.3)
{
$comm=1.75;
}
if($plantime==11)
{
$comm=2;
}
if($plantime==15)
{
$comm=2;
}
}
IF($rank==9)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=20.25;
}
if($plantime==8.3)
{
$comm=1.25;
}
if($plantime==11)
{
$comm=1.25;
}
if($plantime==15)
{
$comm=1.5;
}
}
IF($rank==10)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=20.25;
}
if($plantime==8.3)
{
$comm=1.25;
}
if($plantime==11)
{
$comm=1.25;
}
if($plantime==15)
{
$comm=1.5;
}
}
IF($rank==11)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=20.25;
}
if($plantime==8.3)
{
$comm=1.25;
}
if($plantime==11)
{
$comm=1.25;
}
if($plantime==15)
{
$comm=1.5;
}
}
IF($rank==12)
{
if($plantime==3.4)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=20.25;
}
if($plantime==8.3)
{
$comm=1.25;
}
if($plantime==11)
{
$comm=1.25;
}
if($plantime==15)
{
$comm=1.5;
}
}
IF($rank==13)
{
if($plantime=='3.4')
{
$comm=1;
}
if($plantime=='5.6')
{
$comm=20.25;
}
if($plantime=='8.3')
{
$comm=1.25;
}
if($plantime==11)
{
$comm=1.25;
}
if($plantime==15)
{
$comm=1.5;
}
}
$tot=$row['amount']*$comm/100;
}
echo "<table width='800' border=\"1\" cellspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <col width='100'/>";
echo"<col width='160'/>";
echo"<col width='210'/>";
echo "<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo " <tr bgcolor='#99CCCC'>\n";
echo " <td >$row[receipt2]</td>\n";
echo " <td>$row[cname] $row[cmidname] $row[csurname]</td>\n";
echo " <td >$row[acc_no]</td>\n";
echo " <td >$row[noofinstallment]</td>\n";
echo " <td >$row[branch_name]</td>\n";
echo " <td >$row[amount]</td>\n";
echo " <td >$row[planname]</td>\n";
echo " <td >$row[plantime]</td>\n";
echo " <td>$tot</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
$total=$row[amount]+$total;
$commtotal= $tot+$commtotal;
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
echo "<table width='1000' border=\"0\" bg bgcolor='#FF9900' llspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <tr>\n";
echo " <td>TOTAL BUSINESS</td>\n";
echo " <td>$total</td>\n";
echo " <td>TOTAL COMMISSION </td>\n";
echo " <td>$commtotal </td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
?>
</form>
<?php
// Get the search variable from URL
$var = @$_GET['q'] ;
$trimmed = trim($var);
$mvar = @$_GET['month'] ;
$trimmedm = trim($mvar);
$yvar = @$_GET['cyear'] ;
$trimmedy = trim($yvar);
//trim whitespace from the stored variable
// rows to return
$limit=1000000;
// check for an empty string and display a message.
if ($trimmed == "")
{
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p></p>";
exit;
}
mysql_connect("localhost","baserain_dba838","rb!bsa838mau"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("baserain_db838") or die("Unable to select database"); //select which database we're using
$field = 'ncode';
$month='jmonth';
$year='jyear';
$sum='0';
$tc=$trimmedc;
$mo=$month;
// Build SQL Query
$query = "select * from create_receipt where $field like '%$trimmed%' AND $month like \"$trimmedm\" AND $year like \"$trimmedy\"
order by $field"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// begin to show results set
echo "<table width='800' border=\"1\" bgcolor='#FFFFFF' cellspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <col width='100'/>";
echo"<col width='160'/>";
echo"<col width='210'/>";
echo "<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo " <tr>\n";
echo " <td>Receipt No</td>\n";
echo " <td>Name</td>\n";
echo " <td >Account No</td>\n";
echo " <td >No of Installment</td>\n";
echo " <td>branch Name</td>\n";
echo " <td > Amount</td>\n";
echo " <td >Plan</td>\n";
echo " <td >Plan Time</td>\n";
echo " <td >Commission</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$title = $row['certificate_no']." ".$row['serail_no']. "".$row['roll_no']. " " . $row['student_name']. " " .$row['date_of_birth']. " " .$row['issue_date']." ". $row['course_name'];
$pname=$row['planname'];
$rank=$row['rank'];
IF($pname=='RD')
{
IF($rank==1)
{
if($plantime==1)
{
$comm=5;
}
if($plantime==2)
{
$comm=6;
}
if($plantime==3)
{
$comm=11;
}
if($plantime==5.6)
{
$comm=13;
}
if($plantime==7)
{
$comm=15;
}
}
IF($rank==2)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=2;
}
if($plantime==5.6)
{
$comm=2;
}
if($plantime==7)
{
$comm=2;
}
}
IF($rank==3)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=2;
}
if($plantime==5.6)
{
$comm=2;
}
if($plantime==7)
{
$comm=2;
}
}
IF($rank==4)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==5)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==6)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==7)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==8)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==9)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==10)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==11)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==12)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
IF($rank==13)
{
if($plantime==1)
{
$comm=1;
}
if($plantime==2)
{
$comm=1;
}
if($plantime==3)
{
$comm=1;
}
if($plantime==5.6)
{
$comm=1;
}
if($plantime==7)
{
$comm=1;
}
}
$tot=($row['amount']*$comm)/100;
}
IF($row['planname']==FD)
{
IF($rank==1)
{
if($plantime==3.4)
{
$comm=6;
}
if($plantime==5.6)
{
$comm=8;
}
if($plantime==8.3)
{
$comm=10;
}
if($plantime==11)
{
$comm=11;
}
if($plantime==15)
{
$comm=12;
}
}
IF($rank==2)
{
if($plantime==3.4)
{
$comm=8;
}
if($plantime==5.6)
{
$comm=10;
}
if($plantime==8.3)
{
$comm=12;
}
if($plantime==11)
{
$comm=12;
}
if($plantime==15)
{
$comm=14;
}
}
IF($rank==3)
{
if($plantime==3.4)
{
$comm=9.5;
}
if($plantime==5.6)
{
$comm=11.5;
}
if($plantime==8.3)
{
$comm=14;
}
if($plantime==11)
{
$comm=15;
}
if($plantime==15)
{
$comm=16;
}
}
IF($rank==4)
{
if($plantime==3.4)
{
$comm=11;
}
if($plantime==5.6)
{
$comm=13;
}
if($plantime==8.3)
{
$comm=16;
}
if($plantime==11)
{
$comm=17;
}
if($plantime==15)
{
$comm=18;
}
}
IF($rank==5)
{
if($plantime==3.4)
{
$comm=12.5;
}
if($plantime==5.6)
{
$comm=14.5;
}
if($plantime==8.3)
{
$comm=17.75;
}
if($plantime==11)
{
$comm=19;
}
if($plantime==15)
{
$comm=20;
}
}
IF($rank==6)
{
if($plantime==3.4)
{
$comm=14;
}
if($plantime==5.6)
{
$comm=16;
}
if($plantime==8.3)
{
$comm=19.5;
}
if($plantime==11)
{
$comm=21;
}
if($plantime==15)
{
$comm=22;
}
}
IF($rank==7)
{
if($plantime==3.4)
{
$comm=15;
}
if($plantime==5.6)
{
$comm=17.5;
}
if($plantime==8.3)
{
$comm=21.25;
}
if($plantime==11)
{
$comm=23;
}
if($plantime==15)
{
$comm=24;
}
}
IF($rank==8)
{
if($plantime==3.4)
{
$comm=16;
}
if($plantime==5.6)
{
$comm=19;
}
if($plantime==8.3)
{
$comm=23;
}
if($plantime==11)
{
$comm=25;
}
if($plantime==15)
{
$comm=26;
}
}
IF($rank==9)
{
if($plantime==3.4)
{
$comm=17;
}
if($plantime==5.6)
{
$comm=20.25;
}
if($plantime==8.3)
{
$comm=24.5;
}
if($plantime==11)
{
$comm=26.25;
}
if($plantime==15)
{
$comm=27.5;
}
}
IF($rank==10)
{
if($plantime==3.4)
{
$comm=18;
}
if($plantime==5.6)
{
$comm=21.5;
}
if($plantime==8.3)
{
$comm=25.5;
}
if($plantime==11)
{
$comm=27.5;
}
if($plantime==15)
{
$comm=28;
}
}
IF($rank==11)
{
$comm=5;
}
IF($rank==12)
{
$comm=5;
}
IF($rank==13)
{
$comm=5;
}
}
$commtot=$row[amount]*$comm/100;
$tot=$row[amount];
echo "<table width='800' border=\"1\" cellspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <col width='100'/>";
echo"<col width='160'/>";
echo"<col width='210'/>";
echo "<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo"<col width='100'/>";
echo " <tr bgcolor='#99CCCC'>\n";
echo " <td >$row[receipt2]</td>\n";
echo " <td>$row[cname] $row[cmidname] $row[csurname]</td>\n";
echo " <td >$row[acc_no]</td>\n";
echo " <td >$row[noofinstallment]</td>\n";
echo " <td >$row[branch_name]</td>\n";
echo " <td >$row[amount]</td>\n";
echo " <td >$row[planname]</td>\n";
echo " <td >$row[plantime]</td>\n";
echo " <td>$commtot</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
$totalt=$tot+$totalt;
$commtotalt=$commtotalt+$commtot;
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
echo "<table width='1000' border=\"0\" bg bgcolor='#FF9900' llspacing=\"2\" cellpadding=\"2\" style='table-layout:fixed'>\n";
echo " <tr>\n";
echo " <td>TOTAL BUSINESS</td>\n";
echo " <td>$totalt</td>\n";
echo " <td>TOTAL COMMISSION </td>\n";
echo " <td>$commtotalt</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
?>
</tr></table>
</body></center>
</html>
|