function get_tag_gxcms($tag) { $table = !empty($tag['name']) ? trim($tag['name']) : 'video'; $field = !empty($tag['field']) ? trim($tag['field']) : '*'; $limit = !empty($tag['limit']) ? trim($tag['limit']) : '10'; if ($table == 'self' && !$tag['order']) { $tag['order'] = 'orders desc'; } $order = !empty($tag['order']) ? trim($tag['order']) : 'addtime desc'; if ($table != 'link' && $table != 'self') { $where['status'] = array('eq', 1); } if ($tag['time']) { $where['addtime'] = array('gt', xtime($tag['time'])); } if ($tag['hits']) { $hits = explode(',', trim($tag['hits'])); if (count($hits) > 1) { $where['hits'] = array('between', $hits[0] . ',' . $hits[1]); } else { $where['hits'] = array('gt', $hits[0]); } } //根据索引规则放置CID前 if ($tag['cid']) { $cids = explode(',', trim($tag['cid'])); if ($table == 'self') { $where['cid'] = array('eq', $tag['cid']); } else { if (count($cids) > 1) { $where['cid'] = array('in', get_channel_remove($cids)); } else { $where['cid'] = get_channel_sqlin($tag['cid']); } } } if ($tag['sid']) { $sid = $tag['sid']; $sidArr = explode(',', $sid); if (count($sidArr > 0)) { foreach ($sidArr as $v) { $where['_string'] = "FIND_IN_SET('{$v}',stype_mcid)"; } } else { $where['_string'] = "FIND_IN_SET('{$sid}',stype_mcid)"; } } if ($tag['ids']) { $where['id'] = array('in', trim($tag['ids'])); } if ($tag['stars']) { $where['stars'] = array('in', trim($tag['stars'])); } if ($tag['letter']) { $where['letter'] = array('eq', trim($tag['letter'])); } if ($tag['keyword']) { $keyword = trim($tag['keyword']); $where['title'] = array('like', '%' . $keyword . '%'); } if ($tag['serial'] && $table == 'video') { $serial = trim($tag['serial']); if ('all' == $serial) { $where['serial'] = array('neq', 0); } else { $where['serial'] = array('gt', $serial); } } if ($tag['up']) { $up = explode(',', trim($tag['up'])); if (count($up) > 1) { $where['up'] = array('between', $up[0] . ',' . $up[1]); } else { $where['up'] = array('gt', $up[0]); } } if ($tag['down']) { $down = explode(',', trim($tag['down'])); if (count($down) > 1) { $where['down'] = array('between', $down[0] . ',' . $down[1]); } else { $where['down'] = array('gt', $down[0]); } } if ($tag['score']) { $score = explode(',', trim($tag['score'])); if (count($score) > 1) { $where['score'] = array('between', $score[0] . ',' . $score[1]); } else { $where['score'] = array('gt', $score[0]); } } if ($tag['scoreer']) { $scoreer = explode(',', trim($tag['scoreer'])); if (count($scoreer) > 1) { $where['scoreer'] = array('between', $scoreer[0] . ',' . $scoreer[1]); } else { $where['scoreer'] = array('gt', $scoreer[0]); } } $rs = M($table); $list = $rs->field($field)->where($where)->order($order)->limit($limit)->select(); //dump($rs->getLastSql()); if ('special' == $table) { foreach ($list as $key => $val) { $list[$key]['readurl'] = get_read_url($table, $list[$key]['id'], $list[$key]['cid']); $list[$key]['logo'] = get_img_url($list[$key]['logo']); $list[$key]['banner'] = get_img_url_s($list[$key]['banner']); } } else { foreach ($list as $key => $val) { $list[$key]['showname'] = get_channel_name($list[$key]['cid']); $list[$key]['showurl'] = get_show_url($table, array('id' => $list[$key]['cid']), 1); $list[$key]['readurl'] = get_read_url($table, $list[$key]['id'], $list[$key]['cid'], $list[$key]['jumpurl']); $list[$key]['playerurl'] = get_play_url($list[$key]['id'], $list[$key]['cid'], 1); $list[$key]['picurlsmall'] = get_img_url_s($list[$key]['picurl'], $list[$key]['content']); $list[$key]['picurl'] = get_img_url($list[$key]['picurl'], $list[$key]['content']); } } if ($table == 'special') { var_dump($list); } return $list; }
public function infoday() { $this->checkhtml(C('url_html'), '文章内容'); echo '<div class="htmllist" id="show" style="font-size:12px;">'; $aday = intval($_REQUEST['aday']); $where['status'] = array('eq', 1); $where['addtime'] = array('gt', xtime($aday)); $count = $this->InfoDB->where($where)->count('id'); $listRows = C('url_create_num'); $totalpages = ceil($count / $listRows); $nowpage = !empty($_GET['page']) ? $_GET['page'] : 1; $nowpage = intval($nowpage); $list = $this->InfoDB->where($where)->order('addtime desc')->limit($listRows)->page($nowpage)->select(); if (empty($list)) { $this->assign("jumpUrl", C('cms_admin') . '?s=Admin/Html/Show'); $this->error('今日没有更新数据,暂不需要生成!'); } foreach ($list as $key => $value) { $this->createinfo($value); } echo '</div><script>document.getElementById("show").style.display="none";</script>'; if ($nowpage < $totalpages) { //是否生成完成 $this->assign("jumpUrl", C('cms_admin') . '?s=Admin/Html/Infoday/page/' . ($nowpage + 1) . '/aday/' . $aday); $this->success('第(' . $nowpage . ')页已经完成,正在准备下一个,请稍等!'); } else { $this->assign("jumpUrl", C('cms_admin') . '?s=Admin/Html/Infoshow/asid/0'); $this->success('恭喜您!今日更新的新闻资讯已经生成完毕!正在准备生成新闻栏目页,请稍等!'); } }
function get_color_date($type = 'Y-m-d H:i:s', $time, $color = 'red') { if ($time > xtime(1)) { return '<font color="' . $color . '">' . date($type, $time) . '</font>'; } else { return date($type, $time); } }
/** * 采集影片入库管理 * @param $act */ function Inflow($act) { if ($act == 'inflow') { if (empty($_POST['ids'])) { $this->error = '请选择需入库影片!'; return false; } $ArrID = $_POST['ids']; } else { $where['status'] = array('neq', 0); if ($act == 'today') { $where['addtime'] = array('gt', xtime(1)); } if ($act == 'allunused') { $where['status'] = 1; } if ($act == 'allinflow') { $where = ''; } $All = $this->ContDB->field('id')->where($where)->select(); foreach ($All as $k => $v) { $ArrID[$k] = $v['id']; } } foreach ($ArrID as $key => $val) { $Cont = $this->ContDB->field('nid,url,data')->where('id=' . $val)->find(); $data = collect::string2array(stripslashes($Cont['data'])); $result .= '[' . $data['cname'] . ']<strong>' . $data['title'] . '</strong>'; if (!$this->CModel->videoImport($Cont['url'], $data, $Cont['nid'])) { $result .= $this->CModel->getError() . "\n\r"; continue; } else { $UpCont = array('status' => 2); /*if($data['cid']==999){ unset($data['cid']); $UpCont['data']=collect::array2string($data); }*/ $Update = $this->ContDB->where('id=' . $val)->save($UpCont); $result .= "入库成功!\n\r"; } } $result = explode("\n\r", $result); return $result; //if(!empty($this->error)) return false; //return true; }