public function getIndex() { if (Cookie::get('domain_hash') && Domain::find(Cookie::get('domain_hash'))->allow_registration == 0) { return Redirect::to('login'); } else { return View::make('register.index'); } }
public function getIndex() { if (Cookie::get('domain_hash')) { $domain = Domain::find(Cookie::get('domain_hash')); $homepage = $domain->homepage ? $domain->homepage : $domain->domain; return View::make('dashboard.index')->withHomepage($homepage); } else { return View::make('dashboard.index'); } }
public function showHome() { if (Cookie::get('domain_hash')) { $domain = Domain::find(Cookie::get('domain_hash')); $homepage = $domain->homepage ? $domain->homepage : $domain->domain; return View::make('home')->withHomepage($homepage); } else { return View::make('home'); } }
public static function seoURL($domain_id, $lang = '') { $domain = Domain::find($domain_id); $clean_chars = function ($string) { $string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens. $string = preg_replace('/[^A-Za-z0-9\\-]/', '', $string); // Removes special chars. return preg_replace('/-+/', '-', strtolower($string)); // Replaces multiple hyphens with single one. }; $domain_name = self::formatDiacritics($clean_chars($domain->name)); if (empty($lang)) { $lang = LaravelLocalization::getCurrentLocale(); } return URL::route('domain.details', ['name' => $domain_name, 'id' => $domain->id]); }
public function update(Request $request) { $id = $request->input('data.id'); $record = Record::find($id); $record->name = $request->input('data.name'); $record->type = $request->input('data.type'); $record->content = $request->input('data.content'); $record->prio = $request->input('data.priority'); $record->ttl = $request->input('data.ttl'); $record->auth = "1"; $record->save(); $domain_id = $record->domain_id; $type = $record->type; if ($type == 'SOA') { $zone = Domain::find($domain_id); $zone->name = $request->input('data.name'); $zone->save(); } return response()->json(['success' => 'record_updated'], 200); }
/** * Display a listing of the resource. * * @return Response */ public function getIndex() { $status = Auth::user()->status; if ($status == 2) { $online_phone = OnlinePhone::all(); } elseif ($status == 3) { $domain = Domain::whereUserId(Auth::user()->id)->get(array('sip_server')); $sip_server = array(); foreach ($domain as $row) { $sip_server[] = $row['sip_server']; } if ($sip_server) { $online_phone = OnlinePhone::whereIn('sip_server', $sip_server)->get(); } else { $online_phone = []; } } else { $sip_server = Domain::find(Cookie::get('domain_hash'))->sip_server; $online_phone = OnlinePhone::whereSipServer($sip_server)->get(); } return View::make('online_phone.index')->with('online_phones', $online_phone); }
public function actionRefresh() { $request = Yii::app()->getRequest(); $sid = trim($request->getParam("sid")); if ($sid) { try { //获取url $site = new Site(); $row = $site->find('sid=:sid', array(':sid' => $sid)); $domain = new Domain(); $row = $domain->find('id=:id', array(':id' => $row['dmid'])); $url = 'www.' . $row['name']; //获取seo信息 $seo = new Seotool($url); $info['alexa'] = (int) $seo->getAlexaRank(); $info['google'] = (int) $seo->getIndexedGoogle(); $info['baidu'] = (int) $seo->getIndexedBaidu(); $info['pr'] = (int) $seo->getPagerank(); $info['sid'] = $sid; //更新数据 $res = new Seo(); $row = $res->find('sid=:sid', array(':sid' => $sid)); if ($row) { $res = new Seo(); $res->_pk = $row['id']; $res->_attributes = $info; $res->setIsNewRecord(false); $res->update(); } else { $res = new Seo(); $res->_attributes = $info; $res->insert(); } $this->redirect(array('list')); } catch (CDbException $e) { throw CDbException($e); } } }
$breadcrumbs->parent('category.list'); $breadcrumbs->push($category->name, route('category.details', $category->path)); $breadcrumbs->push(trans('directory.edit_category'), route('category.edit')); }); // domains Breadcrumbs::register('domain.list', function ($breadcrumbs) { $breadcrumbs->parent('home'); $breadcrumbs->push(trans('directory.domains'), route('domain.list')); }); Breadcrumbs::register('domain.create', function ($breadcrumbs) { $breadcrumbs->parent('domain.list'); $breadcrumbs->push(trans('directory.add_domain'), route('domain.create')); }); Breadcrumbs::register('domain.details', function ($breadcrumbs, $name, $id) { $breadcrumbs->parent('domain.list'); $domain = Domain::find($id); if (!empty($domain)) { $breadcrumbs->push($domain->name, route('domain.details', $name)); } }); Breadcrumbs::register('domains-pending', function ($breadcrumbs) { $breadcrumbs->parent('domain.list'); $breadcrumbs->push(trans('directory.pending_domains'), route('domains-pending')); }); Breadcrumbs::register('domain.user', function ($breadcrumbs) { $breadcrumbs->parent('home'); $breadcrumbs->push(trans('user.my_websites'), route('domain.user')); }); Breadcrumbs::register('domain.edit', function ($breadcrumbs) { $breadcrumbs->parent('home'); $breadcrumbs->push(trans('directory.edit_domain'), route('domain.edit'));
public function domain_delete($p) { $d = Domain::find('first', array('conditions' => 'name = ' . Domain::quote($p->name))); $d->destroy(); return true; }
<?php require_once 'base.php'; require_once $class_root . 'Record.php'; require_once $class_root . 'Domain.php'; print $display->header(); $default_key = $_GET['domain_id'] ? 'domain_id' : 'domain_name'; $d = null; if (preg_match('/^\\d+$/', $_GET[$default_key])) { $d = Domain::find('first', array('conditions' => 'id = ' . $_GET[$default_key])); // $d = Domain::find($_GET[$default_key]); } else { $d = $_GET[$default_key]; } ?> <script language="JavaScript" src="http://www.mattkruse.com/javascript/datadumper/datadumper.js"></script> <script type="text/javascript"> function queue_record_add_all() { $$('form').each(function(form) { if(form.disabled == undefined) { queue_record_add(form); } }); } function queue_record_add(form) { var myhash = new Hash();
public function getCreateComment($domain_id) { $domain = Domain::find($domain_id); return View::make('comments.create', compact('domain')); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function getDelete($id) { $domain = Domain::find($id); $domain->delete(); $user = User::whereDomainId($id)->first(); if ($user) { $user->delete(); $phone_number = PhoneNumber::whereUserId($user->id)->first(); $phone_number->delete(); Event::fire('logger', array(array('phone_number_remove', array('id' => $phone_number->id, 'extension' => $phone_number->extension), 2))); } Event::fire('logger', array(array('domain_remove', array('id' => $id, 'domain_name' => $domain->domain), 2))); return Output::push(array('path' => 'domain', 'messages' => array('success' => _('Domain has been deleted')))); }
require_once $class_root . 'Domain.php'; require_once $class_root . 'Record.php'; $rowamount = (int) $config->get('iface.rowamount'); # Get input vars (or set to some default) $offset = isset($_GET["start"]) ? ($_GET["start"] - 1) * $rowamount : 0; $start = isset($_GET["start"]) ? $_GET["start"] : 1; $domain_id = isset($_GET['id']) ? $_GET['id'] : 0; print $display->header(); # Input validation if (!preg_match('/^\\d+$/', $domain_id) || !preg_match('/^\\d+$/', $offset) || !preg_match('/^\\d+$/', $start)) { print $display->error("You hacker!"); print $display->footer(); exit(1); } try { $d = Domain::find($domain_id); $result = ActiveRecord::query("SELECT COUNT(*) AS count FROM records WHERE domain_id={$d->id}"); $rCount = (int) $result[0]['count']; if ($rCount > $rowamount) { $findResult = Record::find('all', array('limit' => "{$rowamount}", 'offset' => "{$offset}", 'conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name')); } else { $findResult = Record::find('all', array('conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name')); } } catch (Exception $e) { print $e->getMessage(); print $display->footer(); exit(0); } print sprintf('<div class="header">%s records found for domain %s</div><br>', $rCount, $d->name); print $display->link('record_add.php?domain_id=' . $d->id, 'Add record'); print "<br>";
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function getEdit($id, $c_id = null) { $data['global_prefix'] = Config::get('settings.global_prefix'); $data['domain'] = $c_id ? Domain::find($id) : Domain::find(Auth::user()->domain_id); $data['phone_number'] = $c_id ? PhoneNumber::find($c_id) : PhoneNumber::find($id); if (Request::segment(2) == "manage") { foreach (User::whereDomainId(Request::segment(3))->get() as $row) { $data['users'][$row['id']] = $row['username']; } } return View::make('phone_number.edit')->with('data', $data); }
if (Auth::guest()) { return Redirect::guest('login'); } }); Route::filter('auth.basic', function () { return Auth::basic(); }); Route::filter('auth.admin', function () { if (Auth::user()->status != 2) { return Redirect::to('dashboard'); } }); Route::filter('auth.manager', function () { if (Request::segment(4) && Request::segment(4) != 'search') { if (Auth::user()->status != 2) { $domain = Domain::find(Request::segment(4))->where('user_id', Auth::user()->id)->get(); if (count($domain) <= 0) { return Redirect::to('dashboard'); } } } if (Auth::user()->status != 3 && Auth::user()->status != 2) { return Redirect::to('dashboard'); } }); Route::filter('phone_number', function () { if (Auth::user()->status != 4 && Request::segment(2) != 'manage') { return Redirect::to('dashboard'); } }); /*
$condition = "name LIKE '" . $char . "%' AND NOT name LIKE '%in-addr.arpa'"; break; # No need to define a default, because input is checked elsewhere } if ($condition != NULL) { $dCount = count(Domain::find('all', array('conditions' => $condition))); $dFindResult = Domain::find('all', array('limit' => $rowamount, 'offset' => $offset, 'conditions' => $condition)); } $domain_start_chars = Domain::domain_start_chars(); foreach (array_merge(range(0, 9), range('a', 'z')) as $char) { $fwlinks .= sprintf('[ %s ]', in_array($char, $domain_start_chars) ? $display->link(sprintf('%s?char=%s&type=forward', $_SERVER["PHP_SELF"], $char), $char) : $char); } $reverse_start_chars = Domain::reverse_start_chars(); foreach (range(0, 9) as $char) { $rvlinks .= sprintf('[ %s ]', in_array($char, $reverse_start_chars) ? $display->link(sprintf('%s?char=%s&type=forward', $_SERVER["PHP_SELF"], $char), $char) : $char); } printf("Forward: %s<br>Reverse: %s<br>", $fwlinks, $rvlinks); print "<hr>"; print $display->show_pages($dCount, $rowamount, null, $char, $start, $type); print "<br><br>"; } else { $dFindResult = Domain::find('all'); } if (count($dFindResult) > 0) { print $display->domains_header(); foreach ($dFindResult as $domain) { print $display->domain($domain); } print $display->domains_footer(); } print $display->footer();
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { if (!$request->domain) { return Response::json(['error' => ['message' => 'Please provide a Domain']], 422); } $user = JWTAuth::parseToken()->authenticate(); $userId = $user->id; $domain = Domain::find($id); $domain->name = $request->domain; $domain->sld = $this->splitdomain($request->domain)[0]; $domain->tld = $this->splitdomain($request->domain[1]); $domain->orderType = $request->orderType; $domain->user_id = $userId; $domain->save(); return Response::json(['message' => 'Domain updated successfully'], 200); }
<?php if (PHP_SAPI !== 'cli') { die("Testscript may only run in CLI-mode"); } set_include_path(get_include_path() . PATH_SEPARATOR . '..'); require_once 'Domain.php'; if (1) { $d = Domain::find(1); print_r($d->record_count()); } if (0) { $startchars = Domain::domain_start_chars(); print_r($startchars); } if (0) { $startchars = Domain::reverse_start_chars(); print_r($startchars); }
public function deleteHandle($id) { $domain = Domain::find($id); if (Acl::isAdmin($domain) || Acl::isSuperAdmin()) { DB::statement('SET FOREIGN_KEY_CHECKS=0'); $domain->siteViewers()->delete(); $domain->domainVotes()->delete(); $domain->delete(); DB::statement('SET FOREIGN_KEY_CHECKS=0'); try { $path_details = explode("/", $domain->thumb, 2); $folder = $path_details[0]; File::deleteDirectory(public_path('assets/thumbs/' . $folder)); } catch (Exception $e) { } return Redirect::route('domains-pending')->with('success', trans('directory.domain_deleted')); } return Redirect::back()->with('error', Lang::get('directory.delete_denied', ['domain' => $domain->name])); }
Route::post('edit', ['before' => 'auth|superAdmin', 'as' => 'user.edit.post', 'uses' => 'UserController@editHandle']); Route::post('delete', ['before' => 'auth|superAdmin', 'as' => 'user.delete', 'uses' => 'UserController@delete']); Route::get('my-websites', ['as' => 'domain.user', 'uses' => 'UserController@listUserDomains']); }); Route::group(['prefix' => 'admin', 'before' => 'auth|superAdmin'], function () { Route::get('domains/pending', ['as' => 'domains-pending', 'uses' => 'AdminController@getPendingDomains']); Route::get('domains/attempts', ['as' => 'domains-attempts', 'uses' => 'AdminController@getAttempts']); Route::get('attempt/{id}', ['as' => 'attempt.details', 'uses' => 'AdminController@attemptDetails']); Route::get('attempt-add/{id}', ['as' => 'attempt.add', 'uses' => 'AdminController@attemptAdd']); Route::get('attempt/delete/{id}', ['as' => 'attempt.delete', 'uses' => 'AdminController@attemptDelete']); Route::get('comments-all', ['before' => 'auth', 'uses' => 'AdminController@allComments', 'as' => 'comments-all']); }); }); Route::post('vote', ['as' => 'vote.site', 'uses' => 'DomainsController@vote']); Route::get('get/site/votes/{type}/{id}', ['as' => 'get.site.votes', function ($type, $id) { return Domain::find($id)->{$type}; }]); Route::post('search', ['as' => 'search.post', 'uses' => 'HomeController@searchAjax']); Route::get('generate-sitemap', function () { ini_set('memory_limit', '2048M'); $domains = Domain::where('status', 1)->get(['id', 'updated_at']); $categories = Category::where('status', 1)->get(['path', 'updated_at']); $langs = LaravelLocalization::getSupportedLocales(); // create new sitemap object $sitemap = App::make("sitemap"); // set cache (key (string), duration in minutes // (Carbon|Datetime|int), turn on/off (boolean)) // by default cache is disabled //$sitemap->setCache('laravel.sitemap', 3600); $i = 0; $ci = 0;
require_once $class_root . 'Domain.php'; $offset = 0; $rowamount = (int) $config->get('iface.rowamount'); $start = 1; if (isset($_GET["start"])) { $offset = ($_GET["start"] - 1) * $rowamount; $start = $_GET["start"]; } print $display->header(); if (!preg_match('/^\\d+$/', $_GET['id'])) { print $display->error("You hacker!"); print $display->footer(); exit(1); } try { $d = Domain::find($_GET['id']); $result = ActiveRecord::query("SELECT COUNT(*) AS count FROM records WHERE domain_id={$d->id}"); $rCount = (int) $result[0]['count']; if ($rCount > $rowamount) { $findResult = Record::find('all', array('limit' => "{$rowamount}", 'offset' => "{$offset}", 'conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name')); } else { $findResult = Record::find('all', array('conditions' => 'domain_id = ' . Record::quote($d->id), 'order' => 'name')); } } catch (Exception $e) { print $e->getMessage(); print $display->footer(); exit(0); } ?> <script language="JavaScript" src="http://www.mattkruse.com/javascript/datadumper/datadumper.js"></script>
public function getFilter() { $status = Auth::user()->status; if ($status == 2) { $call_detail_report = Cdr::all(); $condq = "created is not null"; } elseif ($status == 3) { $domain = Domain::whereUserId(Auth::user()->id)->get(array('sip_server')); $sip_server = array(); foreach ($domain as $row) { $sip_server[] = $row['sip_server']; } if ($sip_server) { $call_detail_report = $this->_orWhereIn('caller_domain', 'callee_domain', $sip_server); } else { $call_detail_report = []; } $condq = $this->_orGenerator('caller_domain', 'callee_domain', $sip_server); } else { $sip_server = Domain::find(Cookie::get('domain_hash'))->whereDomain(Request::getHttpHost())->get(array('sip_server')); $domainc = array(); foreach ($sip_server as $row) { $domainc[] = $row['sip_server']; } $extension_arr = PhoneNumber::whereUserId(Auth::user()->id)->get(array('extension')); $extension = array(); foreach ($extension_arr as $row) { $extension[] = $row['extension']; } $call_detail_report = $this->_orWhereInAnd('src_uri', 'dst_uri', $extension, 'caller_domain', 'callee_domain', $domainc); $condq = $this->_orGeneratorAnd('src_uri', 'dst_uri', $extension, 'caller_domain', 'callee_domain', $domainc); } $input = Input::only(array('datefilter', 'datefrom', 'dateto', 'timefilter', 'timefrom', 'timeto', 'durationparam', 'durationfilter', 'duration', 'fromfilter', 'from', 'tofilter', 'to')); $rules = array('datefrom' => 'required_with:datefilter', 'timefrom' => 'required_with:timefilter', 'duration' => 'required_with:durationfilter'); $v = Validator::make($input, $rules); if ($v->fails()) { return Output::push(array('path' => 'call_detail_reports', 'errors' => $v, 'input' => TRUE)); } $bulan_ayeuna = "AND YEAR(call_start_time) = YEAR(curdate()) AND MONTH(call_start_time) = MONTH(curdate()) "; if ($input['datefilter'] || $input['timefilter'] || $input['durationfilter'] || $input['fromfilter'] || $input['tofilter']) { $q = "select * from opensips.cdrs where "; $q = $q . "(" . $condq . ") "; if ($input['datefilter']) { if ($input['datefrom'] && $input['dateto']) { $fromdate = $this->_intlDate($input['datefrom']); $todate = $this->_intlDate($input['dateto']); $q = $q . "AND (date(call_start_time) BETWEEN '" . $fromdate . "' AND '" . $todate . "') "; } elseif ($input['datefrom'] && !$input['dateto']) { $fromdate = $this->_intlDate($input['datefrom']); $todate = date("Y-m-d"); $q = $q . "AND (date(call_start_time) >= '" . $fromdate . "') "; } } else { $q = $q . $bulan_ayeuna; } if ($input['timefilter']) { if ($input['timefrom'] && $input['timeto']) { $q = $q . "AND (time(call_start_time) BETWEEN '" . $input['timefrom'] . "' AND '" . $input['timeto'] . "') "; } elseif ($input['timefrom'] && !$input['timeto']) { $q = $q . "AND (time(call_start_time) >= "; $q = $q . "'" . $input['timefrom'] . "') "; } } if ($input['durationfilter']) { $duration = $this->_getDuration($input['duration']); $q = $q . "AND (duration " . $input['durationparam'] . " " . $duration . ") "; } if ($input['fromfilter']) { $fromarr = explode("@", $input['from']); if (!isset($fromarr[1])) { $fromarr[1] = null; } if ($fromarr[1] == null) { $q = $q . "AND (src_uri = '" . $input['from'] . "') "; } else { $q = $q . "AND (src_uri = '" . $fromarr[0] . "' and caller_domain = '" . $fromarr[1] . "') "; } } if ($input['tofilter']) { $toarr = explode("@", $input['to']); if (!isset($toarr[1])) { $toarr[1] = null; } if ($toarr[1] == null) { $q = $q . "AND (dst_uri = '" . $input['to'] . "') "; } else { $q = $q . "AND (dst_uri = '" . $toarr[0] . "' and callee_domain = '" . $toarr[1] . "') "; } } $q = $q . "order by call_start_time desc"; $results = []; $results = DB::connection('mysql2')->select($q); //print_r($q); return View::make('call_detail_reports.index')->with('call_detail_reports', $results); } else { return View::make('call_detail_reports.index')->with('call_detail_reports', $call_detail_report); } }