public function listConfigure() { 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') : []; $configures = Configure::select('id', 'cname', 'ckey', 'cvalue', 'cdescription', 'active')->whereNotIn('ckey', ['title_site', 'meta_description', 'main_logo', 'favicon', 'mask'])->where('ckey', 'not like', 'email_%'); if (!empty($search)) { foreach ($search as $key => $value) { if (empty($value)) { continue; } if ($key == 'active') { if ($value == 'yes') { $value = 1; } else { $value = 0; } $configures->where($key, $value); } else { $value = ltrim(rtrim($value)); $configures->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; } $configures->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc'); } } $count = $configures->count(); if ($length > 0) { $configures = $configures->skip($start)->take($length); } $arrConfigures = $configures->get()->toArray(); $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Configure::count(), 'recordsFiltered' => $count, 'data' => []]; if (!empty($arrConfigures)) { foreach ($arrConfigures as $configure) { $arrReturn['data'][] = array(++$start, $configure['id'], $configure['cname'], $configure['ckey'], $configure['cvalue'], $configure['cdescription'], $configure['active']); } } $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; }
public static function getConfig() { $arrReturn = []; $arrConfig = Configure::select('ckey', 'cvalue')->where('ckey', 'like', 'email_%')->get(); foreach ($arrConfig as $configure) { $arrReturn[str_replace('email_', '', $configure->ckey)] = $configure->cvalue; } if (isset($arrReturn['username'])) { $arrReturn['from']['address'] = $arrReturn['username']; } if (isset($arrReturn['name'])) { $arrReturn['from']['name'] = $arrReturn['name']; } return array_merge(Config::get('mail'), $arrReturn); }
public static function getMetaInfo() { $arrData = []; if (Cache::has('meta_info')) { $arrData = Cache::get('meta_info'); } else { $arrMeta = ['title_site', 'meta_description', 'main_logo', 'favicon']; $configures = Configure::select('ckey', 'cvalue')->whereIn('ckey', ['title_site', 'meta_description', 'main_logo', 'favicon'])->get(); foreach ($configures as $configure) { $arrData[$configure['ckey']] = $configure['cvalue']; } foreach ($arrMeta as $key) { if (!isset($arrData[$key])) { $arrData[$key] = ''; } } Cache::forever('meta_info', $arrData); } return $arrData; }