Skip to content

Instantly share code, notes, and snippets.

View manuelgeek's full-sized avatar
😎
#mANuEl💯

Magak Emmanuel manuelgeek

😎
#mANuEl💯
View GitHub Profile
MERGE INTO f_on_time_perfomance b
USING (
SELECT RECORDID,to_char(flightdatetime,'YYYYMMDD') as end_date,to_char(numgmtdate,'YYYYMMDD') as start_date,CTFLIGHTNUMBER,ORIGIN,DESTINATION,STDUDT,OUTUDT,STAUDT,INUDT
FROM FSDAILY@MCREPORTS
) e
ON (b.on_time_perfomance_key = e.recordid )
WHEN MATCHED THEN
UPDATE SET b.date_key = e.end_date,b.dept_date = e.start_date,b.flight_no = e.ctflightnumber, b.flight_origin = e.origin, b.flight_destination = e.destination, b.std =e.stdudt,b.atd=e.outudt,
@manuelgeek
manuelgeek / kmskeys10.txt
Created November 29, 2017 06:31 — forked from bhochieng/kmskeys10.txt
Windows 10 KMS Keys
Windows.10.and.Office.2016.gVLK
#####################################################################
# Install/Uninstall keys #
#####################################################################
1.) Uninstall the current product by entering the “uninstall product key” extension:
slmgr.vbs /upk
2.) Install the key that you obtained above for “Windows Srv 2012R2 DataCtr/Std KMS for Windows 10”
@manuelgeek
manuelgeek / firefox-developer-edition.md
Created December 15, 2017 09:31 — forked from mahammad/firefox-developer-edition.md
How To install Firefox Developer Edition and create desktop icon for Ubuntu 14.04 LTS

chose other install way

  1. Open Terminal Ctrl+Alt+T Download Firefox Developer Edition tar file

    wget https://download.mozilla.org/?product=firefox-aurora-latest-ssl&os=linux64&lang=en-US

  2. Copy tar file to opt sudo cp -rp firefox-35.0a2.en-US.linux-x86_64.tar.bz2

  3. Open opt folder (cd /opt/) and untar file sudo tar xjf firefox-35.0a2.en-US.linux-x86_64.tar.bz2

@manuelgeek
manuelgeek / slugify.js
Created December 17, 2017 16:49 — forked from mathewbyrne/slugify.js
Javascript Slugify
function slugify(text)
{
return text.toString().toLowerCase()
.replace(/\s+/g, '-') // Replace spaces with -
.replace(/[^\w\-]+/g, '') // Remove all non-word chars
.replace(/\-\-+/g, '-') // Replace multiple - with single -
.replace(/^-+/, '') // Trim - from start of text
.replace(/-+$/, ''); // Trim - from end of text
}
@manuelgeek
manuelgeek / call back json
Created December 21, 2017 07:18
Mpesa Call Back Json pattern and saving
{
"Body": {
"stkCallback": {
"MerchantRequestID": "8948-2950929-465",
"CheckoutRequestID": "ws_CO_251120171533239788",
"ResultCode": 0,
"ResultDesc": "The service request is processed successfully.",
"CallbackMetadata": {
"Item": [
{
@manuelgeek
manuelgeek / Important
Created December 21, 2017 11:28
Links
​13 TB collections, you might require​
​BOOKMARK THIS​
Google drive movies - https://drive.google.com/drive/u/0/mobile/folders/0B6FjKMQKynZILTlwZHl4ajUwcFU
Programming language collection on google drive - https://drive.google.com/drive/folders/0ByWO0aO1eI_MN1BEd3VNRUZENkU
Books -
https://drive.google.com/drive/folders/0B0hgUX3me1_RNi1KTXBzXzdXSzA
Google drive hacking ebook collection - https://drive.google.com/drive/folders/0B-JzQsKoJaANbTFGN0RWLWhONms
Books for reading - https://drive.google.com/drive/folders/0B09qtt10aqV1SGxRVXBWYmNIS2M
@manuelgeek
manuelgeek / preference - user
Created December 22, 2017 20:17
manually activate sublime text 3 Material Theme
{
"color_scheme": "Packages/Material Theme/schemes/Material-Theme.tmTheme",
"theme": "Material-Theme.sublime-theme",
"ignored_packages":
[
"Vintage"
],
"material_theme_accent_orange": true
}
@manuelgeek
manuelgeek / Install MSSQL for php 7
Created January 8, 2018 06:48
Php 7.0 and MSSQL connection on Ubuntu
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql mssql-tools unixodbc-dev
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
echo "extension=sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
echo "extension=pdo_sqlsrv" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
<?php
namespace App\Providers;
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
class AppServiceProvider extends ServiceProvider
{
/**
<?php
use Illuminate\Foundation\Testing\WithoutMiddleware;
use Illuminate\Foundation\Testing\DatabaseMigrations;
use Illuminate\Foundation\Testing\DatabaseTransactions;
class AdminActivityTest extends TestCase
{
/**
* A basic test example.