public function import($entity)
{
$appHelper = new libs\AppHelper();
$className = $appHelper->getNameSpace() . $entity;
$model = new $className();
$table = $model->getTable();
$columns = \Schema::getColumnListing($table);
$key = $model->getKeyName();
$notNullColumnNames = array();
$notNullColumnsList = \DB::select(\DB::raw("SHOW COLUMNS FROM `" . $table . "` where `Null` = 'no'"));
if (!empty($notNullColumnsList)) {
foreach ($notNullColumnsList as $notNullColumn) {
$notNullColumnNames[] = $notNullColumn->Field;
}
}
$status = \Input::get('status');
$filePath = null;
if (\Input::hasFile('import_file') && \Input::file('import_file')->isValid()) {
$filePath = \Input::file('import_file')->getRealPath();
}
if ($filePath) {
\Excel::load($filePath, function ($reader) use($model, $columns, $key, $status, $notNullColumnNames) {
$this->importDataToDB($reader, $model, $columns, $key, $status, $notNullColumnNames);
});
}
$importMessage = $this->failed == true ? \Lang::get('panel::fields.importDataFailure') : \Lang::get('panel::fields.importDataSuccess');
return \Redirect::to('panel/' . $entity . '/all')->with('import_message', $importMessage);
}
public function run()
{
DB::table('Posts')->delete();
Post::create(['title' => 'First Post', 'author' => 'Евгений', 'excerpt' => 'First Post body', 'text' => 'Content First Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
Post::create(['title' => 'Second Post', 'author' => 'Евгений', 'excerpt' => 'Second Post body', 'text' => 'Content Second Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
Post::create(['title' => 'Third Post', 'author' => 'Евгений', 'excerpt' => 'Third Post body', 'text' => 'Content Third Post body', 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('posts', function (Blueprint $table) {
$table->boolean('body_rtl')->nullable()->default(null)->after('body_html');
});
Post::where(DB::raw('1=1'))->update(['body_parsed' => null, 'body_parsed_at' => null, 'body_html' => null]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('orders', function (Blueprint $table) {
$table->increments('id');
$table->string('sn', 32)->unique();
$table->enum('order_status', ['pending', 'confirmed', 'completed', 'branched', 'canceled'])->default('pending');
$table->jsonb('branches')->nullable();
$table->integer('order_lock_id')->default(0)->nullable();
$table->decimal('order_discount', 10, 2)->default(0);
$table->integer('user_id');
$table->string('logistics_consignee');
$table->jsonb('logistics_region');
$table->string('logistics_address');
$table->string('logistics_zipcode')->nullable();
$table->string('logistics_mobile')->nullable();
$table->string('logistics_phone')->nullable();
$table->string('logistics_email')->nullable();
$table->integer('logistics_id');
$table->boolean('logistics_cod')->default(false);
$table->string('logistics_tracking_number')->default('');
$table->enum('logistics_status', ['unshipped', 'shipped'])->default('unshipped');
$table->timestamp('logistics_time')->nullable();
$table->integer('payment_id');
$table->enum('payment_status', ['unpaid', 'paid'])->default('unpaid');
$table->timestamp('payment_due')->default(\DB::raw('now()::timestamp(0) + interval \'1 day\''));
$table->timestamp('payment_time')->nullable();
$table->decimal('subtotal_product', 10, 2)->default(0);
$table->decimal('subtotal_tax', 10, 2)->default(0);
$table->decimal('subtotal_discount', 10, 2)->default(0);
$table->decimal('subtotal_logistics', 10, 2)->default(0);
$table->decimal('total_amount', 10, 2)->default(0);
$table->decimal('total_refunded', 10, 2)->default(0);
$table->timestamps();
});
}
public function getDetailData($id, $postData, $properties)
{
$templateId = $postData['templateId'];
$pdContractData = PdContractData::getTableName();
$pdContractTemplateAttribute = PdContractTemplateAttribute::getTableName();
$pdCodeContractAttribute = PdCodeContractAttribute::getTableName();
$pdContractQtyFormula = PdContractQtyFormula::getTableName();
$contractDataSet = PdContractData::join($pdCodeContractAttribute, "{$pdContractData}.ATTRIBUTE_ID", '=', "{$pdCodeContractAttribute}.ID")->leftJoin($pdContractQtyFormula, "{$pdCodeContractAttribute}.FORMULA_ID", '=', "{$pdContractQtyFormula}.ID")->where("{$pdContractData}.CONTRACT_ID", '=', $id)->select("{$pdContractData}.*", "{$pdContractData}.CONTRACT_ID as CONTRACT_ID_INDEX", "{$pdContractData}.ATTRIBUTE_ID as ATTRIBUTE_ID_INDEX", "{$pdCodeContractAttribute}.ID as DT_RowId", "{$pdCodeContractAttribute}.ID as {$pdContractData}", "{$pdCodeContractAttribute}.NAME as CONTRACT_ID", "{$pdCodeContractAttribute}.CODE as ATTRIBUTE_ID", "{$pdCodeContractAttribute}.ID as ID", "{$pdContractQtyFormula}.NAME as FORMULA")->get();
$selects = ["{$pdCodeContractAttribute}.ID as DT_RowId", "{$pdCodeContractAttribute}.ID as {$pdContractData}", "{$pdCodeContractAttribute}.NAME as CONTRACT_ID", "{$pdCodeContractAttribute}.CODE as ATTRIBUTE_ID", "{$pdCodeContractAttribute}.ID", "{$pdCodeContractAttribute}.FORMULA_ID as FORMULA", "{$pdCodeContractAttribute}.ID as ATTRIBUTE_ID_INDEX", "{$pdContractQtyFormula}.NAME as FORMULA", \DB::raw("{$id} as CONTRACT_ID_INDEX")];
foreach ($properties as $property) {
$columnName = $property['data'];
if ($columnName != 'CONTRACT_ID' && $columnName != 'ATTRIBUTE_ID' && $columnName != 'ID') {
$selects[] = \DB::raw("null as {$columnName}");
}
}
$templateQuery = PdContractTemplateAttribute::join($pdCodeContractAttribute, "{$pdContractTemplateAttribute}.ATTRIBUTE", '=', "{$pdCodeContractAttribute}.ID")->leftJoin($pdContractQtyFormula, "{$pdCodeContractAttribute}.FORMULA_ID", '=', "{$pdContractQtyFormula}.ID")->where("{$pdContractTemplateAttribute}.CONTRACT_TEMPLATE", '=', $templateId)->where("{$pdContractTemplateAttribute}.ACTIVE", '=', 1)->select($selects);
// ->get();
$existAttributes = $contractDataSet->pluck('DT_RowId');
if (count($existAttributes) > 0) {
$templateQuery->whereNotIn("{$pdCodeContractAttribute}.ID", $existAttributes);
}
$templateDataSet = $templateQuery->get();
$dataSet = $contractDataSet->merge($templateDataSet);
return $dataSet;
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('sales', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->increments('id');
$table->unsignedInteger('qc_user_id')->nullable()->index();
// quality control user
$table->timestamp('qc_processed_datetime')->nullable();
$table->unsignedInteger('sale_status_id')->nullable()->index();
$table->unsignedInteger('user_id')->index();
// agent who entered the sale
$table->unsignedInteger('product_id')->index();
$table->unsignedInteger('customer_id')->index();
$table->date('date_sold');
$table->string('order_number');
$table->tinyInteger('ninety_days')->default('0');
$table->tinyInteger('verified')->default('0');
$table->text('remarks');
$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
$table->foreign('user_id')->references('id')->on('users')->onDelete('restrict');
$table->foreign('product_id')->references('id')->on('products')->onDelete('restrict');
$table->foreign('customer_id')->references('id')->on('customers')->onDelete('restrict');
$table->foreign('sale_status_id')->references('id')->on('sale_statuses')->onDelete('restrict');
$table->foreign('qc_user_id')->references('id')->on('users')->onDelete('restrict');
});
}
protected static function personPrepare()
{
return PersonModel::join(PersonLangModel::getTableName(), PersonLangModel::getField("person_id"), '=', PersonModel::getField("id"))->join(PersonRelModel::getTableName(), PersonRelModel::getField("person_id"), '=', PersonModel::getField("id"))->leftJoin(Files::getTableName(), function ($join) {
$join->on(Files::getField("module_id"), '=', PersonModel::getField("id"));
$join->on(Files::getField("module_name"), '=', DB::raw("'person'"));
})->where(PersonLangModel::getField("lang_id"), \WebAPL\Language::getId())->orderBy('first_name', 'asc')->orderBy('last_name', 'asc');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('emp_name');
$table->string('emp_gender');
$table->integer('shift_id')->unsigned();
$table->foreign('shift_id')->references('id')->on('shifts')->onDelete('cascade');
$table->integer('position_id')->unsigned();
$table->foreign('position_id')->references('id')->on('positions')->onDelete('cascade');
$table->integer('img_id')->unsigned();
$table->foreign('img_id')->references('id')->on('profile_image')->onDelete('cascade');
$table->string('email');
$table->integer('username')->unique();
$table->string('password', 60);
$table->integer('permissioners');
$table->integer('VL_entitlement');
$table->integer('SL_entitlement');
$table->integer('ML_entitlement');
$table->integer('PL_entitlement');
$table->integer('VL_taken')->default(0);
$table->integer('SL_taken')->default(0);
$table->integer('ML_taken')->default(0);
$table->integer('PL_taken')->default(0);
$table->rememberToken();
$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
});
}
public function no_assigned($user_id)
{
$no_assigned = EntrustRole::whereNotIn('id', function ($query) use($user_id) {
$query->select(DB::raw('role_id'))->from('assigned_roles')->whereRaw("user_id = ?", array($user_id));
})->lists('name', 'id');
return $no_assigned;
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('company_person', function (Blueprint $table) {
$table->increments('id');
$table->integer('person_id')->unsigned();
$table->integer('company_id')->unsigned();
$table->integer('department_id')->unsigned()->nullable();
$table->integer('title_id')->unsigned()->nullable();
$table->integer('group_type_id')->unsigned();
$table->integer('group_id')->unsigned()->nullable();
$table->string('phone')->nullable();
$table->string('extension')->nullable();
$table->string('cellphone')->nullable();
$table->string('email')->nullable();
$table->string('division_ids')->nullable();
$table->string('slack_token')->nullable();
$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->softDeletes();
});
Schema::table('company_person', function (Blueprint $table) {
$table->foreign('person_id')->references('id')->on('people');
$table->foreign('company_id')->references('id')->on('companies');
$table->foreign('department_id')->references('id')->on('departments');
$table->foreign('title_id')->references('id')->on('titles');
$table->foreign('group_type_id')->references('id')->on('group_types');
$table->foreign('group_id')->references('id')->on('groups');
$table->unique(['person_id', 'company_id']);
});
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
//
$configTables = config('sync.sync_tables');
$logs = \DB::table(\DB::raw('(select * from table_logs order by id desc) as logs'))->groupBy('logs.table', 'logs.column', 'logs.pk_id')->get();
foreach ($logs as $log) {
if (isset($configTables[$log->table])) {
$info = $configTables[$log->table];
$pk = array_shift($info);
if (!$pk) {
$this->info('Pk not found for ' . $log->table . ' with pk id ' . $log->pk_id);
continue;
}
$row = \DB::table($log->table)->where($pk, $log->pk_id)->first();
if ($row) {
$currentValue = $row->{$log->column};
if ($currentValue != $log->value) {
$this->info('Value not equal for ' . $log->table . ' column ' . $log->column . ' with pk id ' . $log->pk_id . ' val: ' . $currentValue . ':' . $log->value);
if (false !== strpos($log->column, 'date')) {
$values = [$log->column => new \DateTime($log->value), 'updated_at' => $log->created_at, 'updated_by' => $log->updated_by];
} else {
$values = [$log->column => $log->value, 'updated_at' => $log->created_at, 'updated_by' => $log->updated_by];
}
\DB::table($log->table)->where($pk, $log->pk_id)->lockForUpdate()->update($values);
}
} else {
$this->info('Row not found for ' . $log->table . ' with pk id ' . $log->pk_id);
}
} else {
$this->info('Table pk column not found ' . $log->table);
}
}
}
public function current()
{
$count = Host::where("id", "!=", 0)->get()->count();
$backups = Backup::where(DB::raw('YEAR(created_at)'), '=', "2013")->where(DB::raw('MONTH(created_at)'), '=', "01")->where(DB::raw('DAY(created_at)'), '=', "21")->where('type', '=', 'cron')->get(array('id', 'host_id', 'hostname', 'status', 'files_original_size', 'db_original_size', 'total_size'));
$report = "";
foreach ($backups as $backup) {
$backup["files_original_size"] = $this->ghs($backup["files_original_size"]);
$backup["db_original_size"] = $this->ghs($backup["db_original_size"]);
$backup["total_size"] = $this->ghs($backup["total_size"]);
if ($backup["status"] == "ok") {
$row = '<tr class="success">';
}
if ($backup["status"] == "broken") {
$row = '<tr class="danger">';
}
if ($backup["status"] == "removed") {
$row = '<tr class="warning">';
}
$row .= "<td>" . $backup["id"] . "</td>";
$row .= "<td>" . $backup["host_id"] . "</td>";
$row .= "<td>" . $backup["hostname"] . "</td>";
$row .= "<td>" . $backup["files_original_size"] . "</td>";
$row .= "<td>" . $backup["db_original_size"] . "</td>";
$row .= "<td>" . $backup["total_size"] . "</td>";
$row .= "</tr>";
$report .= $row;
}
return View::make('reports.daily')->with('report', $report)->with('hosts_count', $count)->with('email', Auth::user()->email);
}
/**
* Display the specified resource.
* GET /sessions/{id}
*
* @param int $id
* @return Response
*/
public function show($id)
{
$session = TheSession::find($id);
$array = array();
$array["sensors"] = DB::select(DB::raw('Select DISTINCT `sensors`.*, `data`.`session_id` FROM `sensors` INNER JOIN `data` ON `data`.`sensor_id` = `sensors`.`sensor_id` WHERE `data`.`session_id` = ' . $session->session_id));
return View::make('session', ['session' => $array, 'id' => $id]);
}
public function scopenombre($publicidad, $nombre)
{
$publicidad = DB::table('publicidad as p')->leftjoin('restaurantes as r', function ($join) use($nombre) {
$join->on('r.id', '=', DB::raw('"' . $nombre . '"'));
})->select('r.nombre as nombre');
return $publicidad;
}
public function run()
{
DB::table('ClickBusPlaces')->delete();
$clickbusPlaces = file_get_contents('https://api-evaluation.clickbus.com.br/api/v1/places');
$clickbusHash = md5($clickbusPlaces);
$clickbusPlaces = (array) json_decode($clickbusPlaces)->items;
foreach ($clickbusPlaces as $place) {
$array_insert = array('item_id' => $place->id, 'station_id' => $place->station_id, 'slug' => $place->slug, 'locale' => $place->locale, 'is_primary' => $place->is_primary, 'item_created_at' => $place->created_at, 'item_updated_at' => $place->updated_at, 'place_created_at' => $place->place->created_at, 'place_updated_at' => $place->place->updated_at, 'place_id' => $place->place->place_id, 'place_name' => $place->place->name, 'state_code' => $place->place->state->code, 'state_name' => $place->place->state->name);
if (strcasecmp(env('DB_DRIVER'), 'pgsql') == 0 && count($place->place->longitude) > 0 && count($place->place->latitude) > 0) {
$array_insert['place_position'] = DB::raw("ST_GeomFromText('POINT({$place->place->longitude} {$place->place->latitude})', 4326)");
}
DB::table('ClickBusPlaces')->insert($array_insert);
}
DB::table('ClickBusCompanies')->delete();
$pages = json_decode(file_get_contents('https://api-evaluation.clickbus.com.br/api/v1/buscompanies'))->meta->totalPages;
$busCompaniesHash = '';
for ($i = 1; $i <= intval($pages); $i++) {
$companies = file_get_contents("https://api-evaluation.clickbus.com.br/api/v1/buscompanies?page={$i}");
$busCompaniesHash .= $companies;
$companies = json_decode($companies)->busCompanies;
foreach ($companies as $company) {
DB::table('ClickBusCompanies')->insert(array('id' => $company->id, 'nome' => $company->name, 'logo_url' => $company->logo->url));
}
}
}
public function edit(User $user)
{
$currencies = Currency::select(\DB::raw("CONCAT(name, ' ', symbol) AS full_name, id"))->lists("full_name", "id");
$users = User::select(\DB::raw("CONCAT(surname, ' ', name) AS full_name, id"))->lists("full_name", "id");
$vehicles = Vehicle::lists("name", "id");
return View::make('Middle.Web.User.edit', compact(['user', 'currencies', 'users', 'vehicles']));
}
public function index2()
{
set_time_limit(300);
$stok = DB::table('tbstock')->groupBy('cKode')->select(DB::raw('cKode, sum(nQtyReal) as sum'))->orderBy('cKode', 'asc')->get();
foreach ($stok as $row) {
$data = DB::table('tbinventori')->where('cKode', $row->cKode)->orderBy('urutan', 'asc')->get();
$n = 1;
$i = 0;
$jum = 0;
$cek = false;
foreach ($data as $baris) {
if ($cek == false) {
$jum += $baris->stok;
if ($row->sum <= $jum) {
$cek = true;
if ($i == 0) {
DB::table('tbinventori')->where('cKode', $baris->cKode)->where('urutan', $baris->urutan)->update(array('stok' => (int) $row->sum));
} else {
$st = $jum - $row->sum;
DB::table('tbinventori')->where('cKode', $baris->cKode)->where('urutan', $baris->urutan)->update(array('stok' => $baris->stok - $st));
}
}
} else {
DB::table('tbinventori')->where('cKode', $baris->cKode)->where('urutan', $baris->urutan)->update(array('stok' => 0, 'urutan' => ''));
}
$i++;
}
$data = DB::table('tbinventori')->where('cKode', $row->cKode)->where('urutan', '<>', '')->orderBy('urutan', 'desc')->get();
foreach ($data as $baris) {
DB::table('tbinventori')->where('id', $baris->id)->update(array('urutan' => $n));
$n++;
}
}
}
public function edit($id)
{
if (Request::isMethod('post')) {
$rules = array('status_id' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to("admin/{$this->name}/{$id}/{$this->action}")->withErrors($validator)->withInput(Input::except(''));
} else {
$table = Order::find($id);
$table->status_id = Input::get('status_id');
if ($table->save()) {
$name = trans("name.{$this->name}");
return Redirect::to("admin/{$this->name}")->with('success', trans("message.{$this->action}", ['name' => $name]));
}
return Redirect::to("admin/{$this->name}")->with('error', trans('message.error'));
}
}
$order = DB::table('orders as o')->join('users as u', 'o.user_id', '=', 'u.id')->join('order_status as os', 'o.status_id', '=', 'os.id')->join('orders_details as od', 'o.id', '=', 'od.order_id')->select('o.id', DB::raw('CONCAT(u.firstname, " ", u.lastname) AS fullname'), 'os.title', 'o.created_at', DB::raw('SUM(od.price) AS total'), 'o.comment', 'o.status_id')->where('o.id', $id)->first();
$products = DB::table('products as p')->join('orders_details as od', 'p.id', '=', 'od.product_id')->join('orders as o', 'od.order_id', '=', 'o.id')->select('p.id', 'p.link', 'p.name', 'od.price', 'od.quantity', DB::raw('od.price * od.quantity AS total'))->where('o.id', $id)->orderBy('o.id', 'asc')->get();
$ordersStatus = OrderStatus::all();
foreach ($ordersStatus as $status) {
$orderStatus[$status['id']] = $status['title'];
}
return View::make("admin.shop.order.edit", ['item' => $order, 'name' => $this->name, 'action' => $this->action, 'status' => $orderStatus, 'products' => $products]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('categories')->truncate();
DB::table('categories')->insert(array(array('name' => 'Браслеты', 'url' => 'bracelets', 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()')), array('name' => 'Сережки', 'url' => 'earrings', 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()')), array('name' => 'Кольца', 'url' => 'rings', 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()')), array('name' => 'Кулоны', 'url' => 'pendants', 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()')), array('name' => 'Разное', 'url' => 'misc', 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()'))));
DB::table('users')->truncate();
DB::table('users')->insert(array('name' => 'admin', 'email' => '*****@*****.**', 'password' => bcrypt('123456789'), 'created_at' => DB::raw('NOW()'), 'updated_at' => DB::raw('NOW()')));
}
public function model()
{
$data = array();
$make = Input::get('make', '');
$models = DB::select(DB::raw("SELECT * FROM model WHERE id in (SELECT model FROM search_suggestion WHERE make = :make)"), array('make' => $make));
return Response::json($models);
}
public function run()
{
DB::table('Posts')->delete();
Post::create(['title' => 'First Post', 'slug' => 'first-post', 'excerpt' => 'First Post body', 'content' => 'Content First Post body', 'published' => true, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
Post::create(['title' => 'Second Post', 'slug' => 'second-post', 'excerpt' => 'Second Post body', 'content' => 'Content Second Post body', 'published' => false, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
Post::create(['title' => 'Third Post', 'slug' => 'third-post', 'excerpt' => 'Third Post body', 'content' => 'Content Third Post body', 'published' => false, 'published_at' => DB::raw('CURRENT_TIMESTAMP')]);
}
public function dashboard()
{
$counts = ['organizations' => Organization::count(), 'users' => User::count(), 'todos' => Todo::count(), 'mt_users' => User::has('organizations', '>', 1)->count()];
$newestOrg = Organization::orderBy('created_at', 'desc')->first();
$orgWithMostTodos = DB::table('organizations')->select(['organizations.name', DB::raw('count(todos.organization_id) as total')])->join('todos', 'todos.organization_id', '=', 'organizations.id')->orderBy('total', 'desc')->groupBy('todos.organization_id')->first();
$this->view('dashboard', compact('counts', 'newestOrg', 'orgWithMostTodos'));
}
public function getProfile($id)
{
DB::setFetchMode(PDO::FETCH_ASSOC);
$member = DB::table('members')->where('members.id', '=', $id)->leftjoin('region', 'members.region_id', '=', 'region.id')->leftjoin('city', 'members.city_id', '=', 'city.id')->select(DB::raw('members.id, members.user_id, members.avatar_url, members.avatar_url_big, members.name, members.surname,members.rep, city.name as city_name, region.name as region_name, city.id as city_id, region.id as region_id'))->get();
//echo "<pre>";
//var_dump($regions);
//echo "</pre>";
//die();
if (!empty($member)) {
$member = $member[0];
$member['ajax_url'] = action('ProfileController@postCities');
$member['all_regions'] = DB::table('region')->get();
$member['regions_cities'] = DB::table('city')->where('region_id', '=', $member['region_id'])->get();
if (Auth::check()) {
if ($member['user_id'] === Auth::user()->id) {
if (Auth::user()->vk_id != 0) {
$member['is_vk'] = true;
} else {
$member['is_vk'] = false;
}
return View::make('profile-edit', $member);
}
} else {
return View::make('profile', $member);
}
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('exit_pass', function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id')->unsigned();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->integer('department_id')->unsigned();
$table->foreign('department_id')->references('id')->on('departments')->onDelete('cascade');
$table->integer('form_id')->unsigned()->default(1);
$table->foreign('form_id')->references('id')->on('form_types')->onDelete('cascade');
$table->text('reason');
$table->text('purpose');
$table->integer('permission_id1')->unsigned();
$table->foreign('permission_id1')->references('id')->on('users')->onDelete('cascade');
$table->integer('permission_id2')->unsigned();
$table->foreign('permission_id2')->references('id')->on('users')->onDelete('cascade');
$table->integer('permission_id3')->unsigned();
$table->foreign('permission_id3')->references('id')->on('users')->onDelete('cascade');
$table->integer('permission_id4')->unsigned();
$table->foreign('permission_id4')->references('id')->on('users')->onDelete('cascade');
$table->integer('permission_1');
$table->integer('permission_2');
$table->integer('permission_3');
$table->integer('permission_4');
$table->integer('days_applied');
$table->integer('status')->default(0);
$table->timestamp('date_from')->default('0000-00-00 00:00:00');
$table->timestamp('date_to')->default('0000-00-00 00:00:00');
$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
});
}
public function run()
{
DB::table('update_records')->delete();
DB::table('view_cache')->delete();
DB::table('posts')->delete();
DB::table('threads')->delete();
##################
Thread::create(['id' => 1, 'thread_id' => 111111111, 'board' => 'a', 'updated_num' => 0, 'views' => '500', 'notice' => null, 'secret' => 'a719c9a1', 'takedown_reason' => null, 'tweeted_at' => null]);
Post::create(['chan_id' => 111111111, 'thread_id' => 1, 'original_image_name' => 'Imgur.jpg', 'image_size' => 128000, 'image_width' => '535', 'image_height' => '535', 'thumb_width' => '250', 'thumb_height' => '250', 'image_url' => 'http://i.imgur.com/UmmyTUG.png', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 111111112, 'thread_id' => 1, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 111111113, 'thread_id' => 1, 'original_image_name' => 'Imgur 2.jpg', 'image_size' => 34000, 'image_width' => '500', 'image_height' => '466', 'thumb_width' => '116', 'thumb_height' => '125', 'image_url' => 'http://i.imgur.com/w6pQEvY.jpg', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 111111114, 'thread_id' => 1, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
##################
Thread::create(['id' => 2, 'thread_id' => 222222222, 'board' => 'b', 'updated_num' => 0, 'views' => '555', 'notice' => null, 'secret' => 'a719c9a1', 'takedown_reason' => null, 'tweeted_at' => null]);
Post::create(['chan_id' => 222222222, 'thread_id' => 2, 'original_image_name' => 'Imgur.jpg', 'image_size' => 128000, 'image_width' => '535', 'image_height' => '535', 'thumb_width' => '250', 'thumb_height' => '250', 'image_url' => 'http://i.imgur.com/UmmyTUG.png', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 222222223, 'thread_id' => 2, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 222222224, 'thread_id' => 2, 'original_image_name' => 'Imgur 2.jpg', 'image_size' => 34000, 'image_width' => '500', 'image_height' => '466', 'thumb_width' => '116', 'thumb_height' => '125', 'image_url' => 'http://i.imgur.com/w6pQEvY.jpg', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 222222225, 'thread_id' => 2, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
##################
Thread::create(['id' => 3, 'thread_id' => 333333333, 'board' => 'g', 'updated_num' => 3, 'views' => '123', 'notice' => 'Admin note: This thread is garbage.', 'secret' => 'a719c9a1', 'takedown_reason' => null, 'tweeted_at' => null]);
Post::create(['chan_id' => 333333333, 'thread_id' => 3, 'original_image_name' => 'Imgur.jpg', 'image_size' => 128000, 'image_width' => '535', 'image_height' => '535', 'thumb_width' => '250', 'thumb_height' => '250', 'image_url' => 'http://i.imgur.com/UmmyTUG.png', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 333333334, 'thread_id' => 3, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 333333335, 'thread_id' => 3, 'original_image_name' => 'Imgur 2.jpg', 'image_size' => 34000, 'image_width' => '500', 'image_height' => '466', 'thumb_width' => '116', 'thumb_height' => '125', 'image_url' => 'http://i.imgur.com/w6pQEvY.jpg', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 333333336, 'thread_id' => 3, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
##################
Thread::create(['id' => 4, 'thread_id' => 444444444, 'board' => 'q', 'updated_num' => 10, 'views' => '1250', 'notice' => null, 'secret' => 'a719c9a1', 'takedown_reason' => null, 'tweeted_at' => null, 'deleted_at' => DB::raw('NOW()')]);
Post::create(['chan_id' => 444444444, 'thread_id' => 4, 'original_image_name' => 'Imgur.jpg', 'image_size' => 128000, 'image_width' => '535', 'image_height' => '535', 'thumb_width' => '250', 'thumb_height' => '250', 'image_url' => 'http://i.imgur.com/UmmyTUG.png', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 444444445, 'thread_id' => 4, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 444444446, 'thread_id' => 4, 'original_image_name' => 'Imgur 2.jpg', 'image_size' => 34000, 'image_width' => '500', 'image_height' => '466', 'thumb_width' => '116', 'thumb_height' => '125', 'image_url' => 'http://i.imgur.com/w6pQEvY.jpg', 'imgur_hash' => 'something', 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
Post::create(['chan_id' => 444444447, 'thread_id' => 4, 'subject' => null, 'name' => 'Anonymous', 'tripcode' => null, 'capcode' => null, 'post_timestamp' => DB::raw('FROM_UNIXTIME(1429902005)'), 'body' => 'What is your movie editing software of choice? Pic related for me, but the things you can do it with are pretty limited. Is there a good (free) alternative for simple video editing?']);
}
public function get_total_rows($table, $param)
{
$select_total = $table->select(\DB::raw('sql_calc_found_rows ' . $param['select']));
$select_total = $select_total->get();
$select_total = \DB::select(\DB::raw("select found_rows() as total;"));
return $select_total[0]->total;
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->dateTime('announcement_expires')->nullable();
});
DB::update(DB::raw("UPDATE users SET announcement_expires = DATE_ADD(announcement_start, INTERVAL 7 DAY) WHERE announcement_start IS NOT NULL"));
}
public function scopeNearLatLong($query, $lat, $lng, $radius = 10, $unit = 69.0)
{
if (!is_numeric($lat) || -90 >= $lat || $lat >= 90) {
throw new RangeException("Latitude must be between -90 and 90 degrees.");
}
if (!is_numeric($lng) || -180 >= $lng || $lng >= 180) {
throw new RangeException("Longitude must be between -180 and 180 degrees.");
}
$subQuery = clone $query;
$latDistance = $radius / $unit;
$latNorth = $lat - $latDistance;
$latSouth = $lat + $latDistance;
$lngDistance = $radius / ($unit * cos(deg2rad($lat)));
$lngEast = $lng - $lngDistance;
$lngWest = $lng + $lngDistance;
$subQuery->selectRaw(DB::raw('*, (? * DEGREES(
ACOS(
COS(RADIANS(?)) * COS(RADIANS(latitude)) * COS(RADIANS(? - longitude))
+ SIN(RADIANS(?)) * SIN(RADIANS(latitude))
)
)) AS distance'))->addBinding([$unit, $lat, $lng, $lat], 'select');
$subQuery->whereBetween('latitude', [$latNorth, $latSouth]);
$subQuery->whereBetween('longitude', [$lngEast, $lngWest]);
$query->from(DB::raw('(' . $subQuery->toSql() . ') as d'));
$query->mergeBindings($subQuery->getQuery());
$query->where('distance', '<=', $radius);
// // To use:
// $latitude = 29.443778;
// $longitude = -98.478903;
// // Default radius is 10; default unit is miles.
// Model::nearLatLong($latitude, $longitude)->get();
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
if ($this->executable) {
Schema::create('sections', function (Blueprint $table) {
$table->increments('id');
$table->string('uid', 22)->nullable()->default(null);
$table->integer('course_id')->nullable()->unsigned()->default(null);
$table->string('name')->nullable()->default(null);
$table->string('description', 500)->nullable()->default(null);
$table->text('content')->nullable()->default(null);
$table->string('video')->nullable()->default(null);
$table->text('downloads')->nullable()->default(null);
$table->boolean('published')->nullable()->default(false);
$table->boolean('chapter')->nullable()->default(false);
$table->smallInteger('order')->nullable()->unsigned()->default(0);
$table->smallInteger('wait')->nullable()->unsigned()->default(24);
//wait in hours
$table->timestamp('opens_at')->nullable()->default(null);
//wait until datetime
$table->timestamp('created_at')->nullable()->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->nullable()->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
$table->foreign('course_id')->references('id')->on('courses')->onUpdate('cascade')->onDelete('cascade');
});
}
}
public function create()
{
$regions = Region::lists("name", "id");
$users = User::select(\DB::raw("CONCAT(surname, ' ', name) AS full_name, id"))->lists("full_name", "id");
$vehicles = Vehicle::lists("name", "id");
return View::make('Middle.Web.VehiclesRegionsAllotment.create', compact(['regions', 'users', 'vehicles']));
}
