Iam ByeBlog`s byeblogs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT provinsi.id, provinsi.province_names as province_names, (SELECT COUNT(DISTINCT data_master_control.id_excel) FROM data_master_control WHERE data_master_control.provinsi_excel = provinsi.province_names) as jumlah_excel, (SELECT COUNT(DISTINCT data_master_control.id_cspro) FROM data_master_control WHERE data_master_control.provinsi_excel = provinsi.province_names) as jumlah_cspro, (SELECT COUNT(DISTINCT data_master_control.id_excel) FROM data_master_control WHERE data_master_control.provinsi_excel = provinsi.province_names AND data_master_control.status_clean_data = 'OK') as jumlah_data_clean FROM provinsi | |
| SELECT * FROM data_master_control where data_master_control.provinsi_excel = 'DKI Jakarta - UMUM' GROUP BY data_master_control.nama_krt_excel | |
| SELECT provinsi.id, provinsi.province_names as prov_id, (SELECT COUNT(DISTINCT data_master_control.id_excel) FROM data_master_control WHERE data_master_control.provinsi_excel = provinsi.province_names AND data_master_control.status_clean_data = 'OK') as jumlah |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public static class HttpPostUploadImageResearch extends AsyncTask<String, String, Reptyr.AsyncTaskResult<JSONObject>> { | |
| private static final String REQUEST_METHOD = "POST"; | |
| private static final int READ_TIMEOUT = 15000; | |
| private static final int CONNECTION_TIMEOUT = 15000; | |
| Activity activity; | |
| public HttpPostUploadImageResearch(Activity activity) | |
| { | |
| super(); |
byeblogs
/ Swipe Up Or Down Activity
Created
May 14, 2018 01:50
Example Of Swipe Up/Down Like A Facebook Comments..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // AndroidManifest.xml | |
| <activity | |
| android:name=".PopupActivity" | |
| android:theme="@android:style/Theme.Translucent.NoTitleBar"> | |
| </activity> | |
| // PopupActivity.java | |
| package com.project.walkby; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| See this video on youtube https://www.youtube.com/watch?v=McaJjAAo4DI | |
| Use the code below (copy and paste as instructed in the video above): | |
| sudo /Applications/Install\ OS\ X\ El\ Capitan.app/Contents/Resources/createinstallmedia --volume /Volumes/elcapitan --applicationpath /Applications/Install\ OS\ X\ El\ Capitan.app --nointeraction | |
| Important: The red text that I highlighted above (elcapitan) has to match the name you gave your volume when you were formatting the usb flash drive per the video, otherwise it won’t work. | |
byeblogs
/ data-cities-indonesia.json
Last active
August 28, 2018 11:07
Just example of json of Cities Indonesia..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "city_id": "1101", | |
| "province_id": "11", | |
| "city_name": "Simeulue", | |
| "city_name_full": "Kabupaten Simeulue", | |
| "city_type": "kabupaten" | |
| }, { | |
| "city_id": "1102", | |
| "province_id": "11", | |
| "city_name": "Aceh Singkil", |
byeblogs
/ data-provincies-indonesia.json
Created
August 28, 2018 11:09
Just example of json of Provincies Indonesia..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "province_id": "11", | |
| "province_name": "Aceh", | |
| "province_name_abbr": "NAD", | |
| "province_name_id": "Nanggroe Aceh Darussalam", | |
| "province_name_en": "Nanggroe Aceh Darussalam", | |
| "province_capital_city_id": "1171", | |
| "iso_code": "ID-AC", | |
| "iso_name": "Aceh", | |
| "iso_type": "autonomous province", |
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "code": "AAA", | |
| "lat": "-17.3595", | |
| "lon": "-145.494", | |
| "name": "Anaa Airport", | |
| "city": "Anaa", | |
| "state": "Tuamotu-Gambier", | |
| "country": "French Polynesia", | |
| "woeid": "12512819", |
byeblogs
/ data-countries.json
Last active
August 28, 2018 11:15
Just example of json of Countries..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { "name" : "Afghanistan", "code" : "AF"}, | |
| { "name" : "Åland Islands", "code" : "AX"}, | |
| { "name" : "Albania", "code" : "AL"}, | |
| { "name" : "Algeria", "code" : "DZ"}, | |
| { "name" : "American Samoa", "code" : "AS"}, | |
| { "name" : "AndorrA", "code" : "AD"}, | |
| { "name" : "Angola", "code" : "AO"}, | |
| { "name" : "Anguilla", "code" : "AI"}, | |
| { "name" : "Antarctica", "code" : "AQ"}, |
byeblogs
/ diff_range_of_hours.js
Created
August 31, 2018 11:00
Check diff range of hours, minutes, second in Javascript..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var startTime = moment('12:00:01', 'hh:mm:ss a'); | |
| var endTime = moment('13:00:10' , 'hh:mm:ss a'); | |
| var totalHours = (endTime.diff(startTime, 'hours')); | |
| var totalMinutes = endTime.diff(startTime, 'minutes'); | |
| var clearMinutes = totalMinutes % 60; | |
| console.log(totalHours + " hours and " + clearMinutes + " minutes"); |
byeblogs
/ Setting-MySql-Docker.txt
Last active
September 18, 2018 04:15
The server requested authentication method unknown to the client..
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| you can check by "docker inspect name_of_mysql_1" and then you can use IP of Gateway which is "172.18.0.1" | |
| "NetworkID": "05f4c08c374b61334709dc8ce4b5e5cad8b94e09c27b66b0ed64c89c8d585f1f", | |
| "EndpointID": "4830e8ae5f13cc983252374e1955f8731490e561603996e6c8265ccf79dea73b", | |
| "Gateway": "172.18.0.1", | |
| "IPAddress": "172.18.0.3", | |
| "IPPrefixLen": 16, | |
| "IPv6Gateway": "", | |
| "GlobalIPv6Address": "", | |
| "GlobalIPv6PrefixLen": 0, | |
| "MacAddress": "02:42:ac:12:00:03", |