ads_admin.php

VIP信息处理系统源码

<?php

  if ($rowdroit['is_admin'] == 1)
  {
    $sqlfadmin = '';
  }
  else
  {
    $sqlowner = '' . 'select username from advertizer where adser_owner=\'' . $_SESSION['admin_username'] . '\'';
    $rsowner = mysql_query ($sqlowner);
    $sqlfadmin = ' and (';
    while ($rowner = mysql_fetch_array ($rsowner))
    {
      $sqlfadmin .= '' . 'username=\'' . $rowner['username'] . '\' or ';
    }

    $sqlfadmin = substr ($sqlfadmin, 0, strlen ($sqlfadmin) - 4) . ')';
  }

  if (!empty ($_POST['hnpassid']))
  {
    if (($_POST['op'] != 'comm' AND ((empty ($_POST['hnprofit']) OR $_POST['hnprofit'] <= 0) OR 1 < $_POST['hnprofit'])))
    {
      fun_alert ('利润率必须大于0且小于1！');
      fun_back ();
      exit ();
    }

    if (!empty ($_POST['hnopentype']))
    {
      $hnopenty = ($_POST['hnopentype'] == 1 ? 1 : 0);
      $sql_opentype = '' . ',open_type=' . $hnopenty;
    }

    $sql_opentype = '';
    $sql = '' . 'update `ads` set admin_stat=\'2\',ads_stat=\'2\',profit=\'' . $_POST['hnprofit'] . '\' ' . $sql_opentype . ' ,admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnpassid'] . '\' ' . $sqlfadmin;
    $rs = mysql_query ($sql);
    $sqla = '' . 'select * from ads where  id=\'' . $_POST['hnpassid'] . '\'';
    $rsa = mysql_query ($sqla);
    $rowa = mysql_fetch_array ($rsa);
    if ($rowa['ads_type'] == 3)
    {
      echo '<img src=make_leads.php width=0 height=0>';
    }

    echo ;
    if ($rs)
    {
      fun_alert ('审批成功！');
    }

    fun_alert ();
    fun_back ();
    exit ();
  }

  if (!empty ($_POST['hnstopid']))
  {
    $sqla = '' . 'select * from ads where  id=\'' . $_POST['hnstopid'] . '\'';
    $rsa = mysql_query ($sqla);
    $rowa = mysql_fetch_array ($rsa);
    $sql = '' . 'update `ads` set ads_stat=\'1\',admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnstopid'] . '\' ' . $sqlfadmin;
    $rs = mysql_query ($sql);
    if ($rowa['ads_type'] == 3)
    {
      $ff = 1;
      echo '<img src=make_leads.php width=0 height=0>';
    }

    echo '<img src=make_swapqueue.php width=0 height=0>';
    if (($rs AND $ff))
    {
      fun_alert ('暂停广告操作成功！');
    }

    fun_alert ();
    fun_back ();
    exit ();
  }

  if (!empty ($_POST['hnquashid']))
  {
    $sql = '' . 'update `ads` set ads_stat=\'3\',admin_time=\'' . $datetime . '\',admin_user=\'' . $_SESSION['admin_username'] . '\' where id=\'' . $_POST['hnquashid'] . '\' ' . $sqlfadmin;
    $rs = mysql_query ($sql);
    $sfname = '' . '../ads/' . $_POST['hnusername'] . '/adsstate_' . $_POST['hnquashid'] . '.php';
    $filestr = '<?	' . ('' . '$') . 'flag_normal=3;?>';
    $fp = fopen ('' . $sfname, 'w');
    flock ($fp, 3);
    $ff = fwrite ($fp, $filestr);
    fclose ($fp);
    echo '<img src=make_swapqueue.php width=0 height=0>';
    if (($rs AND $ff))
    {
      $sqla = '' . 'select * from ads where id=\'' . $_POST['hnquashid'] . '\'';
      $rsa = mysql_query ($sqla);
      $rowa = mysql_fetch_array ($rsa);
      $money = $rowa['spare'] * $rowa['price'] / 1000 * $rowa['profit'];
      $update = '' . 'update advertizer set balance=balance+' . $money . ' where username=\'' . $rowa['username'] . '\'';
      $rsup = mysql_query ($update);
      fun_alert ('' . $money . ' - ' . $sfname . ' - 撤消广告成功！');
    }

    fun_alert ();
    fun_back ();
    exit ();
  }

  if (!empty ($_POST['hndelid']))
  {
    $sql = '' . 'select * from ads where id=\'' . $_POST['hndelid'] . '\' ' . $sqlfadmin;
    $rs = mysql_query ($sql);
    $row = mysql_fetch_array ($rs);
    if (($row['ads_stat'] == '0' AND $row['admin_stat'] == '1'))
    {
      $update = '' . 'update advertizer set balance=balance+' . $row['money'] . ' where username=\'' . $row['username'] . '\'';
      $rsup = mysql_query ($update);
    }

    $rsup = 1;
    if ($rsup)
    {
      $sql = '' . 'delete from `ads` where id=\'' . $_POST['hndelid'] . '\' and ads_stat=\'0\' ' . $sqlfadmin;
      $rsd = mysql_query ($sql);
    }

    if ($rsd)
    {
      fun_alert ('删除成功！');
    }

    fun_alert ();
    fun_back ();
    exit ();
  }

  switch ($op)
  {
    case 'normal':
    {
      $title = '正常广告列表';
      $sql_stat = ' admin_stat=2 and ads_stat=2 and own_type=1';
      break;
    }

    case 'over':
    {
      $title = '暂停广告列表';
      $sql_stat = ' (ads_stat=1 or spare<=0) and own_type=1';
      break;
    }

    case 'quash':
    {
      $title = '撤消广告列表';
      $sql_stat = ' ads_stat=3 and own_type=1';
      break;
    }

    case 'all':
    {
      $title = '所有广告列表';
      $sql_stat = ' own_type=1';
      break;
    }

    case 'comm':
    {
      $title = '公益广告列表';
      $sql_stat = '  own_type=2';
      break;
    }

    default:
    {
      $title = '新广告审核';
      $sql_stat = ' admin_stat=1 and ads_stat=0 and own_type=1';
      break;
      if ()
      {
        $sqla = 'select * from ads_form where 1';
        $rsa = mysql_query ($sqla);
        while ($rowa = mysql_fetch_array ($rsa))
        {
          $a_id = $rowa['id'];
          $arr_adsformw[$a_id] = $rowa['width'];
          $arr_adsformh[$a_id] = $rowa['height'];
        }

        if (!empty ($txt_search))
        {
          $andwhere = '' . ' and (username like \'%' . $txt_search . '%\' or id = \'' . $txt_search . '\' or time like \'%' . $txt_search . '%\' or link_tit like \'%' . $txt_search . '%\') ';
        }

        $orderby = '';
        if (!empty ($or_name))
        {
          $orderby = ($or_name == '1' ? ' username asc,' : ' username desc,');
        }

        if (!empty ($or_time))
        {
          $orderby = ($or_time == '1' ? ' time asc,' : ' time desc,');
        }

        if (!empty ($or_type))
        {
          $orderby = ($or_type == '1' ? ' ads_form_id asc,ads_type asc,' : ' ads_form_id desc,ads_type desc,');
        }

        if (!empty ($or_totpub))
        {
          $orderby = ($or_totpub == '1' ? ' totpub,' : ' totpub desc,');
        }

        if (!empty ($or_spare))
        {
          $orderby = ($or_spare == '1' ? ' spare,' : ' spare desc,');
        }

        if (!empty ($or_price))
        {
          $orderby = ($or_price == '1' ? ' price asc,' : ' price desc,');
        }

        if (!empty ($or_rate))
        {
          $orderby = ($or_rate == '1' ? ' rate asc,' : ' rate desc,');
        }

        $pagesize = $cfg_adminpagesize;
        $list_count = '' . 'ads where ' . $sql_stat . ' ' . $andwhere . ' ' . $sqlfadmin;
        $sql = '' . 'select * from ads where ' . $sql_stat . ' ' . $andwhere . ' ' . $sqlfadmin . ' order by  ' . $orderby . ' id desc';
        include '../public/pagehead.php';
        $rs = mysql_query ($sql);
        $str_disp = '';
        while (true)
        {
          if ($row = mysql_fetch_array ($rs))
          {
            $atime = substr ($row['time'], 0, 10) . ' ' . substr ($row['time'], -8);
            $ads_stat = $row['ads_stat'];
            $ads_type = $row['ads_type'];
            $admin_stat = $row['admin_stat'];
            $own_type = $row['own_type'];
            $rate = $row['rate'] * 100;
            $ads_form_id = $row['ads_form_id'];
            if ($ads_type == 1)
            {
              $spec = '混合(' . $arr_adsformw[$ads_form_id] . '*' . $arr_adsformw[$ads_form_id] . ')';
            }

            $spec = ;
            if ($ads_stat == '3')
            {
              $dispass = ' disabled';
            }

            $dispass = ;
            if ((($ads_stat == '0' OR $ads_stat == '1') AND $admin_stat == '1'))
            {
              $str_admin = '' . '<input name=pass type=button id=pass class=subbt2 value=\'审批\' ' . $dispass . '><input name=delete type=button id=delete class=subbt2 value=\'删除\' onClick="del_sub(' . $row['id'] . ')">';
            }

            $str_admin = ;
            if ((($ads_stat == '2' OR $ads_stat == '1') AND $admin_stat == '2'))
            {
              $str_admin .= '' . '<input name=quash type=button id=quash class=subbt2 value=\'撤消\' onClick="quash_sub(\'' . $row['id'] . '\',\'' . $row['username'] . '\')">';
            }

            $str_admin .= '<input name=quash type=button id=quash class=subbt2 value=\'撤消\' disabled>';
            if ($own_type == 2)
            {
              $str_admin = '' . '<input name=pass type=button id=pass class=subbt2 value=\'审批\' onClick="pass_sub(' . $row['id'] . ')"><input name=eidt type=button id=eidt class=subbt2 value=\'修改\' onClick="location=\'admin.php?tm=2&nid=30&nm=ads_comm_add&edit_id=' . $row['id'] . '\';"><input name=delete type=button id=delete class=subbt2 value=\'删除\' onClick="del_sub(' . $row['id'] . ')">';
            }

            $str_disp .= '' . '
        <tr align=center class="listbody_admin">