$name = isset($_POST["name"][$id]) ? $_POST["name"][$id] : '';
$title = isset($_POST["title"][$id]) ? $_POST["title"][$id] : '';
$alias = isset($_POST["alias"][$id]) ? $_POST["alias"][$id] : '';
$week = isset($_POST["week"][$id]) ? $_POST["week"][$id] : '';
$jifen = isset($_POST["jifen"][$id]) ? $_POST["jifen"][$id] : '';
if ($alias == "" || $name == "") {
$error[] = $name . '【信息未写完整】！';
} else {
$sql = 'SELECT * FROM `ad_type` WHERE `alias`="' . $alias . '" AND `id`<>"' . $id . '"';
$rs = $pdo->query($sql);
$row = $rs->fetchAll();
//取得所有记录
$count = count($row);
if ($count == 0) {
$row = array('title' => $title, 'alias' => $alias, 'name' => $name, 'week' => $week, 'jifen' => $jifen);
$result = AdTypeModel::model()->update(array('id' => $id), $row);
$totalExec += $result;
} else {
$error[] = $name . '【名称重复】！';
}
}
}
$updateMessage = "更新" . $totalExec . "条数据";
}
//删除单个数据
$delflag = $_GET["delflag"];
if ($delflag == 1) {
$id = $_GET["id"];
$sql = "DELETE FROM `ad_type` WHERE `id`={$id}";
$result = $pdo->exec($sql);
if ($result > 0) {
$zhuyi = isset($_POST['zhuyi']) ? $_POST['zhuyi'] : '';
$ad_size = isset($_POST['ad_size']) ? $_POST['ad_size'] : '498X90';
$content = isset($_POST['content']) ? $_POST['content'] : '';
$status_time = isset($_POST['status_time']) ? $_POST['status_time'] : 10;
$end_time = isset($_POST['end_time']) ? $_POST['end_time'] : 17;
$status = isset($_POST['status']) ? $_POST['status'] : 1;
$Uptime = isset($_POST['Uptime']) ? $_POST['Uptime'] : 17;
$pp_starttime = isset($_POST['pp_starttime']) ? strtotime(trim($_POST['pp_starttime'])) : time();
$pp_endtime = isset($_POST['pp_endtime']) ? strtotime(trim($_POST['pp_endtime'])) : time();
$up_tarttime = isset($_POST['up_tarttime']) ? strtotime(trim($_POST['up_tarttime'])) : time();
$up_endtime = isset($_POST['up_endtime']) ? strtotime(trim($_POST['up_endtime'])) : time();
if ($name == "" || $alias == "") {
$createMessage = "请把信息填写完整！！";
} else {
$sql = 'SELECT * FROM `ad_type` WHERE `alias`="' . $alias . '" AND `id`<>"' . $id . '"';
$rs = $pdo->query($sql);
$row = $rs->fetchAll();
//取得所有记录
$count = count($row);
if ($count == 0) {
$lastetId = AdTypeModel::model()->create($_POST);
if ($lastetId != FALSE) {
$createMessage = "添加成功";
} else {
$createMessage = "添加失败";
}
} else {
$createMessage = '【名称】或者【标题】或者【系统别名】重复！';
}
}
}
