<?php
include './../../include/session.php';
include './../../include/conn.php';
include './../../include/myfunction.php';
include './../../include/adfunction.php';
include './../../include/page.class.php';
$currentPage = 'PaiMaiList';
$manageGroup = 'hezuoGroup';
if (isset($_GET['html'])) {
//$html=1&week=1
$gethtml = $_GET['html'];
if ($gethtml == 1) {
$getweek = $_GET['week'];
if (htmlAD('userpp', $getweek, 1)) {
$fphtml = "生成成功";
}
}
}
if (isset($_GET['delete'])) {
if ($_GET['delete'] == 1) {
$deleteid = $_GET['id'];
if (!empty($deleteid)) {
$sql = "delete from ad_paimai where id={$deleteid}";
mysql_query($sql);
$result = mysql_affected_rows();
if ($result > 0) {
$msn = "删除成功";
}
}
}
function autoad($endtime, $getweek)
{
if (time() > $endtime) {
$sql = "select b.name as adpsname,c.name as ppusname,c.jifen as usjifen,a.* from ad_paimai as a left join ad_type as b on a.week=b.week left join user as c on a.userid=c.id where a.status=1 and a.week={$getweek}";
$result = mysql_query($sql);
$ppcount = mysql_num_rows($result);
if ($ppcount > 0) {
while ($row = mysql_fetch_assoc($result)) {
$adid['id'][] = $row['id'];
$adid['title'][] = $row['title'];
$adid['link'][] = $row['link'];
$adid['pic_url'][] = $row['pic_url'];
$adid['week'][] = $row['week'];
$adid['ad_start_time'][] = $row['ad_start_time'];
$adid['ad_end_time'][] = $row['ad_end_time'];
$adid['userid'][] = $row['userid'];
$adid['adpsname'][] = $row['adpsname'];
$adid['jifen'][] = $row['jifen'];
$adid['ppusname'][] = $row['ppusname'];
$adid['usjifen'][] = $row['usjifen'];
}
foreach ($adid['id'] as $key => $idvalue) {
if (Zbkupdate('ad_paimai', array('status' => 2), "status=1 and id={$idvalue} and week={$getweek}")) {
$sql = "select week from ad where week=" . $adid['week'][$key];
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
Zbkinsert('jifen_log', array('name' => $adid['ppusname'][$key], 'jifen' => -$adid['jifen'][$key], 'XiaoJi' => $adid['usjifen'][$key], 'create_time' => time(), 'jf_mingxi' => '竞拍广告位中标扣除积分'));
if ($row['week']) {
Zbkupdate('ad', array('status' => 2, 'name' => $adid['adpsname'][$key], 'pp_id' => $adid['id'][$key], 'userid' => $adid['userid'][$key], 'title' => $adid['title'][$key], 'link' => $adid['link'][$key], 'pic_url' => $adid['pic_url'][$key], 'week' => $adid['week'][$key], 'ad_start_time' => $adid['ad_start_time'][$key], 'ad_end_time' => $adid['ad_end_time'][$key]), 'week=' . $adid['week'][$key]);
htmlAD('userpp', $getweek, 1);
} else {
Zbkinsert('ad', array('status' => 2, 'name' => $adid['adpsname'][$key], 'pp_id' => $adid['id'][$key], 'userid' => $adid['userid'][$key], 'title' => $adid['title'][$key], 'link' => $adid['link'][$key], 'pic_url' => $adid['pic_url'][$key], 'week' => $adid['week'][$key], 'ad_start_time' => $adid['ad_start_time'][$key], 'ad_end_time' => $adid['ad_end_time'][$key]));
htmlAD('userpp', 'getweek', 1);
}
}
}
}
}
}
