public function listBanner()
{
if (!Request::ajax()) {
return App::abort(404);
}
$start = Input::has('start') ? (int) Input::get('start') : 0;
$length = Input::has('length') ? Input::get('length') : 10;
$search = Input::has('search') ? Input::get('search') : [];
$banners = Banner::select('id', 'name', 'order_no', 'image', 'active');
if (!empty($search)) {
foreach ($search as $key => $value) {
if (empty($value)) {
continue;
}
if ($key == 'active') {
if ($value == 'yes') {
$value = 1;
} else {
$value = 0;
}
$banners->where($key, $value);
} else {
$value = ltrim(rtrim($value));
$banners->where($key, 'like', '%' . $value . '%');
}
}
}
$order = Input::has('order') ? Input::get('order') : [];
if (!empty($order)) {
$columns = Input::has('columns') ? Input::get('columns') : [];
foreach ($order as $value) {
$column = $value['column'];
if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) {
continue;
}
$banners->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc');
}
}
$count = $banners->count();
if ($length > 0) {
$banners = $banners->skip($start)->take($length);
}
$arrBanners = $banners->get()->toArray();
$arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Banner::count(), 'recordsFiltered' => $count, 'data' => []];
if (!empty($arrBanners)) {
foreach ($arrBanners as $banner) {
$arrReturn['data'][] = array(++$start, $banner['id'], $banner['name'], $banner['image'], $banner['order_no'], $banner['active']);
}
}
$response = Response::json($arrReturn);
$response->header('Content-Type', 'application/json');
return $response;
}
public function begin()
{
/** @var Html $document */
$groupId = $this->getParams('banner_group_id');
if ($groupId) {
$this->banners = Banner::select()->where('`status`=:status AND `term_id`=:term_id')->setParameters([':status' => 'ACTIVE', ':term_id' => $groupId])->orderBy('ordering')->execute();
}
}
public static function getBanners()
{
$arrData = [];
if (Cache::has('banners')) {
$arrData = Cache::get('banners');
} else {
$banners = Banner::select('image')->where('active', 1)->orderBy('order_no', 'asc')->get();
foreach ($banners as $banner) {
$arrData[] = URL . '/' . $banner->image;
}
Cache::forever('banners', $arrData);
}
$rand = rand(0, count($arrData) - 1);
return ['main' => isset($arrData[$rand]) ? $arrData[$rand] : ''];
}
/**
*
* @access public
*/
function update_ads()
{
$id = get_post_value('id');
$field = array('banner_id', 'img_path', 'created', 'title', 'start_time', 'end_time', 'orders', 'language');
$m = new Banner();
$m->clear();
$m->setField($field);
$m->setTable('vcb_index_banner2');
$m->setWhere('banner_id', '=', $id);
$m->setWhere('status', '!=', '60000');
$data = $m->select();
//print_r($data);
$this->assign('data', $data);
}
function Index()
{
//echo "session=";
// print_r($_SESSION);
// echo "<br>cookie=";
// print_r($_COOKIE);
if (isset($_SESSION['username']) && !empty($_SESSION['username'])) {
//检测session
$this->assign('username', $_SESSION['username']);
} else {
if (!empty($_COOKIE["username"])) {
//检测cookie
$userCookie = $_COOKIE["username"];
$this->assign('username', $userCookie);
} else {
//游客登陆
$tourists_id = Login::getTouristsId();
if ($tourists_id == null) {
Login::setTouristsId();
}
//
}
}
//else结束
//
$c = new Category();
$category_1 = $c->getCategory_1_id();
$this->assign('category_1', $category_1);
$f = new Floor();
$floor_1 = $f->getFloor_1_id();
$this->assign('floor_1', $floor_1);
//
$m = new Category();
$num = count($m->getCategory_1_id()) * 10000;
$category_2_all = $this->get_category_2();
$this->assign('category_2_all', $category_2_all);
//var_dump($category_2_all);
//echo $num1."<br>";
$category_3_all = $this->get_category_3();
//echo "oh:".$num2."<br>";
//$this->assign('category_3_'.$i."_".$j.$k, $category_3_1[$k]);
//var_dump($category_3_all);
$this->assign('category_3_all', $category_3_all);
//$a=new Banner();
$floor_2_all = $this->get_floor_2();
$floor_3_all = $this->get_floor_3();
$this->assign('floor_2_all', $floor_2_all);
$this->assign('floor_3_all', $floor_3_all);
//********************************
$type = get_post_value('type');
$language = get_post_value('language');
$key = get_post_value('key');
$field = array('category_id', 'type', 'title', 'created', 'start_time', 'end_time', 'status', 'language');
$m = new Banner();
$m->clear();
$m->setField($field);
$m->setTable('vcb_banner_categor');
//$m->setWhere('status', '!=', '60000');//暂不设置
if ($type != '') {
$m->setWhere('type', '=', $type);
}
if ($language != '') {
$m->setWhere('language', '=', $language);
}
if ($key != '') {
$m->setWhere('title', 'LIKE', '%' . $key . '%');
}
$m->setOrderBy('type');
$data = $m->select();
//状态标题 在每一条数据后加上4个数据
$count = count($data);
for ($i = 0; $i < $count; $i++) {
$data[$i]['status_cn'] = $m->getStatus('cn', $data[$i]['status']);
$data[$i]['status_th'] = $m->getStatus('th', $data[$i]['status']);
//$data[$i]['type'] = $m->getTypeCaption($data[$i]['type']);//返回位置对应描述
$data[$i]['dataInformation'] = $m->getImage($data[$i]['category_id']);
}
//print_r($data);
$this->assign('dataOfBanner', $data);
}
/**
* 返回更新国家信息
* @access public
*/
function update()
{
$id = get_post_value('id');
$field = array('category_id', 'type', 'title', 'created', 'start_time', 'end_time', 'status', 'language');
$m = new Banner();
$m->clear();
$m->setField($field);
$m->setTable('vcb_banner_categor');
$m->setWhere('category_id', '=', $id);
$m->setWhere('status', '!=', '60000');
$data = $m->select();
$this->assign('data', $data);
//修改原记录
//图像
$field = array('image_path', 'orders', 'image_id');
$m->clear();
$m->setField($field);
$m->setTable('vcb_banner_images');
$m->setWhere('category_id', '=', $id);
$m->setWhere('status', '=', '10000');
$m->setOrderBy('orders');
$data = $m->select();
$this->assign('images', $data);
}
