Iam ByeBlog`s byeblogs

###Sketch trial non stop

Open hosts files:

$ open /private/etc/hosts Edit the file adding:

127.0.0.1 backend.bohemiancoding.com 127.0.0.1 bohemiancoding.sketch.analytics.s3-website-us-east-1.amazonaws.com Open .licence file

	[{
	"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",

	[{
	"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",

	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.

	// AndroidManifest.xml

	<activity
	android:name=".PopupActivity"
	android:theme="@android:style/Theme.Translucent.NoTitleBar">
	</activity>

	// PopupActivity.java

	package com.project.walkby;

	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();

	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

	{
	"employee_id": "1000",
	"full_name": "Abdul Rhazak",
	"nick_name": "Rhazak",
	"email": "[email protected]",
	"token_web": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9==",
	"status_code":"200",
	"msg":"Login success!"
	}