function delete()
{
$id = hg_filter_ids(urldecode($this->input['id']));
if (!$id) {
$this->errorOutput(OBJECT_NULL);
}
$sql = "DELETE FROM " . DB_PREFIX . "webapp_rank WHERE id IN(" . $id . ")";
$this->db->query($sql);
$this->addItem($id);
$this->output();
}
public function delete()
{
$ids = trim(urldecode($this->input['id']));
$ids = hg_filter_ids($ids);
if (empty($ids)) {
$this->errorOutput(OBJECT_NULL);
}
$result = $this->webapp->delete($ids);
$this->addItem($result);
$this->output();
}
public function get_condition()
{
$conditions = ' AND fid = ' . intval($this->input['fid']);
if (isset($this->input['k']) && !empty($this->input['k'])) {
// $condition .= ' AND name like \'%'.urldecode($this->input['k']).'%\'';
}
if (isset($this->input['id']) && $this->input['id']) {
$this->input['id'] = hg_filter_ids($this->input['id']);
$conditions .= ' AND id IN(' . trim(urldecode($this->input['id'])) . ')';
}
return $conditions;
}
private function get_condition()
{
$condition = ' AND status = 1';
if (isset($this->input['k']) && !empty($this->input['k'])) {
$condition .= ' AND name like \'%' . trim($this->input['k']) . '%\'';
}
if (isset($this->input['id']) && $this->input['id']) {
$this->input['id'] = hg_filter_ids($this->input['id']);
$condition .= " AND id IN (" . trim($this->input['id']) . ")";
}
if (isset($this->input['channel_id']) && $this->input['channel_id']) {
$this->input['channel_id'] = hg_filter_ids($this->input['channel_id']);
$condition .= " AND id IN (" . trim($this->input['channel_id']) . ")";
}
if (isset($this->input['is_mobile_phone'])) {
$condition .= " AND is_mobile_phone = " . intval($this->input['is_mobile_phone']);
}
if (isset($this->input['is_control'])) {
$condition .= " AND is_control = " . intval($this->input['is_control']);
}
if (isset($this->input['is_audio'])) {
$condition .= " AND is_audio = " . intval($this->input['is_audio']);
}
if (intval($this->input['get_record'])) {
$condition .= " AND can_record = 1";
}
if (isset($this->input['audio_only'])) {
$condition .= " AND is_audio = " . intval($this->input['audio_only']);
}
if (isset($this->input['is_sys']) && intval($this->input['is_sys']) != -1) {
$condition .= " AND is_sys = " . intval($this->input['is_sys']);
}
if (isset($this->input['server_id'])) {
$condition .= " AND server_id = " . intval($this->input['server_id']);
}
return $condition;
}
function get_condition()
{
$condition = '';
//默认只搜索出所有全局的广告内容
if ($this->input['group']) {
$group = explode(',', trim(urldecode($this->input['group'])));
if ($group && !array_diff($group, $this->settings['hg_ad_flag'])) {
$condition .= ' AND `group` in("' . implode('","', $group) . '")';
} else {
$condition .= ' AND `group` in("website")';
}
}
//广告位ID条件
if ($this->input['pid']) {
$pids_str = hg_filter_ids($this->input['pid']);
$condition .= ' AND p.pos_id in(' . $pids_str . ')';
}
/*
//广告位英文标识
if($this->input['flag'])
{
$condition .= ' AND p.pos_flag in("'.str_replace(',', '","',trim(urldecode($this->input['flag']))).'")';
}
//广告位内容ID
if($this->input['aid'])
{
$condition .= ' AND p.ad_id in('.trim(urldecode($this->input['aid'])).')';
}
//广告动画ID
if($this->input['aniid'])
{
$condition .= ' AND p.ani_id in('.trim(urldecode($this->input['aniid'])).')';
}
//发布策略ID
if($this->input['id'])
{
$condition .= ' AND p.id in('.trim(urldecode($this->input['id'])).')';
}
//有效广告 时间段
if(!$this->input['preview'])
{
$condition .= ' AND c.start_time <= '.TIMENOW;
$condition .= ' AND c.status=1 ';
}
*/
//只读取分组启用的数据
$condition .= ' AND g.is_use = 1 and c.status IN(1,3)';
return $condition;
}
private function get_condition()
{
$condition = ' AND status = 1';
if (isset($this->input['k']) && !empty($this->input['k'])) {
$condition .= ' AND name like \'%' . trim($this->input['k']) . '%\'';
}
if (isset($this->input['id']) && $this->input['id']) {
$this->input['id'] = hg_filter_ids($this->input['id']);
$condition .= " AND id IN (" . trim($this->input['id']) . ")";
}
if (isset($this->input['channel_id']) && $this->input['channel_id']) {
$this->input['channel_id'] = hg_filter_ids($this->input['channel_id']);
$condition .= " AND id IN (" . trim($this->input['channel_id']) . ")";
}
if (isset($this->input['code']) && $this->input['code']) {
$condition .= " AND code = '" . trim($this->input['code']) . "' ";
}
if (isset($this->input['is_mobile_phone'])) {
$condition .= " AND is_mobile_phone = " . intval($this->input['is_mobile_phone']);
}
if (isset($this->input['is_control'])) {
$condition .= " AND is_control = " . intval($this->input['is_control']);
}
if (intval($this->input['get_record'])) {
$condition .= " AND can_record = 1";
}
if (isset($this->input['is_audio'])) {
$condition .= " AND is_audio = " . intval($this->input['is_audio']);
}
if (isset($this->input['audio_only'])) {
$condition .= " AND is_audio = " . intval($this->input['audio_only']);
}
if (isset($this->input['status'])) {
$condition .= " AND status = " . intval($this->input['status']);
}
if (isset($this->input['not_id']) && $this->input['not_id']) {
$condition .= " AND id NOT IN (" . trim($this->input['not_id']) . ")";
}
if (isset($this->input['node_id']) && $this->input['node_id']) {
$sql = "SELECT * FROM " . DB_PREFIX . "channel_node WHERE id IN(" . trim($this->input['node_id']) . ")";
$q = $this->db->query($sql);
$all_node = $space = '';
while ($row = $this->db->fetch_array($q)) {
if ($row['childs']) {
$all_node .= $space . $row['childs'];
$space = ',';
}
}
if ($all_node) {
$all_node .= ',' . trim($this->input['node_id']);
$node_id = implode(',', array_unique(explode(',', $all_node)));
} else {
$node_id = trim($this->input['node_id']);
}
$condition .= " AND node_id IN (" . $node_id . ")";
}
if (isset($this->input['server_id'])) {
$condition .= " AND server_id = " . intval($this->input['server_id']);
}
return $condition;
}
public function get_content_condition($to_count = false)
{
$condition = $other_field = '';
$condition .= " WHERE 1 ";
if ($client_type = intval($this->input['client_type'])) {
$condition .= " AND cr.client_type='" . $client_type . "'";
}
$condition .= " AND r.is_complete=1 ";
if ($this->settings['is_need_audit']) {
$condition .= " AND r.status=1";
}
//支持多个栏目
if ($min_id = intval($this->input['min_id'])) {
$condition .= " AND r.id>" . $min_id;
}
if ($this->input['id']) {
$ids = hg_filter_ids($this->input['id']);
$condition .= " AND r.id IN (" . $ids . ')';
}
if ($site_id = intval($this->input['site_id'])) {
$condition .= " AND r.site_id=" . $site_id;
}
$column_id = urldecode($this->input['column_id']);
if (!$column_id && ($column_name = trim($this->input['column_name']))) {
$fid = intval($this->input['fid']);
$column_name = explode(',', $column_name);
if (!$this->input['child_column']) {
$sql = 'SELECT parents FROM ' . DB_PREFIX . "column WHERE id=" . $fid;
$info = $this->db->query_first($sql);
if ($info['parents']) {
$parents = explode(',', $info['parents']);
$fid = $parents[count($parents) - 1];
}
if ($fid) {
$sql = 'SELECT id FROM ' . DB_PREFIX . "column WHERE concat(',', parents, ',') LIKE '%," . $fid . ",%' AND name IN ('" . implode("','", $column_name) . "')";
} else {
$sql = 'SELECT id FROM ' . DB_PREFIX . "column WHERE name IN ('" . implode("','", $column_name) . "')";
}
} else {
$sql = 'SELECT id FROM ' . DB_PREFIX . "column WHERE fid={$fid} AND name IN ('" . implode("','", $column_name) . "')";
}
$tmp_column = array();
$info = $this->db->query($sql);
while ($row = $this->db->fetch_array($info)) {
$tmp_column[] = $row['id'];
}
$column_id = implode(',', $tmp_column);
if (!$column_id && $fid) {
$column_id = $fid;
}
}
if ($column_id) {
$column_ids = '';
$column_id = explode(',', $column_id);
$column_id = "'" . implode("','", $column_id) . "'";
if (!$this->input['not_need_child_column']) {
$columns_data = $this->column->get_column_by_id(' id,name,fid,parents,childs,content_num ', $column_id, 'id');
$tag = '';
if (is_array($columns_data) && $columns_data) {
foreach ($columns_data as $k => $v) {
$column_ids .= $tag . $v['childs'];
$tag = ',';
}
}
} else {
$column_ids = $column_id;
}
if ($column_ids) {
$column_idarr = @array_unique(explode(',', $column_ids));
$column_ids = implode(',', $column_idarr);
$condition .= " AND r.column_id in (" . $column_ids . ")";
} else {
$this->errorOutput(NO_COLUMN_ID);
}
}
if ($bundle_id = urldecode($this->input['bundle_id'])) {
$bundle_idarr = explode(',', $bundle_id);
$condition .= " AND r.bundle_id in ('" . implode("','", $bundle_idarr) . "')";
}
if ($this->input['exclude_special']) {
$condition .= " AND r.bundle_id != '" . $this->input['exclude_special'] . "'";
}
if ($this->input['exclude_bundle']) {
$exclude_bundle = explode(',', $this->input['exclude_bundle']);
$condition .= " AND r.bundle_id NOT IN('" . implode("','", $exclude_bundle) . "')";
}
if ($module_id = urldecode($this->input['module_id'])) {
$condition .= " AND r.module_id='" . $module_id . "'";
}
if (isset($this->input['weight']) && $this->input['weight'] !== '' && $this->input['weight'] != -1) {
$condition .= " AND r.weight='" . intval($this->input['weight']) . "'";
}
if ($exclude_id = $this->input['exclude_id']) {
$condition .= " AND r.content_id not in (" . $exclude_id . ")";
}
if ($cid = $this->input['cid']) {
$cid = hg_filter_ids($this->input['cid']);
$condition .= " AND r.content_id in (" . $cid . ")";
}
//查询权重
if (isset($this->input['start_weight']) && intval($this->input['start_weight']) >= 0) {
$condition .= " AND r.weight >= " . $this->input['start_weight'];
}
if (isset($this->input['end_weight']) && intval($this->input['end_weight']) >= 0) {
$condition .= " AND r.weight <= " . $this->input['end_weight'];
}
if (isset($this->input['except_weight']) && $this->input['except_weight'] !== '') {
$condition .= " AND r.weight != " . intval($this->input['except_weight']);
}
if (isset($this->input['is_have_indexpic']) && $this->input['is_have_indexpic'] !== '') {
$condition .= " AND r.is_have_indexpic=" . intval($this->input['is_have_indexpic']);
}
if (isset($this->input['is_have_video']) && $this->input['is_have_video'] !== '') {
$condition .= " AND r.is_have_video=" . intval($this->input['is_have_video']);
}
if ($start_time = trim(urldecode($this->input['starttime']))) {
if ($start_time = strtotime($start_time)) {
$condition .= " AND r.publish_time >= '" . $start_time . "'";
}
}
if ($end_time = trim(urldecode($this->input['endtime']))) {
if ($end_time = strtotime($end_time)) {
$condition .= " AND r.publish_time <= '" . $end_time . "'";
}
}
if ($create_user = trim($this->input['create_user'], ' ')) {
$condition .= " AND r.create_user='******'create_user'] . "' ";
}
if ($publish_user = trim($this->input['publish_user'], ' ')) {
$condition .= " AND r.publish_user='******'publish_user'] . "' ";
}
//查询发布的时间
if ($this->input['date_search']) {
$today = strtotime(date('Y-m-d'));
$tomorrow = strtotime(date('Y-m-d', TIMENOW + 24 * 3600));
switch (intval($this->input['date_search'])) {
case 1:
//所有时间段
break;
case 2:
//昨天的数据
$yesterday = strtotime(date('y-m-d', TIMENOW - 24 * 3600));
$condition .= " AND r.publish_time > '" . $yesterday . "' AND r.publish_time < '" . $today . "'";
break;
case 3:
//今天的数据
$condition .= " AND r.publish_time > '" . $today . "' AND r.publish_time < '" . $tomorrow . "'";
break;
case 4:
//最近3天
$last_threeday = strtotime(date('y-m-d', TIMENOW - 2 * 24 * 3600));
$condition .= " AND r.publish_time > '" . $last_threeday . "' AND r.publish_time < '" . $tomorrow . "'";
break;
case 5:
//最近7天
$last_sevenday = strtotime(date('y-m-d', TIMENOW - 6 * 24 * 3600));
$condition .= " AND r.publish_time > '" . $last_sevenday . "' AND r.publish_time < '" . $tomorrow . "'";
break;
default:
//所有时间段
break;
}
}
//标题
if ($this->input['k'] || $this->input['title']) {
$title = $this->input['title'] ? $this->input['title'] : $this->input['k'];
$title = $this->get_titleResult($title . ' ');
if ($title) {
if ($this->settings['App_textsearch'] && !$this->input['normal_search']) {
$condition .= " AND MATCH (title_unicode) AGAINST ('" . $title . "' IN BOOLEAN MODE )";
$other_field = ",MATCH (title_unicode) AGAINST ('" . $title . "' IN BOOLEAN MODE ) AS title_score";
} else {
$condition .= " AND r.title_unicode like '%" . $title . "%'";
$not_use_title_score = true;
}
}
}
if ($keywords = urldecode($this->input['keywords'])) {
$keywordsstr = str_utf8_unicode($keywords);
if ($keywordsstr) {
if ($this->settings['App_textsearch'] && !$this->input['normal_search']) {
$condition .= " AND MATCH (keywords_unicode) AGAINST ('" . $keywordsstr . "' IN BOOLEAN MODE )";
$other_field = ",MATCH (keywords_unicode) AGAINST ('" . $keywordsstr . "' IN BOOLEAN MODE ) AS score";
} else {
$condition .= " AND r.keywords_unicode like '%" . $keywordsstr . "%'";
$not_use_score = true;
}
}
}
if ($title_pinyin_str = urldecode($this->input['spell_title'])) {
$title_pinyin_str = get_spell_title($title_pinyin_str);
if ($title_pinyin_str) {
$condition .= " AND MATCH (title_pinyin) AGAINST ('" . $title_pinyin_str . "' IN BOOLEAN MODE )";
$other_field = ",MATCH (title_pinyin) AGAINST ('" . $title_pinyin_str . "' IN BOOLEAN MODE ) AS title_pinyin";
}
}
if ($this->input['need_group_cid']) {
$condition .= " GROUP BY r.content_id ";
}
if (!$to_count) {
$order_tag = true;
$condition .= " ORDER BY ";
if ($keywordsstr && !$not_use_score) {
$condition .= " score DESC ";
$order_tag = false;
} else {
if ($title && !$not_use_title_score) {
$condition .= " title_score DESC ";
$order_tag = false;
} else {
if ($spell_title_str) {
$condition .= " title_pinyin DESC ";
$order_tag = false;
}
}
}
//排序
if ($sort_field = urldecode($this->input['sort_field'])) {
if (in_array($sort_field, array('weight', 'id', 'order_id', 'publish_time'))) {
$condition .= ($order_tag ? " " : ",") . 'r.' . $sort_field . ' ';
$order_tag = false;
if ($sort_type = urldecode($this->input['sort_type'])) {
$condition .= in_array($sort_type, $this->settings['sort_keyword']) ? $sort_type : 'DESC';
}
if ($sort_field == 'weight') {
$condition .= ' ,r.order_id DESC';
}
} else {
if (in_array($sort_field, $this->settings['content_field'])) {
$condition .= ($order_tag ? " " : ",") . 'r.' . $sort_field . ' ';
$order_tag = false;
if ($sort_type = urldecode($this->input['sort_type'])) {
$condition .= in_array($sort_type, $this->settings['sort_keyword']) ? $sort_type : 'DESC';
}
} else {
$condition .= ($order_tag ? ' ' : ',') . "r.publish_time DESC ";
$order_tag = false;
}
}
} else {
$condition .= ($order_tag ? ' ' : ',') . "r.order_id DESC ";
}
//$condition .= ($order_tag ? ' ' : ',') . "cr.id DESC ";
}
$result['condition'] = $condition;
$result['other_field'] = $other_field;
return $result;
}
