rakeoff_coll.php

VIP信息处理系统源码

<?php

  echo '<table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" bgcolor="#CCCCCC" >
  <tr bgcolor="F0F0F0"><form name="form1" method="post" action="">
    <td width="130" height="30"><div align="center">
        推荐人佣金结算</div></td>
    <td width="873"><table width="45%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
   ';
  echo '     <td width="40%" align="right">请选择结算日期：</td>
        <td width="11%">';
  echo '<s';
  echo 'elect name="o_yy">
            ';
  if (date ('m') == '01')
  {
    $o_this_y = date ('Y') - 1;
  }
  else
  {
    $o_this_y = date ('Y');
  }

  if (date ('m') == '01')
  {
    $o_this_m = 12;
  }
  else
  {
    $o_this_m = date ('m') - 1;
  }

  for ($o_j = 2005; $o_j <= date ('Y'); ++$o_j)
  {
    if (empty ($o_yy))
    {
      $o_yy = $o_this_y;
    }
    else
    {
      $o_yy = $o_yy;
    }

    if ($o_yy == $o_j)
    {
      $o_sldy = 'selected';
    }
    else
    {
      $o_sldy = '';
    }

    echo '' . '<option ' . $o_sldy . '>' . $o_j . '</option>';
  }

  echo '        </select></td>
        <td width="4%">年</td>
        <td width="11%">';
  echo '<s';
  echo 'elect name="o_mm">
            ';
  for ($o_i = 1; $o_i <= 12; ++$o_i)
  {
    if ($o_i <= 9)
    {
      $o_k = '0' . $o_i;
    }
    else
    {
      $o_k = $o_i;
    }

    if (empty ($o_mm))
    {
      $o_mm = $o_this_m;
    }
    else
    {
      $o_mm = $o_mm;
    }

    if ($o_mm == $o_k)
    {
      $o_sld = 'selected';
    }
    else
    {
      $o_sld = '';
    }

    echo '' . '<option ' . $o_sld . '>' . $o_k . '</option>';
  }

  echo '        </select></td>
        <td width="4%">月</td>
        <td width="30%">&nbsp;<input type="submit" name="Submit" value="提交" class="subbt2"></td>
      </tr>
    </table></td>
  </form></tr>
</table>
';
  if ($_POST['Submit'] == '提交')
  {
    $str_ymday = '' . $_POST['o_yy'] . '-' . $_POST['o_mm'];
    $now_ymday = date ('Y-m');
    if ($now_ymday <= $str_ymday)
    {
      echo '<p><font color=ff3300>请选择小于本月的日期结算！</font>';
    }
    else
    {
      $mm = $_POST['o_mm'] + 1;
      $ymday1 = '' . $_POST['o_yy'] . '-' . $_POST['o_mm'] . '-01';
      $ymday2 = date ('Y-m-d', strtotime ('' . $_POST['o_yy'] . '-' . $mm . '-01') - 86400);
      $sqlf = '' . 'select * from payed where (pay_date>=\'' . $ymday1 . '\' and pay_date<=\'' . $ymday2 . '\') and (pay_type=3 or pay_type=4)';
      $rsf = mysql_query ($sqlf);
      $numf = mysql_num_rows ($rsf);
      if (0 < $numf)
      {
        echo '' . '<p>' . $ymday1 . ' 至 ' . $ymday2 . ' 已结转！</p>';
      }
      else
      {
        $sqlw = 'select * from admin where type=1';
        $rsw = mysql_query ($sqlw);
        while ($roww = mysql_fetch_array ($rsw))
        {
          $sqla = '' . 'select * from advertizer where adser_owner=\'' . $roww['username'] . '\'';
          $rsa = mysql_query ($sqla);
          $rowa = mysql_fetch_array ($rsa);
          $sqlf_user = '' . ' and (adser_user=\'' . $rowa['username'] . '\' ';
          while ($rowa = mysql_fetch_array ($rsa))
          {
            $sqlf_user .= '' . ' or adser_user=\'' . $rowa['username'] . '\' ';
          }

          $sqlf_user .= ')';
          $sql = '' . 'select sum(adser_money-web_money) as profit from daydata where date>=\'' . $ymday1 . '\' and date <=\'' . $ymday2 . '\' ' . $sqlf_user;
          $rs = mysql_query ($sql);
          $row = mysql_fetch_array ($rs);
          $money = round ($roww['profit'] * $row['profit'] * 100) / 100;
          if (0 < $money)
          {
            $insert = '' . 'insert into `payed`(`username`,`pay_type`,`ought_money`,`pay_date`,`admin_stat`) values(\'' . $roww['username'] . '\',\'3\',\'' . $money . '\',\'' . $ymday2 . '\',\'1\')';
            $rsi = mysql_query ($insert);
            if ($rsi)
            {
              echo '' . '广告主推荐人结算 ' . $roww['username'] . ' - ' . $ymday2 . ' = ' . $money . ' - success!<br>';
              continue;
            }
            else
            {
              echo '' . '广告主推荐人结算 ' . $roww['username'] . ' - ' . $ymday2 . ' = ' . $money . ' - fail!<br>';
              continue;
            }

            continue;
          }
          else
          {
            echo '' . '广告主推荐人结算 ' . $roww['username'] . ' 无 ' . $ymday1 . ' 至 ' . $ymday2 . ' 记录！<br>';
            continue;
          }
        }

        while (list ($k, $v) = each ($cfg_arrrecomm))
        {
          $sqldown = '' . 'select sum(open_num+click_num) as totnum,sum(web_money) as tot_money from daydata,webmember where date>=\'' . $ymday1 . '\' and date<=\'' . $ymday2 . '\' and web_user=username and up_user=\'' . $v . '\' and daydata.own_type=1';
          $rsdown = mysql_query ($sqldown);
          $rowdown = mysql_fetch_array ($rsdown);
          $totnum = $rowdown['totnum'];
          $tot_money = $rowdown['tot_money'];
          if (0 < $totnum)
          {
            $insertd = '' . 'insert into `payed`(`username`,`pay_type`,`ought_money`,`down_money`,`pay_date`,`admin_stat`) values(\'' . $v . '\',\'4\',\'' . $tot_money . '\',\'' . $totnum . '\',\'' . $ymday2 . '\',\'1\')';
            $rsd = mysql_query ($insertd);
            if ($rsd)
            {
              echo '' . '网站主推荐人结算 ' . $v . ' - ' . $ymday2 . ' - 总数 = ' . $totnum . ' - 总金额 = ' . $tot_money . ' - success!<br>';
              continue;
            }
            else
            {
              echo '' . '网站主推荐人结算 ' . $v . ' - ' . $ymday2 . ' - 总数 = ' . $totnum . ' - 总金额 = ' . $tot_money . ' - fail!<br>';
              continue;
            }

            continue;
          }
        }
      }
    }
  }

?>